Automations error (but not on Block): Response status was 302 'Moved Temporarily' but redirect mode was set to 'error'

[Mike_Mauer]

Has anyone else experienced this?

I have a JSON object I am trying to fetch from Google Scripts Web App. It works great in the Block Script editor, but when I try to use the same code in the Automation block I receive this error:

TypeError: Response status was 302 ‘Moved Temporarily’ but redirect mode was set to ‘error’

This error is referring to the Google Script URL.

[Greg_Jarmiolows]

Super annoying. I am writing enough code to forget this is a no code platform yet failures…

Any chance you could elaborate here Bill on the POST and backfill.

[Bill_French]

Greg_Jarmiolowski:

Any chance you could elaborate here Bill on the POST and backfill.

Sure.

The POST is the easy part; plenty of examples like this.

If you can use a POST to at least push the record ID to the external process (like a script in Google Apps Script or AutoCode), that process can call back into Airtable using the API, perform everything it needs to, and then update Airtable itself with results and or call into other systems.

This approach is ideal in cases where 302 redirects are required to get the results back. Lacking a response, all you can do is have the external process complete the action. Kludgey, but it works.

[Greg_Jarmiolows]

Ok, thanks. I am actually just trying to fetch a .wav file from a URL but I get the same pattern of errors in this post.

[Bill_French]

Greg_Jarmiolowski:

I am actually just trying to fetch a .wav file from a URL but I get the same pattern of errors in this post.

Okay - so we can safely say that the domain hosting the .wav file is employing redirects (probably for security reasons) and if so, you need a proxy in the middle that can take a request from Airtable, make the request using redirect : "follow", and then return the data to Airtable.

I would take a look at the idea of using AutoCode for this; they have a generous free tier of like 100k requests per month.

[Greg_Jarmiolows]

Thanks. I am already processing parts in Zapier and will try them first.