QuickBooks Online

Query invoices, customers, payments, and reports via the QuickBooks API.

Environment Variables

• QUICKBOOKS_ACCESS_TOKEN - OAuth 2.0 access token
• QUICKBOOKS_REALM_ID - Company ID (realm ID)

Query customers

curl -s -H "Authorization: Bearer $QUICKBOOKS_ACCESS_TOKEN" \
  -H "Accept: application/json" \
  "https://quickbooks.api.intuit.com/v3/company/$QUICKBOOKS_REALM_ID/query?query=SELECT%20*%20FROM%20Customer%20MAXRESULTS%2010" | jq '.QueryResponse.Customer[] | {Id, DisplayName, PrimaryEmailAddr, Balance}'

List invoices