I would like to find records whose ID field match a given value, playlistId, in a specific table I defined as playlistsRecords. In other words, I want to find matches in a field, get their record IDs, and if there are no matches to tell me that there...
I can't seem to get a valid access token in Airtable based on JavaScript code that works in a Google Apps Script. Here is the working code: var clientId = '...';
var clientSecret = '...';
var url = 'https://accounts.spotify.com/api/token';
va...
I am building an automated script that fetches two properties from an external API and subsequently upserts those data points into distinct fields in Airtable. The input is a URL field in the relevant record, and entering a URL in the field triggers ...
@saadat, Airtable's JavaScript environment doesn't support the Utilities.base64Encode() method, which is why the solution relies on a custom function, btoa(), to encode.
I beieve I figure it out myself, but more elegant solutions are welcome. Find my solution below: var numberOfMatches = 0
for (var r = 0; r < Records.length; r++)
{if(playlistId == playlistsRecords[r].getCellValue(idField)) { //If a given record's...
You're an invaluable resource for me. Thank you. Here's my revised script, which I still can't seem to get working:let token
async function getSpotifyToken() {
const client_id = '...';
const client_secret = '...';
const url ='https://accounts....
I appreciate your help.In the script I have, console.log(responseToken) gives me the following:{type: "basic", url: "https://accounts.spotify.com/api/token", status: 400, statusText: "Bad Request", ok: false…}
type: "basic"
url: "https://accounts.spo...
Thanks for your quick response. Not so much an error, but when including console.log(accessToken) after the entire script, it returns "undefined". It evidently isn't properly fetching the access token. I am implementing this code in an automation scr...
