Development & APIs

Hi there, I have a table that have records of users_email and i wanted to implement a get_by_email method from my server. I must have missed something because I can’t get the filterByFormula to work… I’m trying this in python: payload = {“filterByFormula”: “({EMAIL} = "test@test.fr”)"} r = requests.get(url, params=payload, headers=headers) In returns i have this error : {‘error’: {‘type’: ‘INVALID_FILTER_BY_FORMULA’, ‘message’: ‘The formula for filtering records is invalid: Invalid formula. Please check your formula text.’}} Can someone help on this please ? I’m a little lost Thanks in advance :slightly_smiling_face:

Using curl, if I try to GET /v0/workspace_id/base_name?fields=field1, it will fail with 422 “unprocessable entity”. However, GET /v0/workspace_id/base_name?fields=field1&fields=field2 works without any problems and returns the requested fields.

Hello AirTablers, I’m trying to use the API correctly but am only getting back a “NOT_FOUND” response. This is the API endpoint with what I think are my base and table values from a base in my account and I’m passing my API key in the Header. I can’t see what’s missing from the curl examples we see in the API docs: https://api.airtable.com/v0/tbl3xtICFVhYV7I8N/viwKJgxDKy6tU5Nyd Here’s a screenshot of me in postman trying to get a call through unsuccessfully: *UPDATE I’m able to get some responses back from the API Docs example call: https://api.airtable.com/v0/appNffFm7oK8ieYKn/Voyager.com \ But where did the appNffFm7oK8ieYKn come from? When I click around the base or look for a share link or look in Account settings I don’t see this string anywhere? *UPD

Hi there, I’m a bit of a frankencoder - I learn as I copy and tweak - so I’m just following the directions here. I’m attempting to show just the Name of a linked record, but it’s coming out to look like this: [ “recfJJrXBhwg8oyl9” ] And any Lookup field turns out like so: [“data here”] So I assume I need to first retrieve the ID of the linked record so it shows the field I want related to that record, but not sure how to go about coding it out. My sloppy guesswork is this in the HTML: Partner:{{ item['id']['Partner']['fields']['Name'] }} Here’s the full JSFiddle

Hello everyone. I’m trying to copy new rows inserted on someone else’s table (readable for the public) to my own Google Spreadsheet. I tried with Zapier, but because I don’t own one of the tables, I don’t think I can do it (correct me if I’m wrong :slightly_smiling_face: ). Next attempt is via API. Can you help me? Thank you.

I would like my PDF’s URLs to come in thru the API at a certain date and at a certain time and then expire but I either get zero records as my result or only the first one comes in but not at the time it should. I’m not sure if I need to use the Now formula with this: AND({Start Date}<=“2018-26-10T8:45:00.000Z”,{Expiration Date}>=“2018-26-10T8:50:00.000Z”) This is what I’m using right now when I request URL: https://api.airtable.com/v0/appwTRS4obTixysow/Ad?api_key=mykeynumber&filterByFormula=AND({Start Date}<=“2018-26-10T9:45:00.000Z”,{Expiration Date}>=“2018-26-10T9:50:00.000Z”) This is my airtable Also, this is what I chose for the date and time format

I’d like to query a table via the Javascript API with the following requirements: The query uses a “View” for sort order The query uses a custom filter that overrides any filters existing on that view. Is it possible to accomplish this? Right now, it seems that filters in Airtable always affect the API results.

Hi folks, Airtable and Power BI comparison. Could anyone tell (Explain) me the major prons & cons of Power BI and Airtable? Thanks

When working with linked records, is there any way use the record ID to search across all tables in a base or to “get” the table name of the linked record? As far as I know right now, there’s really no way to dynamically build the query that gets the linked record, i.e., you have to parse the field key to figure out what table is being linked to, etc. This seems really clunky.

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.

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

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

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.

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…

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

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!

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?

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!!

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

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

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.

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.

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!

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?

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”, “rect