Bulk records inserter

[apis/airtable/Bulk records inserter]

icon

---

Inserts multiple records into 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, insert, upload, create, append, bulk, batch, mass

Input ports

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

  Receives arbitrary number of records to be inserted into AirTable. Example:

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

  Sends records that were successfully inserted into AirTable. Example:

  [<br>
    {<br>
      "number column": 0,<br>
      "string column": "value0"<br>
    },<br>
    {<br>
      "number column": 1,<br>
      "string column": "value1",<br>
      "bool column": true<br>
    }<br>
  ]<br>
  ```<br>
  

• AT records:

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

  Sends records that were successfully inserted into AirTable, in the format returned by AirTable, including metadata like row ID, and date & time of creation. Example:

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

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