Skip to main content

Development & APIs

Need development and API help? Ask your questions here!

  • 3,665 Topics
  • 11,735 Replies
3665 Topics
S
Sixing_XuNew Participant
posted in Development & APIs
Best way to protect API key while using JS?

Hi all, I’ve been developing a website using Airtable’s official API client in javascript, and have been wondering if there’s a recommended way to securely protect my API and base keys (so that ppl won’t be able to access them via browser)? I’d like to know if there is a way to protect my keys without switching to another programming language.

152
D
K
kera_mchughParticipating Frequently
posted in Development & APIs
Fillable pdf to airtable?

Does anyone know if its possible to make a submit button on an interactive, fillable pdf, post to airtable??

31
J
E
Eric_NoletteNew Participant
posted in Development & APIs
Link id to Value (API output)

Hello – Is there a way to output the values on a linked fields as opposed to the ref id? For ex: the .get_all() python wrapper function returns the ids only. Can it return the values from the linked table? Is there an easy way to do this? Thank you

31
A
B
Bruce_DixonNew Participant
posted in Development & APIs
API Link to Zapier does NOT give me access to my bases

Ok, so maybe I have missed something, but I am trying to generate a new AirTable record to new Ticket Tailor orders. I link Zapier to my AirTable via the API, but when I look to access my base in AT to build an Action in Zapier, the only bases that show are preset/Demo ones that I did not create. I have tried searching for my bases, but no luck. So I can’t get past this step because I can’t access the base I have in AT?? Any help really appreciated.

92
B
T
TuurInspiring
posted in Development & APIs
Revision history not showing all updates (API related?)

Hi guys, I noticed that single update statements (PATCH) for multiple fields do not (always?) show up in the revision history. In this case the date field was updated at the same time as a checkbox, but only the date transition shows up in the history…

174
T
A
Antoine_FrankarNew Participant
posted in Development & APIs
[SOLVED] Problem when creating a record with an attachment

