How do I download transaction search results?
000001550
565
02/02/2022 17:05 PM
7.0
Answer
Transaction history and search results can be downloaded via the Merchant Interface using the Download to File Option. When using Download to File, the output file contains all fields for the displayed transactions and not just the fields shown on the screen.
In addition to the download feature of the Merchant Interface, we offer a Transaction Reporting API to access your transaction history and details programmatically. If you’re downloading large volumes of transactions or need more flexibility with your reports, you or your developer may want to consider using the
Transaction Reporting API. For more information, as well as the API guide, please visit https://developer.authorize.net/api/reference/features/transaction_reporting.html.
When searching for transaction history, keep in mind that using the full credit card number or bank account number as search criteria in Search only returns results for the past 180 days. However, when searching using a wildcard and the last 0-4 digits of the number (e.g., *4355, *355, *55, *5, *) results are returned for the past two years.
Using any other combination, such as a partial number, or a wild card among the last four digits of the number (e.g., 1425345, 4*355, 43*55, 435*) will return only results from the past 180 days.
It is recommended that you periodically download your transaction history to retain for your records. Authorize.Net keeps on file the current year and last two years worth of data/information.
To use the Download to File option:
- Log into the Merchant Interface.
- Click Transaction Search from the main toolbar.
- Search by the data or date criteria needed.
- Click Search at the bottom of the page.
- On the results page click Download to File. The "Select Download File Type" window will open.
- Select the download file type from the drop-down list.
- The Include Column Headings checkbox is selected by default. If you would like to exclude column headings in the file download, click the checkbox to deselect this option.
- Click Submit to download the file. A pop-up window appears indicating that the request for file download has been submitted. Do NOT close the window while the download file is being prepared. You can minimize the window to continue working while the download file is being prepared. Once the download file has been generated, the File Download dialogue box appears.
- In the File Download dialogue box, click Save to save the download file to your local system.
- The Save As dialogue box appears prompting you to select the location where the download file should be saved. Once you have selected the location, click Save.
- Click Close to close the Download Complete dialogue box.
A downloaded file contains several lines of information. Each line of information is a series of fields that represents an individual transaction. Each field contains information about the transaction, for example, the transaction amount or the Transaction ID. Each field is separated by a delimiter, a special character that indicates the end of one field and the beginning of another. Formatting the line of information in this way helps your computer system separate information from the downloaded transaction file into individual transactions.
For security reasons, all sensitive information, such as credit card and bank account numbers are masked in download files, meaning that only eight (8) characters or digits in length are provided; the first four (4) are masked and the last four (4) are visible (e.g., XXXX9876), regardless of the actual full length. Expiration dates are fully masked (e.g., XXXX).
Download File Formats
There are four transaction file download formats; each type is a fixed format:
- Standard/Tab Delimited — Basic transaction details such as payment method, amount, customer billing and shipping information, Address Verification Status, and transaction response. Each field will be separated by a tab character.
• Standard with Card Code/Tab Delimited — Basic transaction details such as payment method, amount, customer billing and shipping information, Address Verification Status, Card Code status and transaction response. Each field will be separated by a tab character.
• Expanded Fields/Comma Separated — Expanded transaction details such as payment method, amount, customer billing and shipping information, Address Verification Status, Card Code, Level 2 Data and with the addition of the reference transaction ID (for refunds). Each field will be separated with a comma.
• Expanded Fields with CAVV Response/Comma Separated — Expanded transaction details such as payment method, amount, customer billing and shipping information, Address Verification Status, Card Code, Level 2 Data, reference transaction ID (for refunds) and with the addition of the reference transaction ID (for refunds) CAVV (Verified By Visa or Mastercard SecureCode) response. Each field will be separated with a comma.
• Expanded Fields with CAVV Response in Excel - Expanded transaction details such as payment method, amount, customer billing and shipping information, Address Verification Status, Card Code, Level 2 Data, reference transaction ID (for refunds) and with the addition of the reference transaction ID (for refunds) CAVV (Verified By Visa or Mastercard SecureCode) response. In Excel file format.
See attachment for detais of the differences between the file formats.
Download to File Field List.pdf
Was this article helpful?