RoutineHub • AirtableKit

AirtableKit

Make the best use of Airtable via Shortcuts

Description

Make the best use of Airtable via Shortcuts.

How to Use

Get an API Key

You will need a personal API key. You can get one by visiting your Airtable account page under the API section. Have the API key ready when you first run the shortcut.

Setup

With your API key ready, run the shortcut. You will be prompted with a set of steps on how to setup your configuration. Configuration includes the following items

Creating the /AirtableKit/ folder
Creating the /AirtableKit/airtable.json file
Storing the API key.
(optional) Saving a list of your base IDs in the /AirtableKit/ folder

Usage

You can download a demo shortcut by running AirtableKit and choosing Download Demo.

The way it works is that you will need to pass a dictionary of the function that needs to be called and the relevant data.

Common Arguments

Key	Description
fn	The function to call
base	The base name or base ID of the relevant base
table	The table the is needed to be accessed

Functions and arguments

createRecord

Key	Description
fields	A dictionary of keys and values for the data to be added

updateRecord

Key	Description
record_id	record id of the record that needs to be updated
fields	A dictionary of keys and values for the data to be updated

listRecords

Key	Description
filter	optional. A filter expression
view	optional. View name of a custom view defined in Airtable
pageSize	optional. The number of records returned in each request. Must be less than or equal to 100. Default is 100.
maxRecords	optional. The maximum total number of records that will be returned in your requests. If this value is larger than pageSize (which is 100 by default), you may have to load multiple pages to reach this total.

getRecord

Key	Description
record_id	record id of the record that needs to be accessed

deleteRecord

Key	Description
record_id	record id of the record that needs to be deleted

Format of the fields parameter

fields is a dictionary containg the Airtable field names as keys and their corresponding values. A simple fields value would be something like this:

{
    "Field1": "value1",
    "Field2": "value2",
    "Field3": "value3"
}

In case of values that are linked to records to another table, you usually pass an array of the ids of the related records. Example:

{
    "Field1": "value1",
    "Field2": "value2",
    "Field3": "value3",
    "LinkedField": [
        "reqQead8349"
    ]
}

AirtableKit allows this, it would mean that you need the ids beforehand. As of v1.3.0, it is easier to add linked records when creating or updating records.

{
    "Field1": "value1",
    "Field2": "value2",
    "Field3": "value3",
    "LinkedField.linked": {
        "table" : "Another Table",
        "filters" : [
            "field1='xvalue1'",
            "field2='xvalue2'"
        ]
    }        
}

The format of the linked field would be as follow:

Key : The fieldname suffixed by .linked to signify AirtableKit that this is a linked fields. Value : A dictionary containing 2 keys, (2) the name of the table where to find the linked record, and (2) an array of filters to locate the linked record.

Table1

T1Col1	T1Col2
Value1	Some Description
Value2	Another Description

Table2 - T2Col2 is a link to a record in Table1

T2Col1	T2Col2
V1.1	Value1
V1.2	Value1
V2.1	Value2

If we were to insert a record in Table2 for example, the fields parameter would be structured like this:

{
    "T2Col1": "V2.2",
    "T2Col2.linked": {
        "table" : "Table1",
        "filters" : [
            "T1Col1='Value2'"
        ]
    }        
}

Roadmap

~~Save API Key~~
~~Basic CRUD~~
~~Cache base list~~
Attachments
Cached tables list