The CSV file that contains information of redeemed coupons. Each row in CSV file can contain following fields(columns marked with * are mandatory).
Customer identifier* : Field used to identify the customer, it can be userId, mobile, email or externalId. (userId will have more preference over the other customer identifiers, in case of multiple values)
Coupon identifier* : Field used to identify the redeemed coupon, It can be couponId, couponCode. (couponId has more preference over couponCode in case of multiple values)
Redeemed date in milliseconds* : Coupon redeemed time in Epoch
Redeemed at* : Coupon redeemed till’s Id
Bill Id : Transaction Id
Bill Number : Transaction Number Details.
Sample file content:
File content sample 1:
redeemed date in millis, redeemed at, user id, coupon id, bill id, bill number, details 1603128622000,50015497,23599838,23456,1603128596000
luci_auto_15039.
File content sample 2:
redeemed date in millis, redeemed at, mobile, coupon code ,bill id, bill number, details 1603128622000,50015497,9988776655,ABCDEF1,1603128596000
luci_auto_15039
uploadHeaders*
int
The sequence (starts from 0) of the columns in the attached csv file. This field accepts stringified JSON.
Key name for the columns are as follows: Customer identifier* : Key name for this field varies according to the customerIdentifier param. MOBILE : mobile EXTERNAL_ID: externalId EMAIL: email USER_ID: userId Coupon identifier* : Key name for this field varies according to the couponIdentifier param. COUPON_ID: couponId COUPON_CODE: couponCode Redeemed date in milliseconds* : redeemedDateInMillis Redeemed at* : redeemedAt Bill Id : billId Bill Number : billNumber Details : details