Quickbooks Online Plug-in - 500 record limit?!?

[ZoXo]

Query on the customer table returns 500 results.  I want to pull all 9000+

I do not find anything in the documentation that discusses how to do this, please advise.

 

[PCIPal]

Please refer to page 54 in the link: https://www.productivecomputing.com/documents/FM_Books_Connector_Online/Developers_Guide_FM_BooksConnectorOnline.pdf

Example shows pulling active customers 10 at a time, but it can be adjusted, But due to Intuit's limits on bandwidth and data throttling you can not pull more than 500 records in a single request.

[ZoXo]

Thank you!

I was able to use your example and move the start position of the query.

So instead of 10 at a time, I gather all 500, then reset the start position to 501

I keep my max results at 500.  At the end of the first loop, I check for start position vs. 500

if they agree, I add another 500 to max results, and loop around again for the next 500

At the end of the second loop, I compare the start position to the results of the query of the customer count

if position vs. customer count agree, exit the loop

Ran it and it imported all 6683 active customers.