Pull table as json and keep updated

Joshua_Miller1 · ‎Jan 07, 2022

I am trying to pull all the data from one of my tables and dump it into a json. Is their an easy way to do this? I have read and tried to follow the github for airtable.js but seem to be a bit lost.

Thank you.

Joshua_Miller1 · ‎Jan 12, 2022

For anyone looking for a solution even though its 2 years old it still works. And heroku will allow you do a pull every 10 minutes for free. If you want to pull less than the whole table you’ll have to modify it. You will also have to modify it if you want it to export anywhere other than github.

See Solution in Thread

Kamille_Parks · ‎Jan 07, 2022

I use the Publish app for my websites.

Joshua_Miller1 · ‎Jan 11, 2022

I will take a look at that but it requires pro was hoping for something a little more cost friendly as we are a small company using this.

Kamille_Parks · ‎Jan 11, 2022

You could write your own script that converts your table to json. That would be free, but not “easy” if you’re less familiar with javascript.

Joshua_Miller1 · ‎Jan 12, 2022

For anyone looking for a solution even though its 2 years old it still works. And heroku will allow you do a pull every 10 minutes for free. If you want to pull less than the whole table you’ll have to modify it. You will also have to modify it if you want it to export anywhere other than github.

GavinA · ‎Jan 02, 2024

Hello! Here is a quick and easy solution:

https://www.csvgetter.com/blog/airtable-json-export-tutorial