Please guide me with the basic limitations for 50 requests at a time :)

Your first two scripts update a batch of records with updateRecordsAsync(), Note the s at the end of “records”.

However, your third script is not a batch operation. It updates only one record with updateRecordAsync. Note the lack of an s at the end of “record”. You cannot change this line to run on batches of 50 because updateRecordAsync is designed to run on only one record. This automation script looks like it is designed to update only one record–the triggering record. In order to update multiple records, the script runs multiple times–once for each triggering record.

Hi @kuovonne

Thank you for your detailed response. I appreciate the effort into explaining the theory as well. I understand it more now that the design is different and yes it is run through automation not like compared to the other 2 which is run through the script application.

The reason why I asked this, is that I am encountering a few errors “Error: network timeout at: https://api.airtable.com/v2/bases/appcgCGOdXru0MAwg/tables/tbl2tMlL5NSEpHIAf/records/update” for some records in the table being updated. There are 62 records on the table and most work fine but there are some inconsistencies. Is there a way to modify this script to be more reliable before I deploy it?

I also read this thread which was helpful, but sadly I dont know how to optimize this script even more. Automations: Scripting Actions Error from @Jeremy_Oglesby.

I just need advice on how to tweak this to run for large tables with hundreds or thousands of records.

Thank you so much!

When a script works for some records, but not others, I recommend looking for what is different about the records that fail. For example, this script will probably fail if the “ATH: QR Code | 512px” field is blank, although it is hard to tell without seeing the data and the field types.

Also keep in mind that the Amazon AWS outage last week affected Airtable attachments, but those issues should now be resolved.

BTW, your screen capture shows several input variables for the automation script, but you use only one of them (the recordId).

Hi @kuovonne

Thank you for still replying and trying to help me out. I have taken your response and I have been studying it. So what I did was to try to combine the 2nd script and 3rd script. I have tried to adjust it as well.

What I want to happen is:

1. Get the attachment from the URL provided


2. Attach the image on the attachment field.


3. Get the attached file.


4. Rename the filename


5. Reattach the file with the new file name.

Its quite a success already but when it comes to the stability, there a few errors and they are really random at times.

The error is,

ERROR

Error: network timeout at: https://api.airtable.com/v2/bases/appFZ1FheZKBic29q/tables/tblkHJXbEg8lt9xzG/records/update

at main on line 45

Out of 60 records tested. There is 1 error like this. Also, sometimes there will be 2? Sometimes a record worked properly, then when I try to rerun it again, that record would show an error.

This is used in an automation. The only variable is recordID for your reference.

I know that I am a bit close, just need some more tips.

Thank you so much!

Here is the code.

let config = input.config()



let submissionsTable = base.getTable('$MST');



let urlField = submissionsTable.getField('URl: $MST | Profile Pic');



let attachmentField = submissionsTable.getField('ATH: $MST | Profile Pic');



let query = await submissionsTable.selectRecordsAsync()



let record = query.getRecord(config.recordID)



let submissionsQuery = await submissionsTable.selectRecordsAsync();



let updates = [];



for (let record of submissionsQuery.records) {



    let url = record.getCellValue(urlField);



    let attachments = record.getCellValue(attachmentField);



    // If this record already has an attachment, skip it.



    if (url === null || attachments !== null) {



        continue;



    }



    // Otherwise, attach the image at the URL.



    updates.push({



        id: record.id,



        fields: {



            [attachmentField.id]: [{url: url}]



        }



    });



}



// Update records in batches of 50.



while (updates.length > 0) {



    await submissionsTable.updateRecordsAsync(updates.slice(0, 50));



    updates = updates.slice(50);



}



let newPrefix = record.getCellValueAsString('PROD_CODE | FileName')



let newExtension = String('.png')



let files = record.getCellValue("ATH: $MST | Profile Pic")



// Get the extension and add it to the new name



let newFiles = []



for (let file of files) {



    let newName = `${newPrefix}${newExtension}`



    newFiles.push({url: file.url, filename: newName})



}



// Reattach the item with the new filename



await submissionsTable.updateRecordAsync(record, {



    "ATH: $MST | Profile Pic": newFiles



});

let config = input.config()



let submissionsTable = base.getTable('$MST');



let urlField = submissionsTable.getField('URl: $MST | Profile Pic');



let attachmentField = submissionsTable.getField('ATH: $MST | Profile Pic');



let query = await submissionsTable.selectRecordsAsync()



let record = query.getRecord(config.recordID)



let submissionsQuery = await submissionsTable.selectRecordsAsync();



let updates = [];



for (let record of submissionsQuery.records) {



    let url = record.getCellValue(urlField);



    let attachments = record.getCellValue(attachmentField);



    // If this record already has an attachment, skip it.



    if (url === null || attachments !== null) {



        continue;



    }



    // Otherwise, attach the image at the URL.



    updates.push({



        id: record.id,



        fields: {



            [attachmentField.id]: [{url: url}]



        }



    });



}



// Update records in batches of 50.



while (updates.length > 0) {



    await submissionsTable.updateRecordsAsync(updates.slice(0, 50));



    updates = updates.slice(50);



}



let newPrefix = record.getCellValueAsString('PROD_CODE | FileName')



let newExtension = String('.png')



let files = record.getCellValue("ATH: $MST | Profile Pic")



// Get the extension and add it to the new name



let newFiles = []



for (let file of files) {



    let newName = `${newPrefix}${newExtension}`



    newFiles.push({url: file.url, filename: newName})



}



// Reattach the item with the new filename



await submissionsTable.updateRecordAsync(record, {



    "ATH: $MST | Profile Pic": newFiles



});

It sounds like the problem is that it takes too long to retrieve the attachment from Airtable.

Have you tried running the script in Scripting App from a button, instead of an automation? Automation scripts have time limitations.