Generate an API key from Airtable Account

First, you need to have an Airtable account and create an API key.

  1. Open your Airtable account.

  2. Click your account icon from the upper right side of the page

  3. Then select the Account option from the list

  4. On the Account page, you will see the Generate API key button

  5. When you click the button, Airtable automatically creates an API key for your personnel usage from your account

  6. Copy this generated key to your clipboard.

How to reach your Airtable Database's End-point

  1. Go to https://airtable.com/api address and list your existing databases.

  2. Then select which database you want to use (Let's assume that we are trying to connect Movie Database to Code2)

  3. Select the 'List Records' selection from the MOVIES TABLE

  4. Airtable automatically generates a curl example on the right side of the page

  5. Copy the URL which was shared in the example section

Connect your Airtable data to a simple Code2 table

  1. Once you have completed the steps defined above, it is now time to switch to the Code2 editor screen

  2. Add a 'Table' component to the page from the component list

  3. Then select the table name from the navigation tree and choose the Datasource tab from the right menu.

  4. Click the 'Open REST Configuration' button.

  5. Set the following parameters which you copied from your Airtable account:

    1. URL: GET --> https://api.airtable.com/v0/app4s......

    2. Content Type: application/json

    3. Data Root: records

  6. Then click to 'Add Parameters' button to set your Airtable API Key

    1. Name: Authorization

    2. Source: Static Value

    3. Value: Bearer YOUR_API_KEY

    4. Send In: header

  7. Click to 'Send' button to test your Airtable configuration

  8. If there is no error in the configuration, Editor mode will automatically switch to Output mode, and you will see your data

  9. After that, you only need to map your Airtable data with Code2 table columns.

  10. To see the result, click the 'Finish' button. Your table will start to show your data stored in your Airtable database.

Did this answer your question?