CODEWITHSUNDEEP
intuit-partner-platformquickbooks-online
The Machete
The Machete

Reputation: 255

Does QBO v3 QueryService limit responses to 100 rows? Can I set a higher limit?

I am using QueryService to retrieve a list of customers. This seems to limit the number of returned rows to 100 rows, maximum.

Here is my code:

QueryService<Intuit.Ipp.Data.Customer> customerQueryService = new QueryService<Intuit.Ipp.Data.Customer>(serviceContext); 
List<Intuit.Ipp.Data.Customer> customers = customerQueryService.Select(c => c).ToList();

How do I set a higher limit for the maximum number of returned rows?

Upvotes: 1

Views: 614

Answers (1)

William Lorfing
William Lorfing

Reputation: 2656

https://developer.intuit.com/docs/0025_quickbooksapi/0050_data_services/020_key_concepts/00300_query_operations

Maximum Number of Entities in a Response

The maximum number of entities that can be returned in a response is 1000. If the result size is not specified, the default number is 100. If a query returns many entities, fetch the entities in chunks, as described in Pagination. To determine the number of entities that a particular query returns, probe by using the COUNT keyword in the query. See Count for details.

Upvotes: 5

Related Questions