Hello, I’m trying to create a new record with the API. One field type is an attachment (an image or pdf). My call is working, I have a 200 response code, I can see the new record in the Airtable interface, I also have in the response the attachment field information: ["Proof"]=> array(1) { [0]=> object(stdClass)#28 (3) { ["id"]=> string(17) "attOL0Pzidc5P8bOk" ["url"]=> string(85) "https://www.mydomain.com/file/26348dd2d0adb1f592fdf34774a51214.jpg" ["filename"]=> string(36) "myfile.jpg" } } but in the Airtable interface this field is empty, and if I get this new record, I don’t have this field. The file is first uploaded on my server, I can access the file in my browser using the URL. In the documentation, it’s indicated that Airtable will download the file at the given URL and keep its own copy of it. I presume it’s not working? Do you have an idea where the problem is? Thank you

172
A
D
Donald_IrwinNew Participant
posted in Development & APIs
Returned data from GET API request for attachment field containing an MP3 audio file

I am working on an Alexa skill that executes a GET from an Airtable base where the record contains a field whose field type is Attachment. The GET in the Alexa skill assigns whatever is passed from Airtable to a variable. I don’t have a means of displaying the Alexa variable to see the contents. From the API documentation, I understand an attachment field will pass a field ID, the URL of the object and the file name of the object. Could someone provide an example of what is passed from the API using the following example: AudioField=api_response.records.0.fields.AirtableAudioFile; After execution, what is the contents of AudioField? Audiofield = ‘xxxxyyyyzzzz’ Thanks in advance for your reply!

10
D
K
Karl_HughesParticipating Frequently
posted in Development & APIs
Possible bug: I can use the API to delete records that don't exist in the current table

If I create an Airtable with two tables in it, call them posts and comments, I can use either table name to delete records on the other table. In other words, if I have a comment with the ID recIA3d3kRJwccR4M, I can call: DELETE https://api.airtable.com/v0/BASE_ID/comments/recIA3d3kRJwccR4M or: DELETE https://api.airtable.com/v0/BASE_ID/posts/recIA3d3kRJwccR4M This seems like a pretty important bug as it could lead to accidentally deleting records from the wrong table. Is this a known issue or something that you’re looking to fix?

97
E
D
Dom11New Participant
posted in Development & APIs
Display image url - help with JS syntax

Hi there! Here’s a newbie issue: I’m struggling to get an image url - I’m sure it’s very simple but I’m not very familiar with the syntax. I’ve tried a few different things but I can’t seem to get the ‘url’ parameter from my image field. records.forEach(function(record) { var $mealInfo = $('<div>'); $mealInfo.append($('<div>').text(record.get('Photo'))); $mealInfo.append($('<h3>').text(record.get('Name'))); $('#meal').append($mealInfo); }); Thanks!!

51
D
T
Tom_KeysersInspiring
posted in Development & APIs
Attachments get reversed order when uploaded through API

Hi, I’m using airtable.js to migrate a lot of data from Filemaker to Airtable at the moment. Each record contains a Picture (attachment) field with images. In airtable.js I’m creating an array which contains all correct image urls and filenames per record, which is then being pushed/updated to the relevant record in Airtable. E.g.: "Picture": [ { "filename": "1.jpg", "url": "https://www.cloud.com/_2801C_1.jpg" }, { "filename": "2.jpg", "url": "https://www.cloud.com/_2801C_2.jpg" }, { "filename": "3.jpg", "url": "https://www.cloud.com/_2801C_3.jpg" }, { "filename": "4.jpg", "url": "https://www.cloud.com/_2801C_4.jpg" }, { "filename": "5.jpg", "url": "https://www.cloud.com/_2801C_5.jpg" }, ] Logically, I want the position of my images to stay as stated in the array that I’m pushing, but the result I’m getting in the final Airtable is that picture 5.jpg is first and 1.jpg is last … This seems like a bug to me … Or am I doing something wrong? Is there a way to maintain the positioning of t

143
D
G
Glenn_CooperNew Participant
posted in Development & APIs
Create Record with Foreign Key - API c#

Hi chaps, I’m using the API to add a new record to a table and getting stuck with a Foreign Key (Integer). I am using C# and the AirtableAPIClient Nuget Package. This is where the code is tripping up: fields.AddField("Username", username); fields.AddField("Password", password); fields.AddField("Ref", Refs ); AirTable is returning a 422 error on the Refs field. The foreign key is a single link, not multiple. The column itself is a LongInt. I’ve tried adding an array, a single value, but not having any luck with this. Can someone please advise? Thanks

161
G
J
jennie_stenhousNew Participant
posted in Development & APIs
Finding the number of records in a table / getting a random record

Hi, I want to be able to pull a record at random from my table via the js api. To do so I need to know the max number of records that exist in the table. I have used Auto numbering to create the id ( key field ) of the table. I can then simply generate a rand number and pull the record that has that rand number as it’s id. How ever I am stuck at present trying to figure out where I can get the number of records from, is there away to query the size of the table? or retrive the last record ( because of the auto numbering it’s ID would be the max record number ) thank you for your help and time.

71
O
K
Kyle_MattaNew Participant
posted in Development & APIs
Example Zapier Post to API

Can someone provide me with an example to insert a record into a table with the Airtable api from zapier code? I have seen codes that show using GET command with and can get that to work in postman no problem. I have yet been able to do a post command with postman successfully. I will get a 200 response but the record never actually inserts into the table. Does anyone have any insight where I can find more information on this? Thanks in advance.

01
A
L
Lawrence_HumbleNew Participant
posted in Development & APIs
How to store retrieved record as variable in node.js

Apologies in advance, this is probably a dumb question but I’m relatively new to airtable and I’m trying to retrieve individual records using the API through node.js and I can’t figure out how to store the JSON output as a variable I can parse through. From my API documentation, I am being told I can retrieve an individual record using: base('base-name').find('record-name', function(err, record) { if (err) { console.error(err); return; } console.log(record); }); This works perfectly well to print the record to the console. But how do I assign the output to a variable which I can parse through? I’m sorry if this is a dumb question. Really appreciate any help!

11
A
C
Chris_ParkerInspiring
posted in Development & APIs
Is there an Airtable.js reference?

The Github site for Airtable.js lacks too much information for beginners. The README explains almost nothing. However, I did look at the test.html file and was able to make a very basic test of my own. But, other than looking at test.html, how do you discover what Airtable.js can do?

82
A
G
Gavin_ThomasNew Participant
posted in Development & APIs
Return multiple records for linked table

Hi, I’ve got 3 tables i’d like to be able to return records from a linked table based on id’s. i’ve been trialling the filterby formula function to retreive a record by ID but how do you do this by multiple id.s eg. 1 record from a table looks like this “id”: “recOW2bVrD0EuXF7M”, “fields”: { “country”: “Australia”, “continent”: “Australia and New Zealand”, “partner_universities”: [ “recS7EnXzspRowVfb”, “recVpXFu93umekVij”, “reckcPSPWYAAzl7Ld”, “recUe3go5fHBqR1a8”, “recwzDNlgGOcuRrRY” ], “subject_university”: [ “rec4uL4PmXuO4UzMO”, “recNGBHjUh4yVzXp3”, “recc3ovVUYJ6b4qDD”, “recKv6l77p95Gn3im”, “rec5i1AgZwl5pdV4Y”, “recEpoJL6G0hxWxeZ”, “rec8KZDmdT8aotNdB”, “recmxAJYdxIhpmBFR”, “recx12pYZAcJLRCjv”, “recX6TGusfr1EoJVC”, “recnYZoCmrnWeLuG1”, “rectMdcCx3wWvXaS2”, “rec2XlS0dGmcdZxvx”, “rece2IYb8aCbMiqQl”, “recWeabmWidCnrvff”, “recmHycR4LgyKrxl6”, “rectGeLjBG9lIfJhG”, “recsxDGN1LUn4Yt5K”, “recvW3zithBqZqvRI”, “recQVWTz8IdwIeCgf”, “recMzzvoma0Mg2nKv”, “recoEiEKLDXGZbKfm”, “recp37vk0eogqnNDS”, “

289
G
M
Mike11New Participant
posted in Development & APIs
How to grab other fields using record.get() in javascript

I have a base that I can retrieve records from using the API from Javascript code, but I’d like to get the value for other fields besides just “Location”. Using “console.log('Retrieved: ', record.get(‘Location’));”, how do I modify this line to include in the output the field values for a field called “Size” in addition to the “Location” field? I tried separating multiple fields with a comma, but that didn’t work.

211
O
R
rooseveltNew Participant
posted in Development & APIs
Invalid Value for Column Error for a Duration Field

Hi, I am having some trouble with a Patch request to update a Duration field. The error I’m getting is this: {error: {type: "INVALID_VALUE_FOR_COLUMN", message: "Field Time Spent can not accept value 5306"}} But what’s interesting is, if I change the field type to “Single line text,” it works fine and updates the field as expected. Here’s how my header looks in both cases: Am I formatting the value wrong for the ‘Duration’ field type? I tried converting 5306 seconds to “01:28:20” string but I got the same error. Any thoughts? Thanks, Roosevelt

81
A
L
Lydon_BerginNew Participant
posted in Development & APIs
List Tables given API Key and BaseID?

Is there an API call/endpoint that will list all of the tables if given a BaseID, or do we need to wait until the Metadata API is public?

249
L
J
Jason_LallyNew Participant
posted in Development & APIs
Anyone have example code or ideas around managing bulk updates?

Hello, I’m trying to sanely bulk update a set of records from a source to Airtable. Mechanically, I have it working, but I’m thinking that I need to employ some better practices for managing these updates. Here’s the current state: Data Have a JSON payload of multiple rows, preprocessed to match the Airtable schema Do not have the Airtable record ID in that dataset, we have our own identifier Process/Script Loop over each record in the JSON payload, add a timestamp (for sanity checks) Run a select query on the API filtering by our ID If nothing found, issue a create request with the payload If found, issue an update request, passing the record ID from Airtable returned in 2 The problem As written a number of async requests get issued and we run into conflicts. Then data doesn’t get written. I want to make sure the sync is bullet proof so we don’t run into data loss issues or have to do a lot of additional QA. I mitigated by setting a timeout for the first request. I’m thinking of t

82
J
J
John_HimicsNew Participant
posted in Development & APIs
filterByFormula that is linked from other Table

I have records that look something like this in Employee table. “records”: [ { “id”: “recxPbyRYLea1Y3u7”, “fields”: { “Name”: “Jane Doe”, “ID”: 1, “Roles”: [ “rec93YegEkI0lLKi0”, “recgUgOR7mEk9SYDm” ], … } } ] As you can see Roles link to other Table, so what I wanted to achieve is that filter Employee data including data that is linked from another table in this case Role. e.g. I wanted to show all Employee with Roles Id of ‘rec93YegEkI0lLKi0’ using ‘filterByFormula’. I’m using CURL PHP Thanks

91
E
M
mrpnNew Participant
posted in Development & APIs
Invalid_value_for_column

Hello, working on small PHP site with https://github.com/DavidZadrazil/airtable-api-php/ When I’m trying to update Checkbox or Number field via $response = $request->updateRecord('recsH5WYbYpwWMlvb', ['Cancel' => '123']); $response->isSuccess(); // true / false I get this error; Fatal error: Uncaught GuzzleHttp\Exception\ClientException: Client error:PATCH https://api.airtable.com/v0/appXXXX/Invoices/recSMXnTwTiRrRvGBresulted in a422 Unprocessable Entityresponse: {"error":{"type":"INVALID_VALUE_FOR_COLUMN","message":"Field Cancel can not accept value 123"}} I can successfully update Name fields. Any ideas why i get 422 error? Thanks

181
R
O
Oren_LevineNew Participant
posted in Development & APIs
Automatically fetch all pages?

Apologies if this is an ignorant question, but I want my call to the API to fetch all pages automatically, without extra user action. I started with the sample code base('allocations').select({ // Selecting the first 3 records in Main View: maxRecords: 3, view: "Main View" }).eachPage(function page(records, fetchNextPage) { // This function (`page`) will get called for each page of records. records.forEach(function(record) { console.log('Retrieved ', record.get('ID')); }); // To fetch the next page of records, call `fetchNextPage`. // If there are more records, `page` will get called again. // If there are no more records, `done` will get called. fetchNextPage(); }, function done(error) { if (error) { console.log(error); } }); The code appears to call fetchNextPage() after each page of results, which i expect will then call page() again. This does not happen; the next page is not fetched. What am I missing? Thanks,

114
A
I
Ignacio_CeballoNew Participant
posted in Development & APIs
Origami Studio - Could not find field \\"fields\\" in the request body

Hello guys! Im trying to create a record through the Airtable’s API but I can’t get it. I am using Origami Studio and this is the message that airtable say: { “error” : { “message” : “Could not find field “fields” in the request body”, “type” : “INVALID_REQUEST_MISSING_FIELDS” } } And this is my json { “fields” : { “Name” : “Send” } } So… why it is happening? Thanks a lot!

51
A
T
Tangent_LinNew Participant
posted in Development & APIs
Equivalent of 'WHERE field in (value1, value2, value3)' with Airtable API

Hi I have come across the need of filtering records based on a field’s value in a defined list of values, this is equivalent to SQL WHERE clause like WHERE field IN (value1, value2, value3), so I wonder how I achieve this with Airtable API.

71
O

Badge winners

Show all badges
Terms & Conditions