Help

Excel power query to airtable API

Topic Labels: API
Solved
Jump to Solution
982 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Andrew_Jones1
4 - Data Explorer
4 - Data Explorer

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?

1 Solution

Accepted Solutions
Bill_French
17 - Neptune
17 - Neptune

Hi @Andrew_Jones1, and welcome to the community!

No.

There are two ways to pull data from Airtable -

  1. Via a webhook
  2. 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

1 Reply 1
Bill_French
17 - Neptune
17 - Neptune

Hi @Andrew_Jones1, and welcome to the community!

No.

There are two ways to pull data from Airtable -

  1. Via a webhook
  2. 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.