Airtable action – SYNC data not only APPEND

[kzzzr]

Hey,

I've tried Airtable action and discovered that it just inserts new records into a table.

      await Promise.all(records.map(async (record: any) => {
        return new Promise<void>((resolve, reject) => {
          table.create(record, (err: { message: string } | null, rec: any) => {
            if (err) {
              reject(err)
            } else {
              resolve(rec)
            }
          })
        })
      }

What I am looking for is way of syncing data from Looker to Airtable:

• UPDATE existing records
• INSERT new records
• Leave DELETED records untouched
• Leave derived columns in Airtable untouched

Any help or suggestions would be much appreciated.