ItemQuery qbXML example
Reads items of every type in one request.
qbXML
ItemQueryRq, version 16.0
<?xml version="1.0" encoding="utf-8"?>
<?qbxml version="16.0"?>
<QBXML>
<QBXMLMsgsRq onError="stopOnError">
<ItemQueryRq iterator="Start">
<MaxReturned>100</MaxReturned>
<ActiveStatus>ActiveOnly</ActiveStatus>
</ItemQueryRq>
</QBXMLMsgsRq>
</QBXML>
Open in the validator
Check it against the qbXML 16.0 schema, edit it, and run it in your own QuickBooks.
Things to know
- Page large results: iterator="Start" with MaxReturned on the first request, then iterator="Continue" with the iteratorID from the answer.
- The answer mixes types (ItemServiceRet, ItemInventoryRet and so on), each with its own fields.
- A FullName filter ignores case.
The same request with QuBe Sync's API
QuBe Sync takes these parameters, writes the qbXML for you and delivers QuickBooks' answer to your webhook as JSON.
GET
/api/v2/connections/{connection_id}/items
?active_status=ActiveOnly
&iterator=true
&max_returned=100
Every field ItemQuery takes is in Intuit's reference.
More requests
Items