Records updater

[apis/airtable/Records updater]


Updates up to 10 records in the specified AirTable table. The input received on parameter records must match the target table schema.

For detailed parameter information, see the AirTable API documentation: https://airtable.com/api/meta


Keywords: airtable, update, append, record, rows

Input ports

  • AT records: {"id": "string", "fields": {string: any}}[]

    Receives up to 10 records to be updated in AirTable. Example:

    [<br>
      {<br>
        "id": "rect1iBB9su0rT0JI",<br>
        "fields": {<br>
          "number column": 0,<br>
          "string column": "value0"<br>
        }<br>
      },<br>
      {<br>
        "id": "recpIPBXdPlv5wv7D",<br>
        "fields": {<br>
          "number column": 1,<br>
          "string column": "value1",<br>
          "bool column": true<br>
        }<br>
      }<br>
    ]<br>
    ```<br>
    
  • params:

    {"apiKey": string, "baseId": string, "tableName": string}

    Receives the authentication & table parameters required to construct the request. API Key: In AirTable, go to 'Help?' and click on 'API Documentation'. Scroll to the "Authorization" section to retrieve your API key. Base ID: In AirTable, go to 'Help?' and click on 'API Documentation'. Find the ID of the base in the introduction. Table Name: Use the table name located on the tab of the spreadsheet. Example:

    {<br>
      "apiKey": "key...",<br>
      "baseId": "app...",<br>
      "tableName": "..."<br>
    }<br>
    ```<br>

Output ports

  • records:

    {"id": "string", "fields": {string: any}}[][number]["fields"][]

    Sends the records that were successfully updated in AirTable.

Example: ```json [ { "number column": 0, "string column": "value0" }, { "number column": 1, "string column": "value1", "bool column": true } ] ```

  • AT records:

    {
      "id": string,
      "createdTime": "string",
      "fields": {"id": "string", "fields": {string: any}}[][number]["fields"][]
    }[]

    Sends records that were successfully updated in AirTable, in the format returned by AirTable, including metadata like row ID.

Example: ```json [ { "id": "rect1iBB9su0rT0JI", "createdTime": "2022-09-29T07:25:20.000Z", "fields": { "number column": 0, "string column": "value0" } }, { "id": "recpIPBXdPlv5wv7D", "createdTime": "2022-09-29T07:25:20.000Z", "fields": { "number column": 1, "string column": "value1", "bool column": true } } ] ```

  • response:

    {"status": number, "headers": {string: any}, "body": string}

    Sends the entire response from the AirTable API without modification.

  • error: {"error": string, optional "details": any}

    Sends the error, if one occurred.

Last updated