September 22, 20214 yr 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.
September 22, 20214 yr 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.
September 22, 20214 yr Author 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.
Create an account or sign in to comment