Connecting AirTable and LiveCode

Anything beyond the basics in using the LiveCode language. Share your handlers, functions and magic here.

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
AlexM_Cogapp
Posts: 3
Joined: Thu Jul 30, 2015 3:39 pm

Connecting AirTable and LiveCode

Post by AlexM_Cogapp » Wed Jan 17, 2024 12:53 pm

I'm a long-term LiveCode (and HyperCard) programmer. Recently I have been experiencing the joys of AirTable - it really is very good.

Now I would like to connect the two so I can read and write AirTable data via LiveCode. I'm probably not the only person who would find this useful.

Is it possible? If so, how?

A sample stack would be very handy.

richmond62
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 9397
Joined: Fri Feb 19, 2010 10:17 am
Location: Bulgaria

Re: Connecting AirTable and LiveCode

Post by richmond62 » Wed Jan 17, 2024 12:56 pm

A sample stack would be very handy.
Details of where to find out about AirTable would be handy.

AlexM_Cogapp
Posts: 3
Joined: Thu Jul 30, 2015 3:39 pm

Re: Connecting AirTable and LiveCode

Post by AlexM_Cogapp » Wed Jan 17, 2024 3:28 pm

I've managed to find a way to read data.

Using my Personal Access Token - you put it in the httpHeaders and it all works.

So far so good.

What I want to do now is to find a way to update and add data to AirTable.

Using 'put' and 'push' doesn't seem to work.

AlexM_Cogapp
Posts: 3
Joined: Thu Jul 30, 2015 3:39 pm

Re: Connecting AirTable and LiveCode

Post by AlexM_Cogapp » Wed Jan 17, 2024 3:30 pm

richmond62 wrote:
Wed Jan 17, 2024 12:56 pm
A sample stack would be very handy.
Details of where to find out about AirTable would be handy.
Google 'AirTable API'

paul@researchware.com
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 136
Joined: Wed Aug 26, 2009 7:42 pm
Location: Randolph, MA USA
Contact:

Re: Connecting AirTable and LiveCode

Post by paul@researchware.com » Thu Jan 18, 2024 1:53 pm

In addition to the AirTable API reference (already mentioned) at https://airtable.com/developers/web/api/introduction
I believe there are some lessons or tutorials on using LiveCode to access REST API available somewhere at Livecode.com, such as this one: https://lessons.livecode.com/m/4071/l/1 ... a-rest-api
Paul Dupuis
Researchware, Inc.

AnthonyKoor
Posts: 1
Joined: Thu Sep 26, 2019 4:53 am

Re: Connecting AirTable and LiveCode

Post by AnthonyKoor » Fri May 03, 2024 11:02 am

To get it working, you'll want to use the AirTable API for reading and writing data. Just use the tsNet library in LiveCode to handle HTTP requests, which will communicate with AirTable using JSON.

Post Reply

Return to “Talking LiveCode”