Export Transactions
The transactions List Transactions returns, as a spreadsheet: the same filters, the same scope, newest first, without pages.
The v3 counterpart of the spreadsheet formats of GET /api/v2/transactions/export, with the same columns in the same order. The PDF statement is only offered by v2 for now.
Authorization:
Every request is signed with your API key: a short-lived JWT, signed with your private key, sent in one header on /v3/* and /api/v2/* alike.
Headers:
Authorization: APIKey {SIGNED_JWT}
How to build and sign the JWT: Authentication.
Endpoint
/v3/transactions/export
Query parameters
Every parameter of List Transactions except page and limit, and:
| Parameter | Type | Description |
|---|---|---|
format | string | xlsx (the default) or csv. |
Response
The file itself, as an attachment named transactions-<UTC timestamp>.<format>. A CSV is UTF-8 with a byte-order mark and keeps every amount as its exact decimal; a spreadsheet writes amounts as numbers with eight decimals.
The file holds at most 10,000 rows: the newest. When more matched, the response carries X-Export-Truncated: true and the file ends with a note saying so — narrow the window or the filters to get the rest.
| Column | Description |
|---|---|
| Date | When the transaction was created, UTC, 2006-01-02 15:04:05. |
| Transaction ID | The txn_… id. |
| Reference | |
| Type | crypto, bank, trade or platform_fee. |
| Subtype | A trade's side, a bank transfer's rail (ach_pull for an ACH pull; a wire adds its kind), a platform fee's period. |
| Direction | deposit or withdraw, on a transfer. |
| Status | |
| Customer Email | |
| Amount, Amount Currency | What went in. |
| Fee, Fee Currency | |
| Settle Amount, Settle Amount Currency | What came out: a trade's other leg, a transfer's total after fees. |
| Rate | A trade's rate, or a crypto coin's USD rate when it was recorded. |
| Network | A crypto transfer's network. |
A cell a kind does not have is empty; one that came to nothing is 0. In a CSV, a text cell that a spreadsheet would run as a formula starts with '.
Errors
| Status | message | When |
|---|---|---|
400 | as in List Transactions | A filter is malformed or names nothing that exists. |
401 | unauthorized | Missing or invalid signature. |
403 | forbidden | An account-scoped key named another account in account_id. |
422 | validation message | format is not xlsx or csv, or another value is out of its range. |
Support and Resources
If you need assistance or have any questions, our support team is here to help. You can contact our support team at support@blockwyre.com.
Stay Updated
Stay up-to-date with the latest news, updates, and features from BlockWyre by following us on social media:
- Instagram: BlockWyre Instagram
- Twitter: BlockWyre Twitter
- Facebook: BlockWyre Facebook
- LinkedIn: BlockWyre LinkedIn
We are excited to have you on board and look forward to seeing how you leverage BlockWyre's powerful tools to enhance your financial operations. Happy integrating!