Development & APIs

While you can participate as an individual, sometimes it is more rewarding to do things as a team. If you’d like to find a team member to participate in our $100,000 [Custom Blocks Contest] (Airtable Blocks SDK), chime in here! The contest platform makes it easy to submit entries as a team. To recap, the platform team is offering big prizes for the best blocks in three categories: Blocks for Business Teams (5 winners) Blocks for Education or Non-Profit (2 winners) Wildcard (2 winners) The contest runs until July 6, 2020, so head over to Devpost now to get all the details and register: https://airtable.devpost.com/

I am trying to retrieve all records from a table. The master view has filters on it that have to stay there for other business users, but I would like to retrieve all records without the filters with the API. More specifically, the table is filtered to records added in the last week, but I need all of the records from the beginning of the table. Is there a way to use the API to get all records even if the table in the browser has filters on it?

Hi @kuovonne, I found your script in the below thread incredibly helpful – Thank you so much this is a game changer for me! https://community.airtable.com/t/weekend-scripting-block-challenge-and-1-000-prize/28074/9?u=adrian_head I’m curious if you might be able to help me make an adjustment to the script for a specific use-case which I think it broadly applicable to people needing to use a script similar to the one your created above. I have translated my problem to match the verbiage in your Cake order example to make things more clear. You can find the link to my example base here for your reference. Context: Right now the number of New Linked Records I am creating in my Cakes for Creation table is dependent on a Count Field which is adding up the number of Items linked in the “Cake Types” Field (See examples below): Count Field Creation: Example as Field: In your example, rows created by the script in the “Cakes” Table are created based off the number of cakes in the “Orders” Tab

I’d to send selected records in Airtable to Zapier in order to push the record’s data to another platform. Ideally, the user could select one or multiple records in a table view, click Run on the script block, and the process would occur. Can anybody point me in the right direction on where to get started?

To: Airtable folks: I see that the documentation site is not mobile friendly. I usually read it on my phone and find it very hard to navigate. Please consider making it responsive.

Preface: this is the most frustrating API to POST to I have ever worked with, it’s incredible. I am attempting to POST a new record using Alteryx (a workflow tool with cURL’ish functionality) and I keep getting 1 of two errors: {"error":{"type":"INVALID_REQUEST_MISSING_FIELDS","message":"Could not find field \\"fields\\" in the request body"}} Or, when I re-aliased the alteryx field from “data” to “fields” - {"error":{"type":"INVALID_REQUEST_UNKNOWN","message":"Invalid request: parameter validation failed. Check your request data."}} Here is the data I am POST’ing: '{ "fields": { "Program Name":"Education Test", "Category":"Education" "External Id":"a00ie00QA4" } }' This exactly conforms to Airtable’s spec and I am still getting errors. Do you have any suggested approaches for troubleshooting or resolving this? Edit: worth pointing out that I have been able to successfully POST using Postman, but I am blocked when I am trying to “Productionalize” this in alteryx

Hello! I have a program that can make API calls via HTTP Request but you can only input URL’s. Is it possible with the Airtable API to create records using just a URL with query parameters? Everything I’m finding says to use curl but that’s not possible with the software I’m using. If not is there a service that my software can send a URL with query parameters to and then it takes it and executes the proper curl to Airtable? Maybe Postman? Thank you.

Hey Community, Is there the possibility to A. Let a script run via API? B. Give scripts a(n absolute) “time reference” in order to let them run in some kind of scheduled time frame? Feedback appreciated & Thanks in advance

Hi all. Total AirTable newbie here, and I’m hoping someone can please point me in the right direction. I’ve started working with a charity that uses AirTable to track requests that members of the public file for COVID-related assistance. There are two tables involved specifically in what I’m trying to achieve: Requests and Requestors. The person making the request fills out a WordPress form with name, postcode, etc. which are fields in the Requestors table and details about what they’re requesting from the charity; these are fields in the Requests table. Within the Requests table, there is a field which is a link to the Requestors. We end up with a lot of duplicated rows in the Requestors table if people make multiple requests. What I’d like to be able to do is intercept the form when it’s submitted, check to see if there’s a criteria match in Requestors (say on name and postcode) and if so, assign it to the existing requestor. If there is no match, then it would create a new requestor

