Development & APIs

I’m using the API to update an Airtable table on a daily basis. Everyday I’d get around 100 records to be updates or created on the table. What’s the best way to tell Airtable to either update the record if a specific field matches a record which already exists otherwise create a new one? Do I need to perform a search for each one of the records manually or is there a better way to do that? Thanks!

Hi community. I’m very new to JS so apologies if this seems basic :pray: . I’m using Twilio Functions (node.js) to load to AirTable all incoming texts. I’m utilizing 2 tables - “Receive Text” with columns Text date, Text Body and UID. “Users” with columns UID and Phone Number (and a bunch of others). When a text comes in, I’m trying to use FilterByFormula with the phone number to retrieve the user’s UID from the “Users” table. Here’s the code I’m running - var filter = "({Phone Number} = '" + event.From + "')"; base('Users').select({ filterByFormula: filter }).eachPage(function page(records, fetchNextPage) { records.forEach(function(record) { console.log('Retrieved ', record.get('UID')); alert('Retrieved ', record.get('UID')); }); fetchNextPage(); }, function done(error) { console.log(error); }); let message = { "UID" : record.get('UID'

Hi all, I was wondering if there was a way to link records with the Airtable API?

I wish Parabola had an Airtable export feature, but in the meantime, I’m struggling with the code to allow me to create records in Airtable with multiple associated linked records. I got it to work when there is only a single linked record in a field, but I keep receiving a 422 error code saying “invalid record id” whenever there are multiple linked records. The record ids going into {id (1) (concat)} below are a comma separated string (i.e. recXXXXYYYZZZ, recAAAABBBBCCCC). The code I’m using is below. Thanks for any help that you can provide. { "fields": { "Client": ["{id}"], "Timesheet Items": ["{id (1) (concat)}"] } }

Does it copy the entire source directory to a base or only the built output?

I’d like to prompt the user for the password to an API call but input.textAsync displays the input in plain text on the screen. Is there a way to mask the input so it shows as ********** when the user is typing? Like with HTML input type=password?

I’m seeing this error today in my custom block, but don’t think that I’ve changed anything dramatically in my code. Can someone tell me the fix? Thanks.

Hello, I have been working towards mapping some CSVs into one of my bases using the Scripting Block. Since I’m new to JavaScript, I’ve been using a lot of the documentation within the Scripting Block, which has been super helpful for what I need. One issue I have run into is during the mapping process, where I’m mapping the fields in my Base to the fields within my CSV. The format of mapping a field for me generally looks like this: data.FieldName Where “data” represents the parsed contents of my file and “FieldName” represents the name of the field within that file. My issue is that, in some of the files I would like to use, there are special characters and spaces within the names of the fields. Meaning I would like have a mapping that might look something like this: data.Field Name # For spaces, I attempted to use underscores but wasn’t able to get that to work. When using a special character like # or /

I am attempting to map a csv file to one of my bases via scripting due to some pre-processing I would like to do, however, I began running into issues with parsing. Figuring that I had made a mistake I created a new script to test a more simple csv with state names and regions essentially hoping I could troubleshoot on my own. This is the output table I get with an csv I upload: And here’s the script I’m using: // Prompt for a file upload let csvFileResult = await input.fileAsync( 'Upload a CSV file', {allowedFileTypes: ['.csv'], hasHeaderRow: true} ); //Display table w/ parsed contents let csvRows = csvFileResult.parsedContents; output.table(csvRows) I’ve been looking at the spreadsheet importer example and the documentation within the block but have had no luck thus far, any help would be much appreciated. Thank you

Has anyone found a javascript chart library that they like, that also works with React? I’m assuming that is one of the requirements as I seem to have struck out using d3.js inside my simple example. Really excited to create a richer charting block, if I can only find the right library. Thanks!

Hello all, We just launched a website to help small independant shops to sell gift cards during the covid19 crisis. Every week, we send them the list of their clients orders via Airtable. Today, I put all the orders in one table, then filter one by one the orders for each merchant and create manually a new table for each merchant where I paste the filtered orders. Can we create these new tables automatically ? A script or formula would have to filter each merchant and create tabs accordingly. Can we update these tables automatically ? A big thank you, we really need help, this project is volunteer and we already help 3000 small shops in France ! Jonathan

Hello, I know there is an API limit of 5req/s to query AirTable. What about Attachments’ URL ? Can I directly use a link to the attachment’s URL ? is there a secret/token in the URL that should not be displayed ? Is there a cache mechanism on AirTable side ? Or should I download and cache the attachment ?

I want to know if I can write some script to send data from the table to ManyChat chatbot using an API request.

In the “hello world” tutorial, the command block run runs indefinitely without reporting anything to standard output. I’ve collected some debugging information regarding the Express npm module via the DEBUG environment variable: DEBUG=* block run 2>&1 Wed, 25 Mar 2020 17:01:53 GMT express:application set "x-powered-by" to true Wed, 25 Mar 2020 17:01:53 GMT express:application set "etag" to 'weak' Wed, 25 Mar 2020 17:01:53 GMT express:application set "etag fn" to [Function: generateETag] Wed, 25 Mar 2020 17:01:53 GMT express:application set "env" to 'development' Wed, 25 Mar 2020 17:01:53 GMT express:application set "query parser" to 'extended' Wed, 25 Mar 2020 17:01:53 GMT express:application set "query parser fn" to [Function: parseExtendedQueryString] Wed, 25 Mar 2020 17:01:53 GMT express:application set "subdomain offset" to 2 Wed, 25 Mar 2020 17:01:53 GMT express:application set "t

This does not work. It throws some exceptions. useLoadable(cursor); useWatchable(cursor, ['activeTableId', 'selectedRecordIds']); const table = base.getTableById(cursor.activeTableId); const record = useRecordById(table, cursor.selectedRecordIds[0]); This works. But is this the correct way to do it? Feels like there should be a much simpler way to do this. useLoadable(cursor); useWatchable(cursor, ['activeTableId', 'selectedRecordIds']); const table = base.getTableById(cursor.activeTableId); const queryResult = table.selectRecords(); let record = null; try { record = queryResult.getRecordById(cursor.selectedRecordIds[0]); } catch (e) { record = null; }

Hello all - I have recently noticed that in both cases below you are able to create single- and multi-select options in Airtable from inside the app. As far as I was aware this was not possible through the API. Is there some secret endpoint or workaround that I am not aware of? Jotform - If you connect jotform direct to airtable you are able to use the “other” option in both single and multi select field types and it automagically creates the option in Airtable??? Integromat - With Integromat if you use the Airtable node, I accidentally discovered that you can create options in airtable automatically. Hope someone know more :slightly_smiling_face: Thanks in advance.

I’m struggling to find any docs of examples or returning a JSON packet of records from a module.export = function () {} block using the Airtable.js library; Can someone point me in the right direction?

Hi everyone, I am trying to create a roster of members using the Airtable API. Is there any way that I can somehow use the JSON returned from a GET request, order it, then output it to an HTML table? I’m a fairly new developer, so any help at all is appreciated.

Is there any way to solve the problem that occurs when the user clicks the submit button at the end of a form, but doesn’t go to the URL previously configured in airtable? (In fact when clicking on send, the user sees a message with the URL, but is not redirected. A horrible experience). I know that is a common problem among the community. But would it be possible to solve this using the ‘scripting’ block?

Similar to useState intial state. Otherwise, there will always be boilerplate code of if value is null then value is initial value: let [value, setValue, canSetValue] = useSynced('myGlobalConfigKey'); if (value == null) { value = 'initialValue'; } Cheers, Ronen Babayoff Superblocks.at

Hi, I’m trying to import a dataset of permits in the city of Austin, TX. My goal will be to update this daily, so I can filter by permits add on a given day. Every time I hit “Run” on my script, it only adds about 1,000-1,500 records to the table (different every time) and it seems to be skipping records, the length of the data set is roughly 20,000 records. Thanks in advance for any help! Here’s where I’m importing from: https://dev.socrata.com/foundry/data.austintexas.gov/mavg-96ck And here’s my script: // url to be queried let url = "https://data.austintexas.gov/resource/mavg-96ck.json?$limit=50000&$$app_token=[MY API TOKEN]"; // set the table that stores the records let table = base.getTable("Table 1"); // make the API call let response = await fetch(url, { method: "GET" }) // get the API response let data = await response.json(); output.text("Retrieved " + data.length + " Records"); data.forEach(a

Sorry for my bad English, I dont know exactly what is “The API is limited 5 requests per seconds” my question is that " If 10 users are requesting data at same time then will they recieve data or not… if yes then how many user can request data simultaneously without getting error… if no they what is the max no of user per second who can receive data which errors.

Hi! I wanted to show a lookup field as <RecordCardList />, but I can’t access the original field. I’m only getting the recordId and fieldId, not the tableId (in field.options). Can someone help me with that? Thanks!

Hi, I’m using sleiman/airtable-php to integrate airtable with my website, the problem that I’m having right now is inserting a public url where my image is hosted to the attachment field of the table; this is the code: $url = "<url-of-the-image>"; $attachment = array('url' => $url); $update_details = array( "ID Verification" => $attachment, ); $update = $airtable->updateContent("Applications/$record_id", $update_details); And I get this error: [error] => stdClass Object ( [type] => INVALID_ATTACHMENT_OBJECT [message] => Invalid attachment object for field ID Verification: "<url-of-the-image>" ) I have also tried to make the $attachment variable an object like this: $attachment = (object) [ 'url' => $url ]; Or do I have to define $attachment differently or ‘sleiman/airtable-php’ doesn’t support attachm

Hi everyone, Last week we sent out the first issue of our developer newsletter! If you missed it, you can read it here: Airtable developer newsletter - April 2020 We’ll be send one out about once a month to share API and platform updates, tutorials, resources, community spotlights, and more. To get the next one in your inbox, subscribe here. Let us know what you’d like to see in future issues :slightly_smiling_face: