Development &amp; APIs

Fetch a single record using Visual Basic .NET code

Dear Community Your help would be very much appreciated if you knew how to fetch one record from my table in Visual Basic Script VB.net code, could you help? Jonathan P.S. Here is the equivalent of what I want to do using the curl utility: curl.exe https://api.airtable.com/v0/app6hDo2mwb2dVccO/letting-agent-details/recly4jCvMGGMYbyu -H “Authorization: Bearer YOUR_API_KEY” Here is the equivalent of what I want to do using node.js: var Airtable = require(‘airtable’); var base = new Airtable({apiKey: ‘YOUR_API_KEY’}).base(‘app6hDo2mwb2dVccO’); base(‘letting-agent-details’).find(‘recly4jCvMGGMYbyu’, function(err, record) { if (err) { console.error(err); return; } console.log(record); });

160

TuurInspiring

HTTP error 504 response not in JSON format

As far as I can tell I aways get nice JSON responses, but with this error the response comes in the form of a HTML page. My error handling didn’t like that. <!DOCTYPE html> <html> <head> etc <h1 class="my2">This page is taking too long to load.</h1> Is this intentional?

21214

Hamlet_ArcherNew Participant

filterByFormula array contains

I would like to filterByFormula the records with arrays that contain a certain ID. The arrays look something like this: Arr [a, b, c, d] [c, d] [a] How does one filterByFormula to get all the records with arrays containing ‘a’?

522

Ken11New Participant

PNG transparency lost when uploaded via app

It may be a feature but just wanted to point this out. I see the following behavior uploading a PNG image with transparency through the browser (Safari 9.1 on OS X), the file is uploaded as a PNG with transparency uploading the same file via the iOS app via the PHOTO icon at top results in the image being converted to JPG automatically, losing the transparency uploading the same file via the iOS app but using the general “upload files” file picker, the image is uploaded as a PNG file with the transparency intact. Is this an intended spec? here’s the file I used

421

Chris_AdlerNew Participant

.Net API for Airtable

Anyone know of a .Net wrapper DLL that exposes the Airtable API?

573

ky_leNew Participant

How to synchronous db my sql to airtable

As the title, let me ask is how to sync data from my sql to airtable. Thank all !

120

TuurInspiring

HTTP Error 404 confusion

