Skip to main content

Problem when using scripting to add records

  • April 12, 2024
  • 4 replies
  • 37 views

Forum|alt.badge.img+4

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?

 

4 replies

Forum|alt.badge.img+3
  • Participating Frequently
  • April 14, 2024

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?


Forum|alt.badge.img+4
  • Author
  • New Participant
  • April 15, 2024

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? 

 


Forum|alt.badge.img+4
  • Author
  • New Participant
  • April 15, 2024

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?


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.


Forum|alt.badge.img+3
  • Participating Frequently
  • April 16, 2024

Great to know you could solve it!