The Reconciliation API provides a detailed list of your end-user transactions for a specified period. The report can be generated in CSV or XML format, and you can filter the transactions based on the following criteria:

  • Start Date
  • End Date
  • One or more Site IDs
  • Transaction ID

Understanding and Using the Reconciliation API

To generate a reconciliation report, you can make a POST or GET request to the Reconciliation API. Typically, you would set up a script to request the report at regular intervals. If you need assistance with creating the script, please contact our Client Services department.

Your script will send the request to our API URL, and the response will be a CSV file (MIME type text/csv) or an XML file (MIME type text/xml). You can store or process the data based on your needs.

Procedure:

  1. Select the transactions to include:
    1. Start Date and End Date: A maximum of one month is allowed between the two dates. The end date cannot be in the future. If no end date is specified, only the data for the start date will be returned.
    2. Site ID: You can specify multiple Site IDs.
    3. Format: Choose between CSV or XML for the report format.
    4. Transaction ID: Specify a Vendo transaction ID to receive a report for a single transaction. If the transaction was unsuccessful, no data will be returned, and the transactionCount field will be 0.