Re: Unable to create more than 100 records using batch processing

1094 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I am subscribed to a Pro plan and am using Airtable to migrate our existing CMS which is just a MySQL table.

I need help adding 40000+ records from that mysql table. I am aware of the upper 100 limit for the api. So I wrote a custom node script that inserts 100 records at a time while reading them from my table.

I managed to import 200 records in a single shot successfully just an hour ago. But now when I try to add more (say 1000 at once) I start getting these errors:

'The service is temporarily unavailable. Please retry shortly.',
statusCode: 503 }

{ Error: connect EADDRNOTAVAIL []( - Local ([](
at internalConnect (net.js:884:16)
at defaultTriggerAsyncIdScope (internal/async_hooks.js:294:19)
at GetAddrInfoReqWrap.emitLookup [as callback] (net.js:1031:9)
at GetAddrInfoReqWrap.onlookup [as oncomplete] (dns.js:62:10)
syscall: 'connect',
address: '',
port: 443 }

What am I doing wrong? How Do I fix this?

1 Reply 1

Typically, a 503 means the server isn’t keeping up. That might be because of some abnormal server or network load that’s coincidentally hit — or it might be because your requests are hitting faster than 5/second. (I know it’s supposed to return a 429, but I’ve had instances where I got a 503 after I munged someone’s pacing code.) Try inserting a delay after every block of 5 requests, and see if that at least changes the symptoms. :winking_face: