Skip to main content
Solved

How to Work Around API Limits

J

I can only request 15 new record creations with a single API call.


// create a People-Holiday::Christmas record for each person in the People table

people.map(person => {

    peopleHolidaysTable.createRecordAsync({

        'Person' : [{id: `${person.id}`}],

        'Holiday' : [{id: 'reclZYRpInJiev0ce'}]

    });

});

I have 33 people in my array. I’m not terribly proficient with async programming in JS yet. What is the proper way to chunk this into 3 API calls of 15/15/3? I suspect I need to split it up into arrays of 15 and then have each call await the one previous with a timeout of 1000ms.


Anyone able to provide some guidance on how to do that?

Best answer by Emma_Yeap

Hi Jeremy,


We rate-limit blocks to 15 writes per second and batch methods allow modification of 50 records in one call. Your current code looks like it does a separate API call for each person, so you’re running into the 15 writes per second limit.


You could switch your code to use the batch createRecordsAsync instead of createRecordAsync to get around this. You could also do what you suggested (split the calls and await each previous one). The time it takes for the write to complete (while you await) should be long enough that you wouldn’t need to include an additional timeout.


For the first option, it’d look like this:


peopleHolidaysTable.createRecordsAsync(people.map(person => ...))

For the second option, we have an example on how to that in the “Size limits & rate limits” section of this guide: Airtable Blocks SDK as well as in the Wikipedia Enhancement example block: https://github.com/Airtable/blocks/blob/master/examples/wikipedia-enrichment-block/frontend/index.js#L117


Sorry for the late response, hope this is still helpful!

View original
    Did this topic help you find an answer to your question?

    2 replies

    E
    • Emma_Yeap
    • Inspiring
    • 55 replies
    • Answer
    • January 17, 2020

    Hi Jeremy,


    We rate-limit blocks to 15 writes per second and batch methods allow modification of 50 records in one call. Your current code looks like it does a separate API call for each person, so you’re running into the 15 writes per second limit.


    You could switch your code to use the batch createRecordsAsync instead of createRecordAsync to get around this. You could also do what you suggested (split the calls and await each previous one). The time it takes for the write to complete (while you await) should be long enough that you wouldn’t need to include an additional timeout.


    For the first option, it’d look like this:


    peopleHolidaysTable.createRecordsAsync(people.map(person => ...))

    For the second option, we have an example on how to that in the “Size limits & rate limits” section of this guide: Airtable Blocks SDK as well as in the Wikipedia Enhancement example block: https://github.com/Airtable/blocks/blob/master/examples/wikipedia-enrichment-block/frontend/index.js#L117


    Sorry for the late response, hope this is still helpful!

    M
    T
    J
    3 people like this
    • M
      Michelle_Valent
    • T
      Tom_Keysers
    • J
      Jeremy_Oglesby
    J
    • Jeremy_Oglesby
    • Author
    • Inspiring
    • 1691 replies
    • January 18, 2020
    Emma_Yeap wrote:

    Hi Jeremy,


    We rate-limit blocks to 15 writes per second and batch methods allow modification of 50 records in one call. Your current code looks like it does a separate API call for each person, so you’re running into the 15 writes per second limit.


    You could switch your code to use the batch createRecordsAsync instead of createRecordAsync to get around this. You could also do what you suggested (split the calls and await each previous one). The time it takes for the write to complete (while you await) should be long enough that you wouldn’t need to include an additional timeout.


    For the first option, it’d look like this:


    peopleHolidaysTable.createRecordsAsync(people.map(person => ...))

    For the second option, we have an example on how to that in the “Size limits & rate limits” section of this guide: Airtable Blocks SDK as well as in the Wikipedia Enhancement example block: https://github.com/Airtable/blocks/blob/master/examples/wikipedia-enrichment-block/frontend/index.js#L117


    Sorry for the late response, hope this is still helpful!


    Very helpful — thank you, @Emma_Yeap!

    Reply


    Most helpful members this week

    Terms & Conditions