No, but some experience is helpful. Here’s one approach to learning -
- Create a base and a simple table with ten records and a single field called “Name”.
- Create a Google spreadsheet
- Open a script project (see
Tools | Script Editor)
- Paste the code into the script
- Change the
baseName, baseID, tableName, and airtableAPIKey
- Save the script file (see disk button in top menu)
- Run the script function (see >
play button in the top menu)
- Select
View | Logs in the top menu - you should see ten record numbers and names listed.
Now you’re an API programmer. :winking_face:
//
// static vars
//
var baseName = "<base name>";
var baseID = "<base id>";
var tableName = "<table name>";
var airtableAPIKey = "<api key>";
var airtableAPIEndpoint = "https://api.airtable.com/v0/";
//
// get my table (first 100 records only)
//
function testGetMyTable()
{
// fetch the
var results = atGetMyTable_(tableName);
// parse the api results from airtable
var aRecords = JSON.parse(results).records;
// enumerate the records
for (var i in aRecords)
{
// log the record id's
Logger.log(aRecords[i].id + " :: " + aRecords[i].fields["Name"]);
}
return(true);
}
function atGetMyTable_(tableName)
{
const options = {
method: 'GET',
headers: {
'Authorization' : 'Bearer ' + airtableAPIKey,
'Content-type': 'application/json'
},
muteHttpExceptions : true
};
var response = UrlFetchApp.fetch(airtableAPIEndpoint + baseID + "/" + encodeURIComponent(tableName), options).getContentText();
return(response);
}
