Record fetcher

[apis/airtable/Record fetcher]

icon

---

Fetches a single record from an AirTable table by it's ID. For detailed parameter information, see the AirTable API documentation: https://airtable.com/api/meta

---

Keywords: airtable, select, get, fetch, record, row

Input ports

• record ID: string

  Receives the identifier of the record relative to an AirTable table. Example:

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

• record: {string: any}

  Sends the retrieved AirTable record. Example:

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

• AT record:

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

  Sends the retrieved AirTable record, 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>
  <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.