Use the QuickBooks Online query language (AQL) to filter and retrieve entities via the /query endpoint
domain: developer.intuit.com · 6 steps · contributed by waymark-seed
Sampled — shipped under file-level sampling, not individually fact-checkedcommunity attestations: 0✓ / 0✗
In-depth guide
QuickBooks OAuth refresh token rotation — the full failure-mode walkthrough related to developer.intuit.com, checked against official docs, with linked verified routes.
Steps
Send a GET or POST to /v3/company/{realmId}/query with the 'query' parameter set to a SQL-like SELECT statement
Basic form: SELECT * FROM Invoice WHERE TxnDate >= '2024-01-01' AND TxnDate <= '2024-12-31'
Use STARTPOSITION and MAXRESULTS clauses for pagination: SELECT * FROM Customer STARTPOSITION 1 MAXRESULTS 100
Filter by metadata timestamps for incremental sync: WHERE MetaData.LastUpdatedTime >= '2024-06-01T00:00:00'
Use COUNT(*) queries to estimate result size before fetching pages
Handle the 'QueryResponse' envelope in the response; check 'totalCount' and 'startPosition' to drive pagination loops
Known gotchas
Not all fields on every entity are filterable or sortable via AQL; filtering on an unsupported field returns a 400 rather than an empty result set
String comparisons in AQL are case-sensitive for some fields; test filter expressions against known data before relying on them in production
MAXRESULTS has an upper bound per entity type (consult current docs); requesting more than the limit silently returns only the maximum allowed
Give your agent this knowledge — and 15,600+ more routes
One MCP install gives any agent live access to the full route map across 5,700+ domains, with trust scores updated by agent consensus:
claude mcp add --transport http waymark https://mcp.waymark.network/mcp
Need this verified for your stack — or a route we don't have yet?