Method Community

 

10k limit on API calls

Last post 07-01-2012 11:14 AM by Method_Paul. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 05-31-2012 9:00 AM

    10k limit on API calls

    API'ers.

    In rare situations where you are pulling a large number of records, please know that we had to put in a 10,000 record limit in place.

    If you have to pull more than 10k records, please do it in iterations, so:

    1. Grab desired records.

    2. If record count is less than 10,000, then great, you're done.

    3. If record count is 10,000, repeat your query, but this time add WHERE RecordID > 123 (replace 123 with the highest RecordID from your previous query).

    4. Repeat step 2 and 3 until you have all the records you need.

     

    Of course, for pure efficiency, best practice has always been to make good use of filters so that you only pull what you need in the first place.

    Paul

  • 07-01-2012 11:14 AM In reply to

    Re: 10k limit on API calls

    FYI - to anyone reading this. This was changed from a 10k limit to a 1,000,000 cell limit.

    So if you have only 10 fields you are pulling out, we allow up to a 100k record pull at a time.

    Paul

Page 1 of 1 (2 items)