Skip to main content

Fetching an external API (yelps API) with airtable


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?

3 replies

Forum|alt.badge.img+3
  • Participating Frequently
  • 586 replies
  • March 12, 2020

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.


Forum|alt.badge.img+19
  • Inspiring
  • 3264 replies
  • March 12, 2020

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.


Bill_French wrote:

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.


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.


Reply