LedgerWire

ItemService · Query

simulated in sandbox

ItemServiceQuery

Service items are labour and services you sell or buy. They carry either SalesOrPurchase (one account) or SalesAndPurchase (separate income and expense accounts).

qbXML request

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

JSON equivalent

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

qbXML response (from the sandbox seed data)

ItemServiceQueryRs
<?xml version="1.0" ?>
<QBXML>
  <QBXMLMsgsRs>
    <ItemServiceQueryRs 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>
    </ItemServiceQueryRs>
  </QBXMLMsgsRs>
</QBXML>

FAQ

How do I page through ItemServiceQuery results?

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

Why does ItemServiceQuery 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 ItemServiceQuery 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 ItemService messages

Other Query messages

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

Get a free sandbox key