Export Payments

GET 
/api/qbo/payments/export

Download the QuickBooks Online payments synced into SKU.io as a CSV file. The export is streamed from the locally synced copies; no request is made to QuickBooks.

Not yet available to API tokens

This endpoint currently requires session authentication; Personal Access Token scope support is in progress.

CSV columns: QBO ID, Customer ID, Customer Name, Total Amount, Currency, Transaction Date, Payment Method, Reference Number, Active, QBO Created At, QBO Updated At, Local Created At, Local Updated At.

The response is a file download (Content-Type: text/csv) with a filename of the form qbo_payments_export_2026-07-07_10-30-00.csv. By default all records (active and archived) are included; use the query parameters to narrow the export.

Returns a 500 error if no QuickBooks Online integration has been set up, and a 422 error if a date parameter is not in MM/DD/YYYY format.

Authentication: Requires Bearer token.

Request

Responses

200

Successful response

401

Unauthenticated — the bearer token is missing, revoked, expired, or malformed. Never retry automatically; fix the credential. See the Errors guide.

403

Forbidden — the token lacks a required scope, the endpoint is not available to API tokens, or the user behind the token lacks the permission. A human must adjust the token scopes or user permissions; do not retry.

429

Rate limited — platform limit is 1,000 requests/min; individual tokens may carry lower limits. Honor the Retry-After header before retrying. See the Rate Limits guide.