Airtable

Connecting to Airtable

For an overview of the connector, please refer to the following link:

• Connecting to DB/SaaS

• Dashboard
• Local Version

1

Create a Connector

Select the “Connectors” tab on the top page and press the “Create” button.

2

Enter Airtable Credentials

Select Airtable and press the sign-in button.

After entering the information, press the Create button to complete the creation. If there are any errors, please check the connection details again.

3

Obtain access_token from the created connector

Once created successfully, you can obtain the connector name from the list.

Use the dedicated function to enter the connector name in the Python code and obtain the access_token.

Python

import morph
from morph import MorphGlobalContext
from morph_lib.api import get_auth_token


@morph.func
def main(context: MorphGlobalContext):
    access_token = get_auth_token("connection_name")
    # ↓↓↓ Process using access_token ↓↓↓

1

Create a Connector

Select the “Connectors” tab on the top page and press the “Create” button.

2

Enter Airtable Credentials

Select Airtable and press the sign-in button.

After entering the information, press the Create button to complete the creation. If there are any errors, please check the connection details again.

3

Obtain access_token from the created connector

Once created successfully, you can obtain the connector name from the list.

Use the dedicated function to enter the connector name in the Python code and obtain the access_token.

Python

import morph
from morph import MorphGlobalContext
from morph_lib.api import get_auth_token


@morph.func
def main(context: MorphGlobalContext):
    access_token = get_auth_token("connection_name")
    # ↓↓↓ Process using access_token ↓↓↓

In the local version, you need to directly write the credentials in ~/.morph/connections.yml. For other methods, please create them in the dashboard.

1

Edit connections.yml

If the file does not exist in ~/.morph/connections.yml, create it beforehand and then edit it.

shell

mkdir ~/.morph
touch ~/.morph/connections.yml

connections:
  airtable-connection: # Unique arbitrary name
    type: airtable # Fixed
    method: airtable_oauth # Fixed
    refresh_token: str
    client_id: str
    client_secret: str
    redirect_uri: str
    access_token: str # Optional

2

Use the connector in the code to retrieve data

Use the dedicated function to enter the connector name in the Python code and obtain the access_token.

Python

import morph
from morph import MorphGlobalContext
from morph_lib.api import get_auth_token


@morph.func
def main(context: MorphGlobalContext):
    access_token = get_auth_token("connection_name")
    # ↓↓↓ Process using access_token ↓↓↓

The refresh of the access_token is a dashboard feature, so the one described will always be used in the local environment.

When actually specifying the connector and executing the file, the priority is as follows: Also, note that only connectors created in the dashboard can be used in the environment where morph deploy is performed.

1. Connectors described in ~/.morph/connections.yml on the local machine
2. Connectors registered in the cloud