Bulk records updater

[apis/airtable/Bulk records updater]

icon

---

Updates multiple specific records in the specified AirTable table. The input received on parameter records must match the target table schema.

Sends records to the AirTable API in batches of 10. For detailed parameter information, see the AirTable API documentation: https://airtable.com/api/meta

---

Keywords: airtable, update, append, bulk, batch, mass

Input ports

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

  Receives arbitrary number of 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 } } ] ```

• responses:

  {"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.