Hi guys, I’m getting {"error":{"type":"MODEL_ID_NOT_FOUND","message":"Base not found"}} when a base is missing (or simply wrong). I’m seeing {"error":{"type":"MODEL_ID_NOT_FOUND"}} when a record in a valid table is not found. I thought that’s quite odd since I’m getting a nice {"error":{"type":"TABLE_NOT_FOUND" ... when there’s something wrong with the table pointer. In other words, could you differentiate the message further? The ‘recXXXX’ part of the pointer after the table name should make the difference I guess. Thanks in advance!

190

James_SteedParticipating Frequently

Trouble with curl GET from excel 2011 Mac VBA

Trying to use a curl GET from excel VBA 2011 Mac to grab some records. Took me a while to figure out how to get authentication to work, did that, but have hit another bump. I am copying the GET syntax directly from Paw which returns the correct results. In excel the same syntax does not return the same results. It seems I can only manage to pass a single filter to Airtable. This code will return ALL records in the Stunning view of BestTableEver. “curl -X GET --header ‘Authorization: Bearer keyYour_Bearer_Key’ https://api.airtable.com/v0/appYour_Fabs_App/BestTableEver?view=Stunning&maxRecords=1” This code will return a single record from BestTableEver that is actually filtered out of the Stunning view, but is the first record you get from Paw without naming the view. “curl -X GET --header ‘Authorization: Bearer keyYour_Bearer

737

TuurInspiring

Connection errors

Hi team, About every 60 minutes I’m getting a couple of connection errors. Error resolving 'api.airtable.com' This has been going on for a week or so. Are you doing something like rotating servers or should I have a word with my server guy? Thanks in advance!

Timothy_FungNew Participant

Updating table using API

Hi, When I create a new entry I want to update the same entry using the recordId. However, I am unsure on how to do this.

UrbanissNew Participant

Table isn't consistently updating/refreshing upon rows from API

During some API calls, the table rows aren’t updated and there’s need to refresh the browser to get the accurate data.

TuurInspiring

Error 422 & non-existing collaborators

I think there could be a small improvement in the JSON that comes back when trying to add an illegal collaborator (for example: someone has not yet accepted an invitation to a base). This is the response I’m seeing: {"error":{"type":"INVALID_VALUE_FOR_COLUMN","message":"Cannot parse value \\"[object Object]\\" for field Rep"}} I suspect the ‘object’ part should be something else. :winking_face:

373

Debasish_HalderNew Participant

Java API to get all available bases

My Requriement To get all available bases and the corresponding table that are available in my account using Java API Current Issue Unable to find generic API to find all the available bases. API’s are specific to the bases currently available in my account. Can you please help to provide the API (Resource path) to get all the available bases.

512

DSJNew Participant

Attachments: Authentication possible?

Hi! Is it possible to give airtable a username and password it should use to download an attachment? I tried the http://username:passwd@url.com and that didn’t work. Thanks!

Peter_LorentzenNew Participant

Ignore case for filterByFormula

Hi everyone! I’m having a problem where matching a record using filterByFormula (through curl) is behaving in a case-sensitive way. I need it to ignore the case. The request is constructed like this (Angular): return $http({ medthod: 'GET', url: api.BASE_URL + '/Members' + "?filterByFormula=(Email='" + email + "')", headers: { 'Content-type': 'application/json', 'Authorization': api.KEY } }) api.BASE_URL and api.KEY are fetched from a config file and email is passed into the function. The resulting request URL is this: <REMOVED BASE URL>/Members?filterByFormula=(Email=%27passed@email.com%27) The problem is that this appears to ONLY find a record with that exact string, where I would like it ignore the case. A possible workaround would be to force the email input field (the string being passe

572

Cindy_ShapiroParticipating Frequently

Getting the internal record ID immediately after a record create

If I’m creating a new record in a table and need to grab the internal airtable assigned value immediately after the create call to the API, how to I get that? Thanks in advance! Cindy

393

Hjortur_SteingrNew Participant

Change checkbox with a pushbutton in php

Hi there. I am not a programmer but i have managed to build a php webpage (I used Sample Web App as a reference) that displays some information from my Airtable via api. I really want to have a push button or a checkbox and submit button that “checks” a checkbox in airtable field. Can someone help me with this ?

Jonathan_FullerKnown Participant

Trying to output linked table data in a nested list

Using PHP and Curl (mainly because I don’t know any better…) I have a page that lists all the “Names” in one table and am attempting to do a nested list of “Orders#” under the “Name” however if I echo the “Orders” field it just outputs the word Array… I’m assuming I need to make a GET call to the Linked Table I’m just not sure how to do that within the same foreach loop I’m using. Any help is greatly appreciated! J Fuller

693

cbkempNew Participant

POST problems using Google Apps Script

I’m trying to create a front end webapp for collecting sign up information and storing it in AirTable but can’t get AirTable to accept my post request. Originally, I had all of the field value pairs directly in the payload. Oops! I have since then created the fields object with field value pairs inside of it but keep getting INVALID_REQUEST_UNKNOWN. The message reads that the parameter validation fails. I’ve even gone so far as to copy and pasting the example object code from the API doc’s to make sure I’m using the exact names and data types of fields but receive the same error! I’m not trying to add data to any formula, rollup, or lookup fields that can’t be edited. (I tried to use AirTable.js by pasting the source code but GAS didn’t like that and kept throwing me random debug errors) Any ideas??

200

Guy_GalonskaNew Participant

Can't figure out an issue when using FilterbyFormula

I’m using this code: item_call = at.get(‘Master reference’, input_item) Assembly_name = item_call[‘fields’][‘Assembly name’] Assembly_bom = at.get(‘BOM’, filter_by_formula="{Part of assembly} = %s" % Assembly_name) print json.dumps(Assembly_bom, indent=4, sort_keys=True) I’m getting a 422 error, but can’t really figure out whats going on. Also, the same code seemed to work a few hours ago. the 422 error url is: https://api.airtable.com/v0/xxx/BOM?filterByFormula={Part of assembly} = ASB00004_Assembly It’s important to say that {Part of assembly} is a linked field. Thanks for any helpers! Guy

111

Taeke_TuinstraNew Participant

Details about the 5-requests/second limit

Hello, I started using airtable this week and I’m already using the API with PHP. Works like charm. Before starting to build more solutions I’d like to know some more details about the 5 api requests / second limit. Is this limit per table, per base, per user or mayby per session? Do paid plans have a higher rate? Thanks.

241

Larry_PriceKnown Participant

Calculated Fields not Returning 0 Values

So, here’s another in my long line of small issued in the API. I have simple formula fields in my table that add other columns together. It’s literally field a = field x + field y + field z. When I return field a, the api doesn’t return “0” properly. Instead, I get the most recent non-zero value in the field. It should look like: It Looks Like: 0 0 0 0 5 5 0 5 1 1 4 4 0 4 0 4 0 4 I’m using the API to generate simple reporting in Google Sheets, so I have apps script turning the api json object into an array of strings. I’ve verified that there isn’t any weird behavior here with 0 values in my implementation of the apps script. The api only does th

291

Stephen_ChapmanParticipating Frequently

Airtable Table Data to Excel VBA

Hi all. Does anyone have an example of how to call Airtable data into a VBA script to output in a Microsoft Excel spreadsheet?

1026

Sam_BauchNew Participant

API POST performance

Getting pretty poor performance for creating records. A POST request to create a record often lasts >30 seconds. Naturally the table I am creating records in references other tables, has a lot of fields, etc., but 30s is really frustrating. Any tips for improving perf on my end? Anything in the works on Airtable’s end?

522

Donald_NewlandsKnown Participant

Airtable API Node.JS and Insomnia

Hi, I’m trying to use Insomnia to debug my API requests, but I’m not getting very far with Node.JS… If I go to the API docs and grab the Node.JS (with our key) and paste it into the body section of Insomnia as “JSON Raw Text” and send it using https://api.airtable.com/v0 as the base URL with GET, I get “invalid request body” in return. What do I need to turn the node.js code from the API docs into a usable JSON request body? Thanks! -Donald

140