LedgerWire

ItemInventory · Query

simulated in sandbox

ItemInventoryQuery

Inventory items are stock QuickBooks tracks with quantity on hand and average cost. They need an income, a COGS and an asset account.

qbXML request

ItemInventoryQueryRq
<?xml version="1.0" encoding="utf-8"?>
<?qbxml version="13.0"?>
<QBXML>
  <QBXMLMsgsRq onError="stopOnError">
    <ItemInventoryQueryRq requestID="1">
      <MaxReturned>10</MaxReturned>
      <ActiveStatus>ActiveOnly</ActiveStatus>
      <FromModifiedDate>2026-10-01T00:00:00</FromModifiedDate>
    </ItemInventoryQueryRq>
  </QBXMLMsgsRq>
</QBXML>

JSON equivalent

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

qbXML response (from the sandbox seed data)

ItemInventoryQueryRs
<?xml version="1.0" ?>
<QBXML>
  <QBXMLMsgsRs>
    <ItemInventoryQueryRs requestID="1" statusCode="0" statusSeverity="Info" statusMessage="Status OK">
      <ItemInventoryRet>
        <ListID>8000002D-1794871862</ListID>
        <TimeCreated>2026-02-04T23:59:57+00:00</TimeCreated>
        <TimeModified>2026-02-04T23:59:57+00:00</TimeModified>
        <EditSequence>1770249597</EditSequence>
        <Name>Copper Pipe 1/2in</Name>
        <FullName>Copper Pipe 1/2in</FullName>
        <IsActive>true</IsActive>
        <Sublevel>0</Sublevel>
        <QuantityOnHand>108</QuantityOnHand>
        <AverageCost>18.20</AverageCost>
        <AssetAccountRef>
          <ListID>80000005-1760311862</ListID>
          <FullName>Inventory Asset</FullName>
        </AssetAccountRef>
        <COGSAccountRef>
          <ListID>8000000F-1760311862</ListID>
          <FullName>Cost of Goods Sold</FullName>
        </COGSAccountRef>
        <IncomeAccountRef>
          <ListID>8000000D-1760311862</ListID>
          <FullName>Sales Income</FullName>
        </IncomeAccountRef>
        <PurchaseCost>18.20</PurchaseCost>
        <PurchaseDesc>Copper pipe, 1/2 in x 10 ft</PurchaseDesc>
        <ReorderPoint>2</ReorderPoint>
        <SalesDesc>Copper pipe, 1/2 in x 10 ft</SalesDesc>
        <SalesPrice>32.50</SalesPrice>
      </ItemInventoryRet>
    </ItemInventoryQueryRs>
  </QBXMLMsgsRs>
</QBXML>

FAQ

How do I page through ItemInventoryQuery results?

In qbXML, add iterator="Start" to ItemInventoryQueryRq 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 ItemInventoryQueryRq, or updatedAfter=2026-10-01T00:00:00Z on the REST endpoint.

Why does ItemInventoryQuery 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 ItemInventoryQuery 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.

More ItemInventory messages

Other Query messages

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

Get a free sandbox key