How to query a table on a separate base?

Is it possible to programmatically with Airtable scripting load a different base from the one in which the script is running? I’d like to automatically sync views from one base to another with the scripting block, but it’s looking like that might not be possible?

It definitely is possible, but requires use of the standard Airtable API from within the Scripting Block script.

Also, syncing is a tricky problem to solve. One-way syncing isn’t too bad - if you just want to update “Base 2” with whatever the current state is of “Base 1”, that can be done relatively easily by making a GET request to “Base 1” with the Airtable API, and matching up records from the GET request to records in “Base 2”, and then using the Scripting Block’s updateRecordsAsync() method to update “Base 2” so that it looks like “Base 1”.

Two-way syncing is a whole different issue - now you have to move data both ways, resolve conflicts, and determine which Base’s data should win out. This does not lend itself to a short forum explanation :slight_smile:

1 Like

I’m only looking for a one-way sync here so this is great news! Muchas gracias!

1 Like

De nada.

You can access the standard API with specifics for the base you want to access from the “Help” menu of the base you want to access.

1 Like

Hey, I am trying to do the same! @Nicole_Lopez, did you manage to do it? Do you have any resource or example you could share as a reference?

Thanks a lot!