API DOCUMENTATION Last Update: July 2025

Pre-Existing Report: All Redeemed Transactions

Generate a report with all the redeemed transactions between two date ranges in the selected campaigns.

 

Headers

  Key   Value   Note
api_access_key user_api_key Optional

 

 

The data to be submitted to the API is composed of the following fields:

 

  field   Example   Note
user_id john1970 Required
user_password 1959caadac9b13dcb3 Required if not included in the headers
account_id greatwidgets Required
type reports Required
report transactions_redeemed Required
date_start 2010-01-01 Required
date_end 2011-12-31 Optional
last 9242 Optional. Last Transaction ID. View Notes
selected_campaigns 123456789012,21987654321 Required
Output Format:
output JSON or XML Optional. If not provided, defaults to XML
callback someFunctionName Optional: JSONP format
condensed yes Optional (No white space)
Applies only to JSON(P) output

 

Notes:

  • Headers: the user_api_key value can be included in either the header section or the body of the request. If the key is provided in both locations, the API will process and validate only the value provided in the headers.

  • The date_start and date_end must be provided in ISO 8601 format: YYYY-MM-DD, where YYYY is the year in four-digit format, MM is the month in 2-digit format, and DD is the day of the month in two digit format. This avoids all sorts of confusion as to which part of the date is represented in which position and allows for better and more natural date-based sorting.
  • Use the last parameter to limit the results to those transactions recorded after the "Last" Transaction ID you have included in the request.
  • Separate each selected_campaigns with a comma (no spaces!)

 

Example PHP Request:

If you are using PHP, the $data array would look like this:

  1. $data['user_id'] = 'john1970';
  2. $data['user_password'] = '1959caadac9b13dcb3';
  3. $data['account_id'] = 'greatwidgets';
  4. $data['type'] = 'reports';
  5. $data['report'] = 'transactions_redeemed';
  6. $data['date_start'] = '2010-01-01';
  7. $data['date_end'] = '2011-12-31';
  8. $data['selected_campaigns'] = '123456789012,210987654321';

 

Success XML Response (New / Updated User):

  1. <response status="success">
  2. <transaction>
  3. <code>1850396893739825</code>
  4. <date>2011-08-10</date>
  5. <authorization>20% Discount</authorization>
  6. <campaign_id>123456789012</campaign_id>
  7. <user_name>Store_Clerk</user_name>
  8. <user_custom1></user_custom1>
  9. <first_name>Demo</first_name>
  10. <last_name>McDemo</last_name>
  11. <phone>555-5555</phone>
  12. <email>mcdemo@example.com</email>
  13. <custom1></custom1>
  14. <redeemed>R</redeemed>
  15. <code_to_show>1111111111111</code_to_show>
  16. <amount_number>-250</amount_number>
  17. <amount_type>Points</amount_type>
  18. <transaction_id>4338</transaction>
  19. </transaction>
  20. <transaction>
  21. ...
  22. </transaction>
  23. </response>

 

Error XML Response:

  1. <response status="error">
  2. <error>Error message</error>
  3. </response>