Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 21, 2020 03:04 PM
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.
Feb 16, 2021 01:21 PM
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.
Feb 16, 2021 01:33 PM
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.
Feb 16, 2021 01:36 PM
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.
Feb 16, 2021 01:41 PM
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.
Feb 16, 2021 01:51 PM
Thanks. I am already processing parts in Zapier and will try them first.