Customer · Query
simulated in sandboxCustomerQuery
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
<?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-01curl "https://ledgerwire.vibiz.app/v1/customers?limit=10&updatedAfter=2026-10-01" \
-H "Authorization: Bearer $LEDGERWIRE_KEY"qbXML response (from the sandbox seed data)
<?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
Skip the XML: call GET /v1/customers with JSON.
Get a free sandbox key