LedgerWire

Customer · Query

simulated in sandbox

CustomerQuery

Customers are the people and companies you invoice. In QuickBooks Desktop they live in the Customer:Job list, share a name space with vendors and employees, and carry balances that QuickBooks maintains for you.

qbXML request

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

JSON equivalent

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

qbXML response (from the sandbox seed data)

CustomerQueryRs
<?xml version="1.0" ?>
<QBXML>
  <QBXMLMsgsRs>
    <CustomerQueryRs requestID="1" statusCode="0" statusSeverity="Info" statusMessage="Status OK">
      <CustomerRet>
        <ListID>80000055-1794881749</ListID>
        <TimeCreated>2026-02-22T15:05:35+00:00</TimeCreated>
        <TimeModified>2026-02-22T15:05:35+00:00</TimeModified>
        <EditSequence>1771772735</EditSequence>
        <Name>Lakeshore Mechanical Co</Name>
        <FullName>Lakeshore Mechanical Co</FullName>
        <IsActive>true</IsActive>
        <Sublevel>0</Sublevel>
        <CompanyName>Lakeshore Mechanical Co</CompanyName>
        <FirstName>Andre</FirstName>
        <LastName>Lopez</LastName>
        <BillAddress>
          <Addr1>Lakeshore Mechanical Co</Addr1>
          <Addr2>2944 Park Blvd</Addr2>
          <City>Omaha</City>
          <State>NE</State>
          <PostalCode>68102</PostalCode>
          <Country>US</Country>
        </BillAddress>
        <Phone>(652) 555-9874</Phone>
        <Email>andre@lakeshoremechanical.example</Email>
        <Contact>Andre Lopez</Contact>
        <TermsRef>
          <FullName>Due on receipt</FullName>
        </TermsRef>
        <JobStatus>None</JobStatus>
        <Balance>1951.00</Balance>
        <TotalBalance>1951.00</TotalBalance>
      </CustomerRet>
    </CustomerQueryRs>
  </QBXMLMsgsRs>
</QBXML>

FAQ

How do I page through CustomerQuery results?

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

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

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

Why does CustomerQuery 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 CustomerQuery 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 Customer messages

Other Query messages

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

Get a free sandbox key