Skip to main content

Export Orders

GET 

/api/amazon/:integrationInstance/orders/export

Export this integration instance's Amazon orders to a file. Streams a CSV download by default (Content-Type: text/csv); pass format=xlsx for an Excel file.

Filtering, searching, sorting and column selection mirror the orders list endpoint: filters is a JSON string ({"conjunction":"and|or","filterSet":[{"column","operator","value"}]}), query is a general text search, sortObjs is a JSON array of {"column","ascending"} objects, and included/excluded are JSON arrays of column names (mutually exclusive; sending both returns 400).

Pass total=1 to skip file generation and get the export size (rows x columns) back as JSON. Exports of up to 20,000 data points are generated synchronously and downloaded in the response; anything larger queues a background export job and the finished file is emailed to the requesting user (the request returns a redirect). Exporting an empty result set returns a JSON message instead of a file.

Request

Responses

OK

Response Headers
    Content-Type