Home Inspire Application File Imports Release Notes Sync Web Services FAQ Search

Loyalty Program Reward Redemption Export/Import Pair Import

Intended Application

Used in conjunction with the identically named composite export, in order to batch update reward canceled and/or redeemed information.  The export file is downloaded, modified, and re-imported to complete the total process.

 

Notes

  • No header.  First record is processed.
  • Only redeemed and canceled information will be updated.
  • Rewards cannot be un-canceled or un-redeemed.

 

File Structure

DATA COLUMN

DATA TYPE DATA REQUIRED? FORMATTING NOTES

Reward Id

Numeric

Yes

   
Account Id Alphanumeric Yes    
Reward External Reference Alphanumeric Yes    
Reward Name Alphanumeric Yes    
Reward Point Value Decimal Yes    
Issued Timestamp Date/Time Yes MMDDYYYYHHMMSS UTC timezone.
Canceled Status Alphanumeric Yes   Allowed values (Y, N)
Canceled Timestamp Date/Time No MMDDYYYYHHMMSS Required, if canceled. UTC timezone.
Redeemed Status Alphanumeric Yes   Allowed values (Y, N)
Redeemed Timestamp Alphanumeric No   Required, if redeemed. UTC timezone.
Redeemed Location External Reference Alphanumeric No   Required, if redeemed.

 

 

Sample File

1:
2:
3:
4:
MemberRewardId|MemberAccountId|RewardTypeExternalRef|RewardTypeName|RewardPointValue|IssueTimestamp|CancelStatus|CancelTimestamp|RedeemStatus|RedeemTimestamp|RedeemLocation
1|65006||Racing T-Shirt|1700.0000|10172008203306|N||N||
2|65006||Racing T-Shirt|1700.0000|10172008204307|N||N||
3|65006||Racing T-Shirt|1700.0000|10202008144321|N||N||

Kognitiv Logo

Please note: All external Kognitiv Loyalty links and references are directed to US datacenter unless specifically noted.

Tags:
Home: Kognitiv Loyalty © 2023 Kognitiv Corporation. All Rights Reserved.