Airtable Scraper

A package used to scrape any public airtable.

Table of Contents

• Install
• Usage
  • Table Data
  • Save Airtable As ...
  • Metadata

Install

pip install airtable_scraper

Usage

After install, you can use this code for testing (replace url with your own airtable shared view url).

from airtable_scraper import AirtableScraper

url = "https://airtable.com/app7rljHYfQ4tfGrq/shrJ2psoFssctoP5o"
table = AirtableScraper(url=url)

# check status code (ex. 200 = success)
print(table.status)

Table Data

print(table.data)

Save Airtable As ...

CSV

• String: If no filepath is provided, returns a csv formatted string.

csv_str = table.to_csv()

• CSV File: If a filepath is provide, save as a csv file. (Change "my_table.csv" to your own filename)

table.to_csv("my_table.csv")

JSON

• String: If no filepath is provided, returns a json formatted string.

json_str = table.to_json()

• JSON File: If a filepath is provide, save as a json file. (Change "my_table.json" to your own filename)

table.to_json("my_table.json")

Python Dictionary

Converts data into python dictionary format.

• orient: Use orient parameter to change the type of values of the dictionary.
  • "records": list like [{column -> value}, … , {column -> value}]
  • "index": dict like {index -> {column -> value}}

data_d = table.to_dict()

Pandas DataFrame

Save data to Pandas DataFrame.

df = table.to_dataframe()

Metadata

You can use these helper methods to checkout additional Airtable metadata or http request parameters.

Airtable Information

print a summary of the airtable, including the airtable column type and python datatype.

table.info()

Additional Airtable shared view information

print(table.view_id)
print(table.table_id)
print(table.app_id)
print(table.share_id)

HTTP Request Parameters & Responses

print(table.headers)
print(table.request_id)
print(table.raw_rows_json)
print(table.raw_columns_json)