Creating a google app script, to sync one-way from a google sheet to an Airtable Table
I am trying to create a google App Script, which contains columns mapping to an Airtable table. I would like to sync one-way from the Google Sheet, into Airtable. The first column is the primary key, and is used to match. If the record exists in Airtable, it will update. Else, it will create a new row.I am trying to execute the below function, to find out if the record exists already by primary key value (Note - NOT record ID). function upsertAirtableRecord(apiKey, baseId, tableName, primaryKey, fields, primaryKeyFieldName) {
var url = 'https://api.airtable.com/v0/' + baseId + '/' + encodeURIComponent(tableName);
// Search for the record to update
var searchUrl = url + '?filterByFormula=(' + encodeURIComponent(`{${primaryKeyFieldName}}='${primaryKey}'`) + ')';
var options = {
method: 'get',
headers: {
Authorization: 'Bearer ' + apiKey,
},
}; This is returning an error: Exception: Request failed for https://api.airtable.com returned code
