Development & APIs

Is there a way to use filterbyformula to filter with two options from the same column?I have successfully retrieved all my records and now I want to be able to filter by 2 values from the same column.This is what I have so far filterByFormula: AND( {ID} = {Extension}, {Type} = 'Type A'). I want to also include Type C in this filter so it shows both Type A and Type C. I cannot find the documentation to do this. Please advise. Thank you.

Hi Team,I created a personal access token as suggested in Airtable documentation.(https://support.airtable.com/docs/visualizing-airtable-records-in-microsoft-power-bi-power-query) While I'm connecting to PowerBI using the PAT, TableID, BaseID and M Query, it displays below error:Expression error: we cannot convert the value null type to type Record. Details: Value=Type=[Type]However if I use the API keys, it works fine. Since API keys will deprecate in mere future, created a PAT. Can you please assist? Thank you!

A common theme we are seeing with project management bases is the desire to have project and task templates. When you create a new project, it can then generate the corresponding set of tasks, and maintain the basic details about those tasks, including the relationships and dependencies amongst those tasks. This is similar to Creating Tasks from a Template with a few differences. When creating projects, we often find we create a new record in our projects table, and then want to link it to a set of metadata (a project template). From there, each project template should know its associated set of tasks. This allows us to add more project templates over time, and change the set of tasks required to complete each of those projects. Additionally, the script will ensure that the dependencies between the task templates are maintained when creating the tasks for a new project. You can see examples of the base: Universe Base Share Link Full code below // when a new asset is created, // t

I am trying to make a very simply patch request using an HTTP module in Make.com. However, I'm getting this and can't work out why: URLhttps://api.airtable.com/v0/appzYqJSdNkXvYunc/2023/recV9bgS8TBB1msd7Request content{ "fields": { "PDF Requested": true }, "typecast": true } ​Request compressed contentfalseMethodpatchHeadersArray1CollectionNameAuthorizationValueBearer keyoffNKf3BVBTr7w2CollectionNameContent-TypeValueapplication/jsonTimeoutemptyUse Mutual TLSfalsePasswordemptyUser nameemptyBody typerawContent typeapplication/jsonSerialize URLfalseShare cookies with other HTTP modulesfalseParse responsefalseFollow redirecttrueDisable serialization of multiple same query string keys as arraysfalseFollow all redirectfalseReject connections that are using unverified (self-signed) certificatestrueOUTPUT Bundle 1CollectionStatus code422HeadersArrayCookie headersArray1AWSALB=HA7u9TAS1egeTJzD1uCdgufpkjhpW35UNtWpX1KTXq9u9oPC38wYlXSfBC3Mg01aHUYv4vtXUve1qdnCPo31ECjur8aMfS0suXN21pwZR97jcg

I'm having an issue with Maps Block authenticating my Google Maps API key.  It works fine if I make the key unrestricted, but adding the restriction to Airtable breaks/blocks the map block from reaching the API.  Per the Airtable dialog box I'm supposed to add this address to the permitted HTTP referrers: *.airtableblocks.com/*Is this still the correct address? In the Google Cloud Console do I do more than check "websites" and literally paste that in as the permitted website address?  I tried adding https://*.airtableblocks.com/* and that didn't work either.  I've attached a screenshot from Cloud Console.

Hi All, I’m wondering what is the best way to calculate some basic counts on a table via the API. We need to calculate simple counts such as total records with a Status of “Fulfilled” and total records where Status is “Fulfilled” with where the Fulfilled Date is today (see excerpt below). I’ve written a Node Twilio function to retrieve the records and then loop through them and calculate which ones meet the criteria. We then use Zapier to retrieve this output from Twilio and put it into our Slack channel daily. However, as the table grows over 30,000 records, I’m running over the 10 second execution limit in Twilio. Is there a better way, or should I look for a different place to host my function not subject to the 10 second limit? let metrics = { matchedToday: 0, fulfilledToday: 0, fulfilledTotal: 0, }; base("Master Intake") .select({ fields: ["Status", "# to feed", "Created Date", "Fulfilled Date"], cellFormat: "string", timeZone: "America/Los_Angeles", filte

Hello there,I'm not being able to create nor duplicate a record and I've try restarting, deleting cache, logout and login... simply I cannot do it.Thank you,Edson.

Airtable sometimes mentions 5 requests per second per base rate limit and sometimes just 5 requests per second; see the links below.5 requests per second per base: https://airtable.com/developers/web/api/rate-limits5 requests per second: https://support.airtable.com/docs/de/managing-api-call-limits-in-airtable#understanding-rate-limitsCan someone from Airtable shed some light on what's going on and what's the reliable source?

Hi again,everyday I love more and more Airtable! I had to admit that... 🙂But... I stuck on KEY function of builded app... KEY FUNCTION 🙂I have a list with products, min/max are numbers, and defining working range for product:name | min | maxabcd | 100 | 200efghi | 145 | 455......I have to add a search field in interface where user can type a number, and table will be filtered to products in range. For example typing 70 - gives no results; typing 120 - gives abcd; typing 190 - gives abcd and efghi.HOW TO DO THIS?If not in Airtable - can you recommend any no code tool for building this (with Airtable as backend).RegardsTomek

Is there a way to set up Pitchbook and / or Asbhy integrations or APIs with Airtable? If so, any recommendations on what's the best way?

I'm using the Airtable API to create a new base and a new table (called 'Raw Data') within it. All of my singleLineText fields are working fine, but when I add a final field named 'Last Modified' with a type of lastModifiedTime, I get this error back from the api call:error: {   type: 'UNSUPPORTED_FIELD_TYPE_FOR_CREATE',   message: 'Invalid options for Raw Data.Last Modified: Creating lastModifiedTime fields is not supported at this time'}I haven't been able to find anything in the API docs or by googling about this. I would appreciate any help.     Thanks,     Rob

I want to make it simple for users on my CFL prediction website to search through my Airtable content. I'm considering using the Search app. Is this the right choice, and do you have any tips for setting it up effectively?any Idea?Any help is appreciated!

Hello,I have a question regarding the Airtable API key deprecation, and was hoping someone could clarify/confirm. Basically I am wondering whether this change will affect us, and whether we need to make adjustments. I've searched the forum, but I did not find an answer. Maybe this is a newbie/misplaced question. If so, I'm sorry.I have a base today where we use the Google Distance Matrix API to retrieve info from the Google API. We have no external services connected to the Airtable base. If we go into the "Developer Hub" and look at "API Key" the list is blank. That is true for "Personal access tokens" and "OAuth integrations" as well.The Distance Matrix API uses an API Key, which we have created through google. We use this key when Airtable connects to the Distance Matrix API to get info. This is done in scripts and automations, and we use the function"await remoteFetchAsync(txturlrequest)" to interact with the API through the scritps. In the automation we use "await fetch(txturlrequ

Hi everybodyWe just upgraded to the Airtable Business account and recently updated our Airtable connection in Zapier from one user's personal access token to another user. Now all the Zaps using Airtable have stopped working - and have an error message that the Airtable connection is expired.I've tried reconnecting the airtable account several times, and each connection says expired.When you sign into Airtable through Zapier, there are a few new options... I've selected the organization option as this makes the most sense for us. No luck - it always shows as an expired connection. Any advice??

Hi everyone, Excited to be using the Airtable API!I'm trying to add new fields to a given table in a given base via this endpoint, but keep getting a 404 {'error': 'NOT_FOUND'}Here's my code:payload = json.dumps(payload)response = requests.get("https://api.airtable.com/v0/meta/bases/{base_id}/tables/{table_id}/fields".format(base_id=base_id,table_id=table_id),headers={"Authorization":"Bearer {token}".format(token=API_TOKEN),"Content-Type": "application/json",},data=payload) Could anyone advise?

I want to use timelines to keep track of, and plan things that happen to our garden beds at work - weather that is ammendments, planting, seeding, etc. Currently, each event - e.g. seeding of carrots, or application of lime is it's own record. When multiple things happen at once, against each bed, the timeline view is unwieldy to navigate. EG here I can only see 2 out of 60 beds at onceAll related events are grouped by a unique code. I can use another table, that connects all records with the same code into a single record, and timeline view that. Like this:But functionally this is inelegant, and for useful experience, I need to be able to edit the individual elements in the same base. For planning purposes, I really need to be able to drag the groups into different beds on the timeline.It seems like a simple functionality, but is there a simple way to achieve a reduced view, so I can view more of the farm beds at once?

Recently our Softr.ai app has not been able to consistently load information from our airtable databases. This never used to be the case and nothing has changed in the configuration. I am wondering if this is linked to the API changes - I read somewhere that if an airtable client now goes over their API limit (which we do if we are treated as a Team client and not a Pro client) then the 5 API calls per second is impacted. Is this what might be happening? (See screenshot - "request limit exceeded") I understood from what  you said that we would be getting unlimited APIs on our current plan (Pro) until it runs out in April 2024 (because we have paid for an annual subscription), but I am wondering whether this is not the case and our ability is to make API calls is already being impacted. It would be really useful to know the answer to this as   is currently not useable as it is not loading consistently. Could you ask one of your team to let me know

I have an issue where a sync that used to work has stopped as of 13 hours ago.The sync is from one base to another.This is the error message on the table that is being synced from the original."Unable to sync this source. Internal sync error"There have been no structural change or field name changes on this base during this period.Filed a support ticket (00634496) but this is business critical and a day to get a response doesn't answer that.

I am trying to create new records via airtable.js, when I try to create a new record in Link-to column with row-value (i.e. name - string not Record ID), it does not work and reply Class {error: “INVALID_RECORD_ID”, message: “Value “VALUE” is not a valid record ID.”, statusCode: 422} Is there any way to avoid this condition? or there is not “typecast” command in airtable.js ? if yes, please let me know some example, var dataCompt = { "field1": "value1(text)", "field2(Link-to column)": "value2(text)" }; function createATData(){ base(tableName).create(dataCompt, function(err, record) { if (err) { console.log(err); return; } //loadArtists(); }); }

Hi guys,I have been trying to create a simple Make.com scenario to test the waters, where an Airtable record is created from a pre-specified Etsy receipt. The first step works great, all records are pulled from Etsy's API, but when we get to Airtable, I'm getting a repeated [404] Not Found error.According to Airtable developer @EvanHahn's answer here, Airtable only returns 404s in two cases. I quote:the resource you’re fetching is missing. For example, if we can’t find the table, or the base, or the record, or whatever.the URL you’re hitting is totally bogus. For example, a request to api.airtable.com/v0/garbage will return a 404.It seems that it's getting the base, the table, and the record just right, so I assume the URL it's hitting must be correct.The error persists regardless of smart link or column ID use.Make.com gets its access via a personal access token:The connection screen looks like this: You will see that Etsy has 4 acquired permissions whereas Ai

Good morning to you,I'm trying to create dynamic ToDoLists.At first, I thought I could solve my problem by using complete NoCode (see my post).Finally, after some advice, I turned to @Giovanni_Briggs code and post.I've never coded the day before yesterday, and I'm trying to use AI tools to understand what I'm doing.I've managed to adapt the proposed code to my base and half of what I want to do works.As it happens, my code copies the tasks from my original list very well,It links the new tasks to the event we've validated internally,But it doesn't create a link between parent and child tasks (I've been tearing my hair out for 24 hours trying to solve this problem).To explain, each parent task (main task) is linked to several subtasks (child tasks).example : The Hotel taskis therefore linked to several subtasks:Hotel searchValidation of a hotel according to quotation and price/quality ratioHotel reservationHotel paymentReceipt of invoiceWhen I use my script, everything works fine except

I'm writing a script in Airtable Extensions to pull data from Canvas API. I've set the per_page limit to 100, because that's the maximum number of objects Airtable will retrieve at once for an external API.I need to use pagination to download the rest of the results. According the Canvas API reference, it's in the response header Link value. I'm able to see this in Postman but how do I retrieve this in an Airtable script? How do I set up a loop to paginate until the end? All the online discussions are about Airtable's API and I can't find how to retrieve response headers.  let currentCourses = await remoteFetchAsync("https://XXXX?per_page=100", requestOptions); const currentCoursesData = await currentCourses.json(); console.log(currentCoursesData);    

It'd be nice if we could put a photo in base's appearance, although airtable offers several options, we could have more personalized bases, making it easier to identify each one  

Hey folks, just wanted to share that we created this pipeline which is free to use.It has schema inference and evolution, so the column names and data types will automatically be normalised to fit the destination and also adapt to any additions etc.you can configure it to load fully or incrementally.If you have feedback, please join our slack and discuss there or open a git issue. Pipeline docs: https://dlthub.com/docs/dlt-ecosystem/verified-sources/airtableour slack: https://join.slack.com/t/dlthub-community/shared_invite/zt-1slox199h-HAE7EQoXmstkP_bTqal65g

I am stuck 😫I am attempting to configure a webhook, but I continue to encounter a 401 error that seems to be related to the API token. I have thoroughly reviewed all the settings and ensured that I am inputting them accurately. Additionally, I am utilizing an Airtable pro plan, and there are no other users associated with my account, so I have all the permissions. Also if I put "Bearer" in front of the token it turns into a 403 errorAny guidance would be amazing!