Excel power query to airtable API

Andrew_Jones1 · ‎Mar 23, 2021

I have created an excel power query to retrieve data from airtable, I would need to expand this to be able to pull from multiple tables which is fine. My question is, has anyone encountered any issues with making multiple data pulls a day from airtable and getting IP address blocked, similar to what can happen with web scraping data?

Bill_French · ‎Mar 23, 2021

Hi @Andrew_Jones1, and welcome to the community!

No.

There are two ways to pull data from Airtable -

Via a webhook
Via an API call

In both cases, you establish a trusted integration. The API requires a key that only you can retrieve, and the webhook requires a URL that is known only to people with access to the data. With trusted requests, you are not scraping, and therefore, you will never encounter this issue.

See Solution in Thread

Bill_French · ‎Mar 23, 2021

Hi @Andrew_Jones1, and welcome to the community!

No.

There are two ways to pull data from Airtable -

Via a webhook
Via an API call

In both cases, you establish a trusted integration. The API requires a key that only you can retrieve, and the webhook requires a URL that is known only to people with access to the data. With trusted requests, you are not scraping, and therefore, you will never encounter this issue.