joe-irving/airtable_full_backup

Full Backup Of Airtable Data

Only backs up the record data, table schemas and attachments.

Does not back up interfaces and automations.

Requirements

To run this you need:

• Python 3
• python-dotenv module
• pyairtable module
• requests module

Installed by running python -m pip install python-dotenv requests pyairtable

Set up

1. Go to https://airtable.com/create/tokens
2. Create an API token with the scopes:
   • data.records:read
   • schema.bases:read
3. Create a .env file in the base directory
4. Add the line AIRTABLE_ACCESS_TOKEN=<paste your token in replace of this>

Running the backup

Run python airtable_backup.py in the root directory.

Once it is done, you can zip and upload your backup to wherever you would like to keep it.

airtable_full_backup's Issues

Works perfectly

Thank you.

Colons in {datetime.now()} result in invalid path on Windows

airtable_full_backup/airtable_backup.py

Line 10 in 64fc5bb

backup_dir = f"./backups/{datetime.now()}"

C:\Programs\airtable_full_backup>airtable_backup.py
Traceback (most recent call last):
  File "C:\Programs\airtable_full_backup\airtable_backup.py", line 12, in <module>
    os.makedirs(backup_dir)
  File "C:\Users\PC\AppData\Local\Programs\Python\Python310\lib\os.py", line 225, in makedirs
    mkdir(name, mode)
OSError: [WinError 123] The filename, directory name, or volume label syntax is incorrect: './backups/2023-03-11 00:17:02.026826'

[Solution] No module named 'dotenv'

Might wanna add this to the instructions since the obvious pip install dotenv didn't actually work
python -m pip install python-dotenv