Downloading On-Demand Purchase and Refund Detail Report

The Purchase and Refund Detail Report contains purchase and refund details that have been submitted to your payment processor. Merchants using certain payment processors will also see fee and funding data. To request the report, your client application must send an HTTP GET message to the report server. The default format for responses is JSON, but some reports can also return CSV or XML. You can set the response to return CSV or XML in the request header by setting the

Accept

value to either

application/xml

or

text/csv

.

Format the URL as follows:

On-Demand Purchase and Refund Detail Report URL Values

Value	Description	Required/ Optional
< url_prefix >	Name of the server from which to download the report. Use one of these values: Test: apitest.cybersource.com Production: api.cybersource.com Production in India: api.in.cybersource.com	Required
< startTime >	Report start date to search on in ISO 8601 format. Example: 2016-11-22T12:00:00.000Z	Required
< endTime >	Report end date to search on in ISO 8601 format. Example: 2016-11-22T12:00:00.000Z	Required
< organizationId >	The organization ID under which the report is subscribed. This can be the merchant ID, account ID, or reseller ID.	Optional
< paymentSubtype >	Payment subtypes. The default value is ALL . Valid values: ALL: All Payment Subtypes VI: Visa MC: Mastercard AX: American Express DI: Discover DP: PINless Debit	Optional
< viewBy >	View results by request date or submission date. The default value is requestDate . Valid values: requestDate: Request Date submissionDate: Submission Date	Optional
< groupName >	Group name, which is defined in the Group Management Module in the Business Center .	Optional
< offset >	Controls the starting point within the collection of results, which defaults to 0. The first item in the collection is retrieved by setting a zero offset. For example, if you have a collection of 15 items to be retrieved from a resource and you specify limit=5, you can retrieve the entire set of results in 3 successive requests by varying the offset value: offset=0 , offset=5 , and offset=10 . If an offset larger than the number of results is provided, this will result in no embedded object being returned.	Optional
< limit >	Controls the maximum number of items that may be returned for a single request. The default is 2000.	Optional