I’m setting up a new table in Airtable and using automation to calculate aggregate values. I require the daily EUR exchange rate and plan to fetch it via an API. Could anyone advise on how to perform a REST API call from within Airtable automation?
Airtable automation does not currently support direct HTTP calls natively, so a workaround is needed. One option is to use the Scripting action within an automation which allows you to use JavaScript code to call external APIs using the fetch() function. In one of my projects, I set up a script that executed the request and processed the response data. If more complex functionality is required, consider integrating with services such as Zapier or Integromat to bridge the gap between Airtable and your target API.