Hello Community, This is how I am getting the records using the Python requests library: How to get more than 100 rows using Airtable API in Python using offest? But some fields only show the “Record_id” instead of actual values. I hit a wall trying to find solutions to this. How do I resolve this? Any leads would be appreciated. Thank you in advance!

I just cloned the to-do list example to get familiar with blocks and it starts with a can not read primaryField of null when compiled. It’s a small fix with the code i found, this is just if anyone else finds it also for the airtable team to update their sample code. Since there is no table selected in the beginning of the list table is null therefore need to add in a check for table present before calling table.primaryField. const records = useRecords(doneField ? view : null, {fields: [table ? table.primaryField : null, doneField]}); {fields: [table ? table.primaryField : null, doneField]}); update this object! Thank you!

Good morning, Developers, @Katherine_Duh, @Airtable_Admin I found pory.io on this message thread. As I’m struggling to study and practice Script-Block and Custom-Block simultaneously while I’m supposed building an excellent airtable frontend, I don’t have an airtable frontend at the moment. In its current state, pory.io looks very attractive for a temporary airtable frontend for me before maybe one day I will find time to do much more with the same REACT needed for the Custom Block… But after a registration at 0$ to try it, I stopped: I can’t figure out who is pory.io at all. Do you know these Developers? I’m really not enthusiastic about giving my airtable API-Key to a site I can’t find the Owner, the office address, the phone, the company registration number… What does the CSO think about it ? Best, oLπ

i can see and press the copy button for the examples where is the paste button and where do you paste what you have copied???

I built a working code to retrieve data from fake Airtable database with axios. You can see the code below perfectly working. No problem to retrieve data when is on the main table. Yet as you can assume some fields are connected to other tables (named in Airtable: parent child data or fields). Is the case in my table when you have the field “ORGANIZZAZIONE” (Organization) that is connected to another table having the organization datails as for example: NOME (Name) and TIPOLOGIA (Activity). As you can see in the code when I try to access to this data (ORGANIZZAZIONE) I have bad results. Probably I have to build an “axios.all” request but I can’t find the right way. The idea to append the data with another AIRTABLE’S API call to a child table it is OK (in code is in comment to JS file) …but it is not working. So can you help me? Here the codepen code working example: https://codepen.io/mauro99/pen/XWmQzjv

Is there a way at present to debug a custom block on my local while building it? It would be great if I can such debug error like these with better and more helpful build time error messages.

Hi all, Every week I manually copy and past sum total values from various tables and views in my base, to a Google Sheet. I do this to basically create a weekly snapshot of the totals in our Airtable sales forcecast. For example, 1st of May the total sales was £100,000, then on 7th May the total sales was £110,000. I can then track a £10 increase week on week. I’m essentially tacking the weekly value of a total of all records in a view, but to do this I have to manually copy and paste the values into a Google Sheet every Tuesday morning. It’s tedious as in practice I actually have to do this for around 30 fields every week. Would it be possible to instead of copying/pasting into a Google Sheet, to have a script populate a separate table in my base with the snapshots? For example the new snapshot table could look like this: Snapshot Date || April Sales £ || May Sales £ || June Sales £ || 1st May 2020 || £100,000 || £100,000 || £100,000 7th May 2020 || £110,000 || £100,000 || £100,000 So

Hello. I am really new to the Airtable API and for some reason connecting the API this way did not work- at = airtable.Airtable('Base_Key', 'Airtable_Key') But I got it working this way - get_url = ‘https://api.airtable.com/v0/BASE_ID/TABLE_NAME’ get_headers = { ‘Authorization’: ‘Bearer API_KEY’ } Response = requests.get(get_url, headers=get_headers) Response_Table = Response.json() However, this fetches only the first 100 records and am reading about offset and pagination but I am unable to figure how to incorporate it into this code. Thank you for the time!

