Pull table as json and keep updated

[Joshua_Miller1]

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.

[Kamille_Parks]

I use the Publish app for my websites.

Airtable

Publish - Apps - Airtable Marketplace

Publish selected data from your Base for easy use on your public website. on Airtable with the Publish app.

[Joshua_Miller1]

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]

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 · Accepted solution]

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.

GitHub

GitHub - severo/airtable-github-json-export: Export airtable tables to...

Export airtable tables to json/geojson on Github. Contribute to severo/airtable-github-json-export development by creating an account on GitHub.

[GavinA]

Hello! Here is a quick and easy solution:

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