Development & APIs

I am specifying a table to retrieve a specific record but I am using a record ID from a different table (deliberately) and the response is retrieval of that record from the other table when I expect it to return a not found message. Is this by design? It is a problem for my use case. Any way to avoid this? recACjz97bYmXXXX is an existing record in sessions table. The following curl targeting the profiles table returns the record from the sessions table instead of an error. curl https://api.airtable.com/v0/applnNWHXXXXXX/profiles/recACjz97bYmXXXX same result using below curl: curl https://api.airtable.com/v0/applnNWHXXXXXX/sessions/recACjz97bYmXXXX

Hi, how can i get some record id from a specific table with a specific field (id, email…)? I use CURL with PHP. Some like: https://api.airtable.com/v0/.../.../specific_field=value \ Thanks!

I’m using the python wrapper (here). I have a small script that tries to update a field in the ‘Orders’ table. The record is successfully retrieved earlier from the API so I have the ID of the record stored in ‘orderid’. I’m now trying to update 1 field called ‘Folder’ to ‘True’. record = airtable.search('id', orderid) fields = {'Folder': 'True'} airtable.update(record[id], fields) But i receive this error which i’m stuck at: requests.exceptions.HTTPError: 422 Client Error: Unprocessable Entity for url: https://api.airtable.com/v0/appoR6kS5KY3cJdwK/Orders?filterByFormula={id}='rec70yhW5MYcetmxJ' (Decoded URL) [Error: {'type': 'INVALID_FILTER_BY_FORMULA', 'message': 'The formula for filtering records is invalid: unknown field names: id'}]

Hello everybody, I created a multiple select field and integrated it with my website. It works fine if you check an option. I want users to also be able to not check anything from the field. However if nothing is checked from this multiple select field, then I cannot submit the form. I get invalid value for column. How can I succeed this? Thanks in advance!

Anyone able to do an experiment with me? I’m seeing different behavior in different bases for how mentions come through via the api. This is in reference to a Long Text field that uses the @ feature to notify someone within a note. I’m seeing both a markup based approach: [$!<id>|<User Name>!$] as well as a tag based approached: <airtable:mention id=\\"<id>\\">@<User Name></airtable:mention> anyone seeing both of these? or just the latter? My guess is at some point they changed this and now any new ones use the airtable:mention approach, but any old notes in their database created before a certain date have the old markdown format so when querying for those it still comes in with that format. If anyone else had issues with this I’d be curious to hear.

Hi I am attempting to use the Node.js Airtable API to post data from an HTML5 form to Airtable. Has anyone developed a way to do this securely (without exposing the API key)? Tips for getting this done? Goal is to find a workaround for the missing features and lack of customization for Airtable forms. Thanks!

Does AirTable support triggers such as OnEdit or OnUpdate?

In the Kanban view, when you click on the card you can select which fields can be either “viewed” or “hidden”. Is there a way to do this through the API rather than manually? In addition, is there a way to to arrange what is viewed/hidden per each specific card? Thank you.

Hello, I implemented an angular app, which accesses Airtable API and does CRUD operations on the base. Per logged in user it makes 10 API requests to read data and 10 to write data to base. So around 20 API requests per logged in user. we are planning to deploy it enterprise wide. where more than 200 people will be accessing this application at any given point in time and these requests will be executed simultaneously. Can I get any suggestions on, How the applications will behave ? Will there be any performance issues ? Will Airtable API be able to handle this load ? Any advice and suggestions will be greatly appreciated Thanks!

The two fields I need from my base are ‘date’ and ‘venue’ and in the base they are in order by date, that’s how I entered them. When I i retrieve that data via the API, they are out of order, and not in a way that makes sense. When I try to use the Airtable API Encoder to set the sort order, I get a 422 error. Any ideas how to fix this? Something simple that I’m missing? Thanks!

Hey all I’ve developed a Gantt view web app which is driven by an Airtable table in the back-end. Ideally I’d like to share the color scheme between the Gantt view and the Airtable interface. Is there a way to get the colors used from Airtable? e.g. for a Single select field Then I could make my Gantt table blocks colored to match my Airtable rows Thank you Elliot

Hi guys, I’d never seen this one before. I’m sending a deletion request looking like: https://api.airtable.com/v0/appXXXX/MyData/recYYYY Now if the record does not exist I always get a 404 with: {“error”:{“type”:“MODEL_ID_NOT_FOUND”,“message”:“Record not found”}} In one particular situation I get: {“error”:{“type”:“MODEL_ID_NOT_FOUND”,“message”:“Could not find application by id recYYYY”}} If somebody could explain why this happens or what this means that would be awesome!

I have CarTable with a linked field to EngineTypeTable and another linked field to ManufacturerTable. I have the record_id from a record in EngineTypeTable and a second record_id from a record in ManufacturerTable. I want to create an API call on CarTable that returns all the CarTable records with linked field columns that respectively match the record_ids that I have. How can I do this? Is it possible with filterByFormula?

Hello everybody, I am trying to use Airtable as backend for a submit form in my project. However, I cannot seem to integrate it and I don’t know the problem. I am using npm Airtable.js and axios. I am very new to both JS and Airtable. Below is my error code: Error in the browser after submiting the form: Airtable error: {“error”:{“type”:“INVALID_REQUEST_MISSING_FIELDS”,“message”:“Could not find field “fields” in the request body”}} Could somebody please what I am doing wrong? Thanks a lot in advance! Below is my code: var form = document.querySelector("#bize-ulasin"); if(form) { form.addEventListener("submit", function(event) { event.preventDefault(); axios.post(airtable_write_endpoint, { "Content-Type": "application/json" } , { "fields": { "AdSoyad": document.getElementById("#Ad-Soyad"), "Email": document.getElementById("#Email"), "Telefon": documen

Value for the field in the record = ‘Company Name, LLC’. The querystring contains: &filterByFormula={Customer}=‘Company Name, LLC’ That string is run through urlencode() and looks like this… &filterByFormula={Customer}=%27Company%20Name%2C%20LLC%27 No matter what I try, it is failing for every customer that contains a comma. Not sure if there is a way to escape the comma, or if this is an Airtable API bug.

Hello. I’m using java and the official com.sybit.airtable.* library. I noticed something curious: I use a certain file (e.g. test1.zip) as attchment via an url, and I set the FileName to “test1.zip” No problem here. The attachment is added to the field, with as name “test1.zip” However, if I use the same file test1.zip (via url) to another record (same field), and name it “test2.zip”, it is added/shown as filename “test1.zip” and not “test2.zip” !!! It looks like internally, there is some kind of CRC value of the file connected to the initial FileName, and as soon this file is used again, it uses the initial FileName value, no matter what u use afterwards. Can somebody explain this?

Hello! I’m relatively new to Airtable. I have a view that has columns that are lookups from other tables. When I pull the table data into a web app that I’m building, I get what looks to be random string references anywhere a lookup or linked value is. If anyone has thoughts on how I can grab the value of that field instead of the reference, I’d be super appreciative. Here is an example of my code: When I have the results returned to me, and I get a field value for a non linked or lookup column like this: response.data.records[i].fields.Date I get the date, as expected. But if I reference a linked or lookup column, like this (the Project column is linked to the projects table…): response.data.records[i].fields.Project I get something like this returned: recNmHYjQBITjdJdb rather than the string of the project’s name. Any help or advice is super appreciated!

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