Apr 12, 2024 09:14 AM
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?
Apr 14, 2024 11:51 AM
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?
Apr 14, 2024 08:06 PM
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?
Apr 14, 2024 09:28 PM
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.
Apr 16, 2024 04:21 PM
Great to know you could solve it!