Jump to a Section
  • Create Row

    Create a new row in a Table.

    1. Options

    The first step for using this function is to provide the Table you want to add a record in. Click the “Choose Table” button and select the table you want to use.

    If your FLO will operate on different tables each time, you can choose the advanced option to “provide table at runtime“ which will result in an additional Table input field on the next step.

    Click Next to move to the next step.

    2. Data

    When the second tab comes up, you’ll be presented with the “Choose Fields” pop-out on the right. Click the checkboxes next to the column names you want to write to and then click “< Done”.

    Inputs:

    • Fields - will include each of the chosen fields (column names) from the table you selected. (If the table is provided at runtime, you have to manually add the field names and types you want to use.)
    • Table ID - this input field only appears if you’ve selected ”provide table at runtime” in the previous step.

    Outputs:

    • Row ID - the ID of the row you created.
  • Create Table

    This function creates a new Table, returning the Table ID for that table so that you can add rows to it in subsequent cards, import rows from a CSV or another Table, etc.  The new Table will be created in the “My Folder” personal folder for the user who is the owner of the FLO. The table may appear in another user’s “My Folder” personal folder if the Create Table card is located in a Child FLO. When the Create Table card exists in a Child FLO, whoever executed the Child FLO will have the table appear in their “My Folder” personal folder.

    The column schema is a list of objects, each with two keys:  name and type.  Name is the name of the table column, column is its type.  For example:

    [
      {
        "name": "First name",
        "type": "string"
      },
      {
        "name": "Last name",
        "type": "string"
      },
      {
        "name": "Jersey number",
        "type": "number"
      },
      {
        "name": "Active?",
        "type": "boolean"
      }
    ]

    You can create schema manually, or use the Read Table function to obtain the schema of an existing Table.  For example, if you wanted to create a new table that has the same schema as an existing table but one additional column, you could use the Read Table function followed by the Add to End function, then use that as the input to Create Table.

    Inputs:

    • Name - string - the name for the new table
    • Column Schema - list of objects, in the format above, defining the columns for the new table

    Outputs:

    • Table ID - string - the UUID for the table
  • Delete Row

    Deletes a row in a table.

    Options

    Input Fields

    • Delete By
      • Row ID (text): the unique identifier for the row, found by using Search Rows or by manually selecting it from the list.

    Output Fields

    There are no output fields for this card.

  • Export To CSV

    Export a Table to a CSV file, including all rows or a filtered subset of rows.  The CSV file will be created within the filesystem - from there you can use an upload card from a cloud service connector (Google Drive, Box, etc.) to move it to another cloud service, or an SFTP upload, etc.  CSV files can be imported into most spreadsheet programs including Excel.

    1. Options

    The first step for using this function is to provide the Table you want to export. Click the “Choose Table” button and select the table you want to use.

    If your FLO will operate on different tables each time, you can choose the advanced option to “provide table at runtime“ which will result in an additional Table input field on the next step.

    Click Next to move to the next step.

    2. Data

    When the second tab comes up, you’ll be presented with the “Choose Fields” pop-out on the right. Click the checkboxes next to the column names you want to include in your results and then click “< Done”.

    Inputs:

    • Filename - assign a name for the CSV output file (include “.csv” as the filename extension if you want it to open up automatically in an app like Excel)
    • Filter - To export a subset of rows, click the button to build your criteria.  To export all rows in the table, ignore this input.
    • Table ID - this input field only appears if you’ve selected ”provide table at runtime” in the previous step.

    Outputs:

    If you’re returning a single result, you get the following outputs:

    • CSV
      • File Content - The File ID of the CSV output file
  • Import From CSV

    This function imports the contents of a CSV file into a Table.  Click here for more information on CSV files.

    Once the file contents are imported, you can process the data in a variety of ways, including using the Search Rows function to retrieve a single row, a subset of rows, or all the rows, and process the rows one by one using a List function such as For Each.

    Important note: This function will soon be enhanced with additional options, including the ability to specify the separator value.

    Options

    The first step for using this function is to provide the Table you want to import to. Click the “Choose Table” button and select the table you want to use.

    If your FLO will operate on different tables each time, you can choose the advanced option to “provide table at runtime“ which will result in an additional Table input field on the next step.

    Inputs

    • Destination
      • Table ID (text) - the UUID for the table to import to.  Only shown if you selected “provide table at runtime” at the Options step
    • Source
      • File Content (file) - the File ID of the file to import from.  Must be a correctly-formatted CSV file.
    • Options
      • Select (list of text) - A list of column names to directly import into your table. Use this input when the CSV column names are exact matches of their counterparts inside of your destination table. Example- if my CSV file has a column header named “Column 1”, and the column I would like that information imported to in my table is also named “Column 1”, I would make sure to place “Column 1” in this list. However, if your mappings between the CSV and the table are more complex, use the “Mapping” input below, and leave this input blank.
      • Mapping (object) -  An object describing the mapping between my CSV’s column names, and the column names of the table I’m importing that information into. To build this object, make sure all keys are the name of the column header in your CSV file, and your table’s column names are its corresponding value. If a CSV column header is not mapped, it will not be imported into your table. Example- I have a CSV with two column headers called “Column 1” and “Column 2”. I would like all data in “Column 1” to be mapped to my table column “Column A”. I do not want to include any information from “Column 2” in my table. My “Mapping” object would look like so: {“Column 1” : “Column A”}, and would omit “Column 2” entirely.
      • Clear Destination (true/false) - set to true if you want to delete all existing rows from the table before importing the file.  Otherwise, it will append the new file data onto the end of the table.

    Outputs:

    • New Rows (number) - the number of rows imported.
  • Read Row

    Reads the values from a row in a Table.

    1. Options

    The first step for using this function is to provide the Table you want to read from. Click the “Choose Table” button and select the table you want to use.

    If your FLO will operate on different tables each time, you can choose the advanced option to “provide table at runtime“ which will result in an additional Table input field on the next step.

    Click Next to move to the next step.

    2. Data

    When the second tab comes up, you’ll be presented with the “Choose Fields” pop-out on the right. Click the checkboxes next to the column names you want to read and then click “< Done”.

    Inputs:

    • Row ID - the ID of the row you want to read. (You can get the ID as a result when you create a new row or when you search rows.)
    • Table ID - this input field only appears if you’ve selected ”provide table at runtime” in the previous step.

    Outputs:

    • Row
      • Created - Date and time the row was created
      • Updated - Date and time the row was updated
    • Fields
      • The chosen fields (column names) from the table you selected. (If the table is provided at runtime, you can manually add the field names and types.)
  • Read Table

    This function returns the column schema of a Table, as identified by the Table ID.

    It is most useful as an input to the Create Table function -> this lets you create a new table with the same columns as an existing table. You can obtain the Table ID as a FLO output, or by opening a Table in the designer - the Table ID is the last part of the URL, a UUID that looks something like this:  aebf9d12-f022-4798-8dc7-de740c64ce98

    The column schema is a list of objects, each with two keys:  name and type.  

    Name is the name of the table column, column is its type.  

    For example:

    [
        {
            "name": "First name",
            "type": "string"
        },
        {
            "name": "Last name",
            "type": "string"
        },
        {
            "name": "Jersey number",
            "type": "number"
        },
        {
            "name": "Active?",
            "type": "boolean"
        }
    ]

    Inputs:

    • Table ID - string - the UUID for the table

    Outputs:

    • Column Schema - list of objects, each with two keys:  name and type
  • Search Rows

    Find rows in a Table that match a provided set of conditions.

    Options

    The first step for using this function is to provide the Table you want to search. Click the “Choose Table” button and select the table you want to use.

    If your FLO will operate on different tables each time, you can choose the advanced option to “provide table at runtime“ which will result in an additional Table input field on the next step.

    Then, choose in Result Set whether you want to get the first matching row (a single result) or all matching rows (a list of results).

    Click Next to move to the next step.

    Choose Fields

    Next, you’ll be prompted with a list of fields to choose from. The Outputs section lists all of the column headers available on the table. Check the boxes next to fields you want to be returned with the search results.

    Click Done to proceed to Inputs and Outputs.

    Inputs:

    • *Filter* - click the button to build your search conditions. The Field dropdown lets you choose which table column to search. You can optionally drag and drop outputs from previous steps into the Value input if you want to search based on a value that comes from earlier in your FLO, such as a customer ID. Click + Add condition to search based on more than one test, such as Customer Type = Trial and Date > 1/1/18.
    • Sort
      • Column (dropdown) - which column to sort results by
      • Direction - choose “Ascending” (A to Z, 0 to 9) or “Descending” (Z to A, 9 to 0)
    • Limit - maximum number of records to return
    • Offset - record number to start the search at (where zero is the first record)

    • Table ID - this input field only appears if you’ve selected ”provide table at runtime” in the Options step.

    Outputs:

    If you’re returning a single result, you get the following outputs:

    • Row
      • Row ID - The ID of the row, or blank if zero matching rows were found
      • Created - Date and time the row was created
      • Updated - Date and time the row was last updated
    • Fields
      • The chosen fields (column names) from the table you selected. (If the table is provided at runtime, you have to manually add the field names and types for the fields you want returned by the search)

    If you’re returning multiple results, you get a list of Rows, where each row includes all of the above, or an empty list if zero matching rows were found.

  • Update Row

    Updates a row in a table.

    Options

    Input Fields

    • Update By
      • Row ID (text): the unique identifier for the row, found by using Search Rows or by manually selecting it from the list.
    • Fields
      • Column Name (text): enter the value to replace the existing value.

    Output Fields

    There are no output fields for this card.