I need an AirTable consultant to help me create a solution (on AirTable) that enables my data partners to upload and publish their data for distribution on my platform (outside AirTable).
Partner can upload new or overwrite data.
Partner data updates are validated in real-time against my data model.
Partner can manage a mapping to data model separately so they don’t have to change their source spreadsheet prior to upload.
AirTable automatically links each entity to a matching entity in my lookup table.
AirTable highlights unlinked rows in the partner data with a warning (not error)
Partners can publish data updates. AirTable should automatically manage snapshots.
AirTable triggers web hook that automatically received data updates or triggers automatic download data using the AirTable API. I will be responsible for setting up the web hook or data syncing process on my end.
I am able to provision and manage multiple partners accounts from a single company account.
I will be able to provide a sample spreadsheet from a single partner, my data model, and discuss any questions you have when we connect.