Help

Problem when using scripting to add records

988 4
cancel
Showing results for 
Search instead for 
Did you mean: 
normalGuy
5 - Automation Enthusiast
5 - Automation Enthusiast

There are 131 fields in my table. After retrieving 2000 records and making them synchronize their fields, i only receive success for 300 records when using scripting to import them to my Airtable table. Why is this?

normalGuy_0-1712938107640.png

 

4 Replies 4
Clasicwebtools
5 - Automation Enthusiast
5 - Automation Enthusiast

I think it could be a problem of Hitting Airtables API limit. You could try pulling by batches and adding some sleep functions to discard this problem.

Would you mind sharing a bit more of context on the script?

My script is executed as follows:
First I will fetch the API to my database, and then I will get about 2000 records. Then I will get the data type of each field in the first element and use createFieldAsync to create fields for the Test table on Airtable. After that, the data of the records I retrieve will be added to the Test table by using createRecordAsync . But only about 200-300 records were added successfully. But when I use createRecordsAsync to add data I get this error? How to specifically display that error? 

normalGuy_0-1713150377910.png

 

I checked and found that it seems due to airtable's API limitations that I need to split the data up to be able to insert it successfully.

Clasicwebtools
5 - Automation Enthusiast
5 - Automation Enthusiast

Great to know you could solve it!