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

All qbXML examples