Pre-Existing Report: All Transactions

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

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

Notes:

• 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!)
• Use the restrict_by_user parameter to limit the transactions to only those recorded by that user.
• To include non-transaction "customer activated" transactions, include the parameter show_activations and set it to Yes.

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_all';
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><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_id>
19. </transaction>
20. <transaction>
21. ...
22. </transaction>
23. </response>

Error XML Response:

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