Export quotes as CSV
AI agents: read /llms.txt; add .md to any page URL. This page as Markdown: /reference/quotes/v1-quote-export.md. Index of every page and the rules for every call: /llms.txt. Guides and concepts in one file: /llms-full.txt. OpenAPI: /openapi.json.
POST/
Downloads a CSV file of the published quotes whose issue date is in a range. Drafts and deleted quotes are left out.
Send start_date and end_date as ISO 8601 date-times, for example 2026-11-01T00:00:00Z and 2026-11-30T23:59:59Z. They are compared as given, so a date alone means midnight UTC and an end date of 2026-11-30 leaves out most of that day.
The rows have the sales order export's columns, read from each quote. With list_only: true they come back as JSON in data instead of a file (an empty range answers data: []), and the quote number is in quote_id. In the CSV file the number's column is headed order_id and comes out empty: read the number from the JSON rows, or match quotes by name.
Business rules
start_dateandend_dateare required.
Path parameters
Your team slug, shown as Team ID next to your API key in Profile.
- Example
your-team
- Example
Request body
application/json, required.
End of the issue date range (ISO 8601).
Start of the issue date range (ISO 8601).
list_onlybooleantrue to get the rows as JSON instead of a CSV file.
Response
200The CSV file, or with list_only: true the rows as JSON.
Fields of each item (30)
balance_duestringInvoiced total minus paid. A decimal string with 2 decimal places, such as
"1250.00"; parse it as a decimal.client_notestring | nullcreatorstringCreated By's name, or an empty string.
customer_brand_profilestring | nullcustomer_contact_namestring | nullcustomer_emailstring | nullcustomer_in_hand_datestringYYYY-MM-DD, or an empty string.customer_namestring | nullcustomer_po_numberstring | nullcustomer_tax_exemptstring- One of:
"TRUE","FALSE"
- One of:
discountstringInvoiced discount;
"0.00"until invoiced. A decimal string with 2 decimal places, such as"1250.00"; parse it as a decimal.issue_datestringYYYY-MM-DDin the team's time zone.jobsstring | nullThe jobs, one per line.
last_payment_datestring | nullnamestring | nullThe order's name. JSON rows only: the CSV file has no
namecolumn.paidstringTRUEwhen the invoiced total is paid.- One of:
"TRUE","FALSE"
- One of:
payment_termstring | nullpricing_groupstring | nullpricing_strategystring | nullprod_notestring | nullproduction_due_datestringYYYY-MM-DD, or an empty string.production_start_datestringYYYY-MM-DD, or an empty string.quote_idstringThe quote number (not the id). In the CSV file this column is named
order_idand comes out empty.shipment_due_datestringYYYY-MM-DD, or an empty string.statusstring | nullThe status label.
subtotalstringThe value of the order's lines. A decimal string with 2 decimal places, such as
"1250.00"; parse it as a decimal.tagsstring | nullTag names, comma-separated.
taxstringInvoiced tax;
"0.00"until invoiced. A decimal string with 2 decimal places, such as"1250.00"; parse it as a decimal.totalstringInvoiced total;
"0.00"until invoiced. A decimal string with 2 decimal places, such as"1250.00"; parse it as a decimal.warehousestring | null
Errors
401The API key is missing or wrong (
unauthenticated).403You are not allowed to do this.
api_access_not_in_plan: your team's plan doesn't include API access (Pro and above, with an active subscription or trial), so every request answers this until the team upgrades. When your role lacks the permission the operation needs, the body is only{"message": "Insufficient Permission"}. Other refusals use the error envelope, withunauthorizedoruser_is_not_authorized.- When
- The role lacks
view_report. This error has no envelope: the body is{"message": "Insufficient Permission"}. - Fix
- Ask the team owner for report permission.
404Not found.
page_not_found: the team slug is unknown, you are not a member of the team, or an id in the path is not one of this team's.code: null, with a message that starts "No query results for": there is no record with that id.422The request was refused and changed nothing.
validation_failedlists what to fix inerror.fields; other codes name a business rule, explained inerror.message. A few checks answer with only{"message": "..."}. An operation that calls another service (a payment provider, a carrier, an accounting app) can answerconnect_timeout("Please retry again") when that service does not answer in time: the change may or may not have happened there, so read the record back before you retry.- When
- No quote is in the range, for the file:
quote_export_error"Quotes not found". (Withlist_only: truethe answer isdata: [].) - Fix
- Widen the range.
Related
- POSTExport sales orders as CSV
/v1/ api/ store/ {team_slug}/ sales_order/ export - POSTList quotes
/v2/ api/ store/ {team_slug}/ v2/ quote/ filter