Newbie trying to get my feet wet using a custom form to create new records. I am following the samples provided with the API documentation but the script completes before Airtable is able to finish it’s create function. I didn’t realize that was the problem until I threw in an alert() command to help me debug. That’s when the record would appear in my table. Looking forward to smacking my forehead when someone shows me some simple thing I am overlooking to stay in the script until Airtable is ready. Mahalo. (Hawaiian thank you ) <script src="https://code.jquery.com/jquery-1.12.2.min.js"></script> <script src="js/airtable.browser.js"></script> <script> $(document).ready(function(){ var Airtable = require('airtable'); var base = new Airtable({apiKey: 'keyXXXXXXXXXXXXXXX'}).base('appt4hr3kqdqXXXXX'); $('button#submit-bin').click(function() { base('Parchment').create( { "Tag": "3333", "bin#": 1 },

I saw there are 2 another topics involving metadata, but I want to emphasize how much important this is to developers to improve their applications and reduce request overhead in Airtable API, that would benefit both the company and their clients (which in this case, are developers). There is someone in the staff that can give us some information about this, if it’s even being developed?

I have a table called “2020Locations”, and its name seems to be causing a problem in the scripting block. I’m using: locationsTable = base.getTable(“2020Table”); But auto-complete doesn’t recognise locationsTable as a table. If I rename the table, or use the underlying tableID, then all is well. Is this a bug or a known issue? I couldn’t find it documented anywhere. Is there a better workaround than using the tableID instead?

Hey everybody, If I have to use somet sensitive information in my code, like an API key, what’s the best way to do that? I could put it right into the code, but my block to be open source (for the hackathon), so…any advice? Cheers, Alec

Hi there! I’m trying to set up an GET function to pull data from Airtable into Dexter (chatbot) based on a user inputting their e-mail address. I’m not getting an error message, but the response is coming back as empty. Any idea what’s going wrong here? is the user e-mail variable. $ GET https://api.airtable.com/v0//Sheet&20Name/ {“headers”: {“Authorization”: "Bearer "},“body”: {“records”: {“filterByFormula”: “({Email Address} = ‘’)”}}} ${{records.fields.First%Name}} //The field value I am trying to pull from Airtable. Thanks!

I am currently trying to pass in an option for the airtable API which is going through Dexter. The following POST method works: $ POST https://api.airtable.com/v0/<bot airtable_base>/Profile/ {"headers": {"Authorization": "Bearer <bot airtable_api_key>", "Content-Type": "application/json"},"body": {"fields": {"FormalName": "<get name>","Address": "<get address>"}}} but I can’t seem to get this GET command to work $ GET https://api.airtable.com/v0/<bot airtable_base>/Profile/ {"headers": {"Authorization": "Bearer <bot airtable_api_key>", "Content-Type": "application/json"},"body": {"filterByFormula": {(FIND("FormalName","My Name"))}} Anyone get this to work?

Hi there, On the DevPost Contest summary, it mentioned “Need Inspiration? We highly recommend taking an idea from our list of use cases.” Is that “highly recommend” just in reference to getting inspiration, or were these use-cases identified as high-value asks that the team is keen to see implemented? Put another way, does implementing or not implementing the use cases outlined have an impact on the “User Impact” or other overall score criteria? Thanks for the clarification!

Hello! We have a little new block in beta that you might find useful if you store JSON in your tables. You can select a cell in grid view for a single line or long text field, then start typing in the block to add or change the JSON contents. The JSON editor block makes it easier to work with JSON by formatting the contents of the field with colored syntax, indenting, and warnings for malformed JSON. Click here to join the beta. Once you click that link, the “JSON editor” block will be available in the list of blocks when you go to install a block. P.S. we’ve open sourced this block here so you can remix it if you’re in the custom blocks beta: GitHub - Airtable/apps-json-editor