BillQuery qbXML example
Reads unpaid bills.
qbXML
BillQueryRq, version 16.0
<?xml version="1.0" encoding="utf-8"?>
<?qbxml version="16.0"?>
<QBXML>
<QBXMLMsgsRq onError="stopOnError">
<BillQueryRq iterator="Start">
<MaxReturned>100</MaxReturned>
<PaidStatus>NotPaidOnly</PaidStatus>
<IncludeLineItems>true</IncludeLineItems>
</BillQueryRq>
</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.
- Line items are left out unless IncludeLineItems is true.
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}/bills
?include_line_items=true
&iterator=true
&max_returned=100
&paid_status=NotPaidOnly
Every field BillQuery takes is in Intuit's reference.
More requests
Vendors and purchases