Jump to a Section

Events

  • New Row in Table

    Start a FLO when a new row is created in a table.

    Options

    • Base (dropdown): A dropdown of your available bases in Airtable.
    • Table (dropdown): A dropdown of your available tables within the base.

    Input

    The input fields in this card are dynamically generated based on your instance.

    Row

    • Row ID (text): Unique identifier of the row.

    Output

    Context

    • Execution ID (text): Unique identifier associated with the execution of the FLO.

Actions

  • Create Row

    Create a row in a specified Airtable table.

    Required fields are indicated in red.

    Options

    • Base (dropdown): A dropdown of your available bases in Airtable.
    • Table (dropdown): A dropdown of your available tables within the base.

    Input

    The input fields in this card are dynamically generated based on your instance.

    Output

    Row

    • Row ID (text): Unique identifier of the row.
  • Delete Row

    Delete a row in a specified Airtable table.

    Required fields are indicated in red.

    Options

    • Base (dropdown): A dropdown of your available bases in Airtable.
    • Table (dropdown): A dropdown of your available tables within the base.

    Input

    • Row ID (text): Unique identifier of the row.
  • Read All Rows

    Reads all rows within a specified Airtable table.

    NOTE This event works for tables containing fewer than 4,500 rows and will truncate any rows beyond that.

    Options

    • Base (dropdown): A dropdown of your available bases in Airtable.
    • Table (dropdown): A dropdown of your available tables within the base.

    Output Fields

    The output fields in this card are dynamically generated based on your instance.

    Rows (list): A list containing objects representing the rows within the table and their data.

  • Read Row

    Read a row in a specified Airtable table.

    Required fields are indicated in red.

    Options

    • Base (dropdown): A dropdown of your available bases in Airtable.
    • Table (dropdown): A dropdown of your available tables within the base.

    Input

    Row

    The input fields in this card are dynamically generated based on your instance.

  • Search Rows

    Search rows in a specified Airtable table.

    Required fields are indicated in red.

    Options

    • Base (dropdown): A dropdown of your available bases in Airtable.
    • Table (dropdown): A dropdown of your available tables within the base.
    • Result (dropdown): Choose from First Matching Row and All Matching Rows.

    Input

    Search

    • Filter Formula (text): Formula you are using to filter the rows.

    Output

    Result

    The output fields in this card are dynamically generated based on your instance.

    • Rows (list)
      • Row ID (text): Unique identifier of the row.
  • Update Row

    Update a row in a specified Airtable table.

    Required fields are indicated in red.

    Options

    • Base (dropdown): A dropdown of your available bases in Airtable.
    • Table (dropdown): A dropdown of your available tables within the base.

    Input

    The input fields in this card are dynamically generated based on your instance.

  • Custom API Action

    Make a custom, authenticated HTTP call to the Airtable API.

    NOTE: This action is unlike other Airtable cards. Refer to Airtable API.

    Options

    • Request Type (drop-down): one of five supported HTTP request methods (sometimes called verbs) in custom API calls:
      • GET retrieves data from a web server based on your parameters. GET requests a representation of the specified resource. If successful, GET will receive a 200 OK response message with the requested content. Refer to additional documentation here.
      • POST sends data to a web server based on your parameters. POST requests include actions like uploading a file. Multiple POSTs may result in a different outcome than a single POST, so you should be cautious about unintentionally sending multiple POSTs. If a POST is successful, you will receive a 200 OK response message. Refer to additional documentation here.
      • PUT sends data to a location in the web server based on your parameters. PUT requests include actions like uploading a file. The difference between a PUT and POST is that PUT is idempotent, meaning that the result of a single successful PUT is the same as many identical PUT’s. If a PUT is successful, you will receive a 200 response message (usually 201 or 204). Refer to additional documentation here.
      • PATCH applies partial modifications to a resource on a web server based on your parameters. PATCH is not idempotent, meaning that multiple PATCHs could have unintended consequences. If a PUT is successful, you will receive a 200 response message (usually 204). Refer to additional documentation here.
      • DELETE deletes the specified resource from the web server based on your parameters (if the resource exists). If a DELETE is successful, you will receive a 200 OK response message. Refer to additional documentation here.

    Input

    Request

    • Relative URL (text): address on the web server you are attempting to interact with. Relative URL means that you don’t have to explicitly specify the protocol at the beginning of the URL (such as “http://“). This suggests to the web server that the interaction is occurring on the server (in this instance).

      Example: /user/me
    • Query (object or text): JSON object that determines the action taken at the URL

      Example: {"name":"something-urgent"}
    • Headers (object): JSON object that determines the content type of the request. This will usually be a replica of the example below.

      Example: {"Content-type":"application/json"}
      • Body (object): data for your selected HTTP request.

    Output

    Response

    • Status Code (number): success or failure of your HTTP request. Here is a list of all status codes.
    • Headers (object): detailed context for the status code, unrelated to the output body. Response headers are dependent on your selected HTTP request option. Note that not all headers are response headers.
    • Body (object): data returned from your selected HTTP request (for example, the data from a GET request).