How to Sync Data Between Two Airtable Bases Using the API?

[MackoSawko]

Hi everyone,

I have two bases in Airtable: "Employees" and "Projects". Previously, I managed everything in a single base, but I decided to split the data for better clarity. Now, I want to fetch data from the "Employees" table in one base and automatically add it to the "Projects" table in another base using the API.

In the "Projects" table, I have an "Employee" field where multiple employees can be assigned to a single project (e.g., Project 1 has Employee 1 and Employee 2). I'd like these employees to be displayed as a list.

I already have an API token set up, but I'm not sure how to fetch the data and display it in the "Employee" field so that they can be added to a project. Could someone guide me on how to do this?

Thanks for your help!

[ScottWorld]

With Airtable, it’s typically best & most convenient to keep everything in one base unless there is a security reason for separating the data.

However, if you’d like to keep the 2 tables in 2 separate bases, you don’t need to use the API to sync data. You can just use Airtable’s Sync feature to sync the data.

More details here:  https://support.airtable.com/docs/sync-overview-articles

— ScottWorld, Expert Airtable Consultant