Fetching an external API (yelps API) with airtable

[Cristian_Romero]

Hi,

I want to fetch yelp API just how I would fetch it in postman and save every contact in the excel sheet.

does anyone have a youtube tutorial or step by step how to?

[Andrew_Johnson1]

The newly introduced Scripting Block would be able to help you connect to the Yelp API.

Check out this link for a more detailed explanation as to how the Scripting block works.

Airtable - Support

Scripting block overview

The scripting block can streamline your workflows when you want to modify field information, add multiple records at once, filter with complex criteria, and more. The scripting block is part of Air...

[Bill_French]

Cristian_Romero:

and save every contact in the excel sheet.

If the requirement is to push Airtable data into Microsoft Excel, the Excel sheet must exist as an addressable entity, namely in Office365 which exposes the target sheet via this API.

But your question is in conflict with the title of this post. The title suggests you want to move data between Yelp and Airtable, but the text asks about Microsoft Excel. Did you really mean Airtable? Or Excel?

In any case, you can approach this in many ways including Script Blocks and the Airtable API in modern scripting languages.

[Cristian_Romero]

Hey Bill, I am sorry I meant Airtable.

The idea is to fetch the data from Yelp - and store the values I need in my Airtable tab.

but i havent found much luck putting a nice solution together.