Record updater

[apis/airtable/Record updater]

icon

---

Updates a single record 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, row

Input ports

• AT record: {"id": "string", "fields": {string: any}}

  Receives a single record to be updated in AirTable. Example:

  {<br>
    "id": "rect1iBB9su0rT0JI",<br>
    "fields": {<br>
      "number column": 0,<br>
      "string column": "value0"<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}}["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}}["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.