Pre-Existing Report: Search Customers
Generate a report with all the customers who have a transaction between two date ranges in the selected campaigns, and whose information contains the search text.
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 |
|
customers_search |
|
Required |
|
|
|
date_start |
|
2010-01-01 |
|
Required |
|
|
|
date_end |
|
2011-12-31 |
|
Optional |
|
|
|
selected_campaigns |
|
123456789012,21987654321 |
|
Required |
|
|
|
search_text |
|
Doe |
|
Required |
|
|
|
include_transactions_search |
|
Y |
|
Optional |
|
|
|
|
|
|
|
|
|
|
|
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:
Example PHP Request:
If you are using PHP, the $data array would look like this:
- $data['user_id'] = 'john1970';
- $data['user_password'] = '1959caadac9b13dcb3';
- $data['account_id'] = 'greatwidgets';
- $data['type'] = 'reports';
- $data['report'] = 'customers_search';
- $data['search_text'] = 'cheese';
- $data['date_start'] = '2010-01-01';
- $data['date_end'] = '2011-12-31';
- $data['selected_campaigns'] = '123456789012,210987654321';
Success XML Response (New / Updated User):
- <response status="success">
- <customer>
- <first_name>Jane</first_name>
- <last_name>Doe</last_name>
- <phone>555-5555</phone>
- <email>jdoe@email.com</email>
- <address1>123 Main St.</address1>
- <address2>Apt 3G</address2>
- <city>Anytown</city>
- <state>ND</state>
- <zip>12345</zip>
- <country>NZ</country>
- <custom1>She likes cheese!</custom1>
- <custom_date>1970-07-14</custom_date>
- <customer_username>jdoe123</customer_username>
- <card_number>11111111</card_number>
- <customer_code>4137071924090694</customer_code>
- </customer>
- <customer>
- ...
- </customer>
- </response>
Error XML Response:
- <response status="error">
- <error>Error message</error>
- </response>
|