Skip to main content
GET /merchants/{id}/transactions and POST /merchants/{id}/transactions:search answer a file for Accept: text/csv or Accept: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet. Lists, Pagination and Filters says how to ask for one. The file has a header row, then one row per transaction in the list’s order, each from the transaction’s full representation:
  • A link is its target’s id, in a column named after the field with _id, such as payout_id.
  • An amount is a decimal in the currency’s major units, at its ISO 4217 exponent: 45.50 for GBP 45.50, 1000 for JPY 1000, 12.340 for KWD 12.340. Its currency is in the column after it. In Excel it’s a number shown at those places, so a spreadsheet sums it, and every other cell is text, so a value that looks like a formula is never evaluated. A file is an exception to the money format, as an event’s earlier fields are.
  • An instant is RFC 3339 in UTC, as in JSON, and an enum value is the one the representation holds.
  • true and false are written as words, and null is an empty cell.
  • | separates several values in one cell.
A file leaves out required_actions, which a single read explains, rewards, the refunds collection link, the customer_details link, the one-time checkout and failure’s message. It holds no customer details.