LedgerWire

Item · Query

simulated in sandbox

ItemQuery

ItemQuery returns every item type in one list: service, inventory, non-inventory, other charge, subtotal, discount, group and more.

qbXML request

ItemQueryRq
<?xml version="1.0" encoding="utf-8"?>
<?qbxml version="13.0"?>
<QBXML>
  <QBXMLMsgsRq onError="stopOnError">
    <ItemQueryRq requestID="1">
      <MaxReturned>10</MaxReturned>
      <ActiveStatus>ActiveOnly</ActiveStatus>
    </ItemQueryRq>
  </QBXMLMsgsRq>
</QBXML>

JSON equivalent

GET /v1/items?limit=10&status=active
GET /v1/items?limit=10&status=active
curl
curl "https://ledgerwire.vibiz.app/v1/items?limit=10&status=active" \
  -H "Authorization: Bearer $LEDGERWIRE_KEY"
Sends this exact qbXML to the shared demo sandbox (simulated sample data).

qbXML response (from the sandbox seed data)

ItemQueryRs
<?xml version="1.0" ?>
<QBXML>
  <QBXMLMsgsRs>
    <ItemQueryRs requestID="1" statusCode="0" statusSeverity="Info" statusMessage="Status OK">
      <ItemServiceRet>
        <ListID>80000019-1794881749</ListID>
        <TimeCreated>2026-04-29T03:44:37+00:00</TimeCreated>
        <TimeModified>2026-04-29T03:44:37+00:00</TimeModified>
        <EditSequence>1777434277</EditSequence>
        <Name>Installation</Name>
        <FullName>Installation</FullName>
        <IsActive>true</IsActive>
        <Sublevel>0</Sublevel>
        <SalesOrPurchase>
          <Desc>Installation labor, per hour</Desc>
          <Price>95.00</Price>
          <AccountRef>
            <ListID>8000000E-1760321749</ListID>
            <FullName>Service Income</FullName>
          </AccountRef>
        </SalesOrPurchase>
      </ItemServiceRet>
    </ItemQueryRs>
  </QBXMLMsgsRs>
</QBXML>

FAQ

How do I page through ItemQuery results?

In qbXML, add iterator="Start" to ItemQueryRq with MaxReturned, then send iterator="Continue" with the iteratorID until iteratorRemainingCount is 0. With LedgerWire, GET /v1/items?limit=100 and follow nextCursor.

How do I fetch only items changed since my last sync?

Use FromModifiedDate inside ItemQueryRq, or updatedAfter=2026-10-01T00:00:00Z on the REST endpoint.

Why does ItemQuery return statusCode 1?

Status 1 is informational: "A query request did not find a matching object in QuickBooks". The request was valid and nothing matched the filters. LedgerWire returns an empty data array for it.

Sandbox fidelity

The LedgerWire sandbox simulates ItemQuery with QuickBooks rules: required fields, element names, refs that must exist (3140), unique names (3100), field lengths (3070) and EditSequence locking (3200). Tax calculation, custom fields and preferences are not simulated.

Other Query messages

Skip the XML: call GET /v1/items with JSON.

Get a free sandbox key