The ReportExport
endpoint schedules a job to export reports asynchronously. It returns an object describing the initial job status, a URI to poll for status updates, and a URI to download the job result file. You can check the status of a job using the Jobs endpoint.
Note: For the latest version, all columns will be visible by default. For versions older than version 14, you need to add the field you require data for, in the query string in order to have the desired columns visible in the CSV. For example, to see the Action Batch Date, you must add SHOW_ACTION_BATCH_DATE=1
to the query string.
Parameters
SUBAID
required for most reports
SUBAID
required for most reportsA program Id. Further refine the report to only retrieve data from a specific program.
StartDate
required for most reports
StartDate
required for most reportsFrom what date and time the report should retrieve data. See ISO 8601.
EndDate
required for most reports
EndDate
required for most reportsTo what date and time the report should retrieve data. See ISO 8601.
ResultFormat
optional
ResultFormat
optionalWhich file format the report will be returned in.
View possible enum values | |
---|---|
CSV | Returns the report file in CSV format. |
JSON | Returns the report file in JSON format. |
XML | Returns the report file in XML format. |
Find the report ID / handle
You can find a report's ID or handle in the URL bar when viewing a report in impact.com. The URL will include either an ID or handle at the end, e.g.:
https://app.impact.com/secure/mediapartner/viewReport.report?id=401
https://app.impact.com/secure/mediapartner/report/viewReport.report?handle=mp_io_history
In this scenario, your report ID is 401 and the handle is mp_io_history. You may use either the ID or the handle in your request, like this:
curl 'https://api.impact.com/Mediapartners/A1b2C3d4E5f6G7h8I9j0K1l2M3/ReportExport/mp_io_history'
Example Request
curl 'https://api.impact.com/Mediapartners/<AccountSID>/ReportExport/<Id>' \
-X GET \
-u '<AccountSID>:<AuthToken>' \
-H 'Accept: application/json' \
Example Response
{ "Status": "QUEUED",
"QueuedUri": "/Mediapartners/<AccountSID>/Jobs/d8807a9f-a5ee-4e3f-ad2b-3dfd19d1915f",
"ResultUri": "/Mediapartners/<AccountSID>/Jobs/d8807a9f-a5ee-4e3f-ad2b-3dfd19d1915f/Download"
}