Record inserter

[apis/airtable/Record inserter]

icon

---

Inserts a single records into the specified AirTable table. The input received on parameter record must match the target table schema. For detailed parameter information, see the AirTable API documentation: https://airtable.com/api/meta

---

Keywords: airtable, insert, upload, create, append, record, row

Input ports

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

  Receives the record to insert into AirTable.

Example: ```json { "fields": { "number column": 0, "string column": "value0" } } ```

• 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

• record: {"fields": {string: any}}["fields"]

  Sends the record that was successfully inserted into AirTable. Example:

  {<br>
    "string column": "value0",<br>
    "number column": 0,<br>
    "bool column": false<br>
  }<br>
  ```<br>
  

• AT record:

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

  Sends the record that was successfully inserted into AirTable, including metadata like row ID, and date & time of creation. Example:

  {<br>
    "id": "recCz4d3k2DzDAZjx",<br>
    "createdTime": "2022-09-29T08:15:51.000Z",<br>
    "fields": {<br>
      "number column": 0,<br>
      "string column": "value0"<br>
    }<br>
  }<br>
  ```<br>
  

• 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.