Can Airtable hit our API to keep data current?

[Ron_Daniel]

I have built a database in Airtable that is unfortunately just a static import from my company’s database.

However, we do have an API that can grab full files or deltas (in JSON). Can Airtable access it to stay current? If so, where should I be looking for info on that?

Thanks!

[kuovonne]

Look into using fetch in Scripting to access your API. The script can parse the JSON apply changes.

Note that there are some differences between Automation Scripts and Scripting app, including different limitations. The scripting documentation and scripting action documentation are good place to start.