Skip to main content

Development & APIs

Need development and API help? Ask your questions here!

  • 3,698 Topics
  • 11,871 Replies
3698 Topics
H
hansenpansenNew Participant
posted in Development & APIs
created records via Parser by zapier

Im using Parser by Zapier to receive mails and create a record with certain infos mapped to my columns. One of which is the Mail Attachment to be placed in a File Column in Airtable. Somehow the file gets renamed on the process. In my example I send "invoice-60.pdf" to the zapier parser. It got added to the record as "9UngNgXzKLZ3jsMlQmQBOa95o1I5ENxS9LaFRxLNIfNkfLjB0I3ul64-P893QYjt62uhsUPyHBMe_P2i65Zv7-O3qjclkk4ACMI72H8AytGuav9QrcSMjQ1w8Sc1t4_UWDuEuGw6wGENXNjHf3XzQlMf2LLiwwxSveX6kdXYwBk"Somehow the .pdf end got lost in the process. I need to use an Airtable automation to send an email containing that file to a specific address when the status is changed. Due to the lack of .pdf ending the receiving system doesn't recognize the file and rejects it. Bizarre enough, i can open it in Airtable and take a look at the filename, there is no .pdf at the end. When I download it though, the .

284
TheTimeSavingCo
M
MrPythonNew Participant
posted in Development & APIs
A third-party integration's access to your Airtable account has been revoked

Hi there,I have implemented OAuth for my application (using Python) and everything was working fine for several days. However, this morning I received this message in my email: The "OAuth XXX" third-party integration's access to your Airtable account has been automatically revoked by Airtable due to security concerns around refresh token usage. This sometimes occurs due to misconfigurations of the third-party integration. To continue using "OAuth testing" you may re-authorize it. And these are responses I captures when tried to refresh a token (not sure if it's important, but just in case).The first message I received on my server (when it failed) when I was trying to refresh a token: {"error":"<!DOCTYPE html>\n\t<html>\n\t <head>\n\t\t<meta name=\\"viewport\\" content=\\"width=device-width, initial-scale=1\\">\n\t\t<meta charset=\\"utf-8\\">\n\t\t<title>A

561
S
L
L11New Participant
posted in Development & APIs
N
NewAirtablerNew Participant
posted in Development & APIs
A
Alan_DominguesNew Participant
posted in Development & APIs
F
Francoloco23Known Participant
posted in Development & APIs
D
Derek_GavorcikNew Participant
posted in Development & APIs
C
cloderNew Participant
posted in Development & APIs
R
Robert_AndrewsKnown Participant
posted in Development & APIs
B
bottlerektedNew Participant
posted in Development & APIs
E
enricomilliNew Participant
asked in Development & APIs
J
jdavisParticipating Frequently
asked in Development & APIs
W
weiParfaitNew Participant
posted in Development & APIs
SCS
SCSNew Participant
posted in Development & APIs
AirTable Webhook Payload Retrieval

I am currently working with the Webhooks notifications (https://airtable.com/developers/web/api/webhooks-overview) to process record updates when a set of files/fields have changed. While I love the power and flexibility of the notification, especially the `fromSources` filtering and metadata, I have hit a few roadbumps in my implementations and I'm wondering if I am missing any obvious solutions that others have discovered.- Cursor value. Initially I thought I could possibly track the cursor value, but then I realized that this is likely just the cursor from the start of the payload list, so after 7 days of payloads, the max cursor value from the payloads will be less than my locally saved cursor, so this doesn't seem viable.- `baseTransactionNumber`. Since AirT

782
Théau12
N
NEF1QLSZ4UInspiring
asked in Development & APIs
S
SThiaraNew Participant
posted in Development & APIs
theomayeriii
theomayeriiiNew Participant
posted in Development & APIs
Looking for developer support

I have been running Airtable for at least 5 years and am very familiar with it. I have a need that is beyond my no-code low-code capabilities and I am looking to hire someone to help me develop the following idea.I have a base that has dynamic information for each day of the year on it.I have a physical public display in a high traffic location with a QR code on it.I would like local public to be able to hit that QR code with their phones and land on a mobile device compatible web page, which dynamically changes every day pulling the proper day's data into it from my airtable base.I don't have time (or really CSS, API and coding skills) to figure this out and would be very interested in developing a resource relationship with someone who can deal with the API, CSS, Java? issues in getting this web widget that is pulling data from an AirTable base made.My name is Theo MayerLooking forward to meeting you (whoever you are:)

333
C
keola
keolaInspiring
asked in Development & APIs
M
Mduduzi_NdhlovuNew Participant
posted in Development & APIs
Airtable in serveless function throws "Expected signal to be an instanceof AbortSignal"

Hi all, Im trying to use airtable in netlify serverles functions. When I try to create a record, I keep getting this error “Expected signal to be an instanceof AbortSignal”. ` const { formattedReturn } = require("./helpers") const Airtable = require(“airtable”) const base = new Airtable({ apiKey: “APIKey” }).base(“BaseID”) const eventBookingTable = base(“Events”) exports.handler = async function (event, context, callback) { const newRecord = async () => { const rec = await eventBookingTable .create({ Name: “iamnotcrazy”, Event: [“recwrjfffffff”], Email: “mymomgotmetested@gmail.com”, }) .catch(err => err) return rec } try { const record = await newRecord() return formattedReturn(200, { record }) } catch (err) { return formattedReturn(500, { err: err.message }) } }

141
M
T
Thomas_SolerNew Participant
posted in Development & APIs
R
rnavailleNew Participant
posted in Development & APIs
Zapier trigger on updated computed fied

Hi all, I use an airtable formula to calculate product prices. I want to use Zapier to automate the process of updating prices on my website when changes are made to prices.As I understand, Zapier wants to use the a "Last Modified Time" field as the reference to know when to trigger the action. The problem I'm having is that I'm not finding a way to point the "Last Modified Time" field at the calculated price field because AFAIK that field cannot monitor computed fields. The airtable documentation recommends pointing the "Last Modified Time" field at one of the editable fields used in the computed fields. This doesn't resolve my issue because Zapier seems to want to pull the value from the field being watched by the "Last Modified Time" field, not the computed field that I need it to. After consulting the airtable documentation I'm starting to be convinced that the workflow I have in mind is not possible (I would be

211
ScottWorld
F
Francoloco23Known Participant
posted in Development & APIs
G
gislipalsNew Participant
posted in Development & APIs
ed_p_may
ed_p_mayNew Participant
posted in Development & APIs
J
Jack_ColeyNew Participant
posted in Development & APIs
Create multiple records from JSON Data

I've been trying to do this in way too many ways. I haven't figured it out ChatGPT and Bard haven't figured it out so I though I would ask actual people 😁I'm making an api call to usaspending.gov and am able to to get the information I want returned, but I can't figure out how to use the data I'm pulling down to create multiple records based on the objects returned. Has anyone run into this and how did you do it?let uei = 'PLACE-UEI';let startDate = '2023-10-01';let endDate = '2023-12-31';let data = {"filters": {"time_period": [{"start_date": startDate,"end_date": endDate}],"award_type_codes": ["A","B","C","D"],"recipient_search_text": [uei]},"fields": ["Award ID","Recipient Name","Start Date","End Date","Award Amount","Total Outlays","Description","def_codes",

1852
J

Badge winners

Show all badges
Terms & ConditionsAccessibility statement