Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Excel power query to airtable API

Topic Labels: API
Solved
Jump to Solution
477 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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.