Documentation
Commands
Commands are steps in a flow. Each command receives data, processes it, and passes it along.
Getting Data
Rows → Get
Returns a list of records from a table.
Output: List of records
Example: Get all orders from the "Orders" table.
Rows → Find
Applies a filter to a list of records.
Input: List of records
Output: List of records
Example: Find all orders where status = "New".
Rows → Sort
Sorts a list of records by specified rules.
Input: List of records
Output: List of records
Example: Sort products by price — from highest to lowest.
Rows → Slice
Extracts a portion of the list of records. Parameters can be expressions with variables.
Input: List of records
Output: List of records
Example: Take only the first 10 records from the list.
Table selection → Get
Gets a list with a single record that is selected in the table. If the flow is executed in the editor — the first record is taken. If launched from a table without selection — error.
Output: List of records
Example: Get the selected product record for processing in a flow.
Modifying Data
Rows → Add
Creates a record in a table. Returns a list with one created record.
Output: List of records
Example: Create a new record in the "Sales" table with the current date and product.
Formulas are supported: Days = <Days (ms)> * 30
Rows → Update
Updates records that were passed as input.
Input: List of records
Output: List of records
Example: Update the "Delivery date" field in found orders.
When executed inside loops (Rows → For each), it may slow down the flow.
Rows → Delete
Deletes records from a table.
Input: List of records
Example: Delete all records with status "Archive".
Table → Request commit
Requests saving data in the specified table.
Changes will be saved only after user confirmation.
Table → Request commit all
Requests saving in all modified tables.
Changes will be saved only after user confirmation.
Variables
Set
Saves data to a variable. Can override the type.
Input: Any data type
Output: Input type or Specified type
Example: Save the list of products to variable all_products for later use.
Get
Outputs a value from a variable.
Output: Saved data type
Example: Get the value of variable total_sum for display.
Vars → Math
Executes a mathematical expression with variables.
Output: Number
Example: Calculate price * quantity and save the result.
Rows → Value → Get
Extracts a value from the first record in the list.
Input: List of records
Output: Column data type
Example: Get the value of the "Name" column from the first record in the client list.
Rows → Values → Set vars
Extracts the first record and writes column values to variables.
Input: List of records
Output: List of records
Example: Write "Name" and "Email" values to variables from the selected client.
Calculations and Grouping
Rows → Math
Applies a mathematical function to a list of records.
Input: List of records
Output: Number
Example: Calculate the sum of all orders for a month.
Rows → Group
Groups records by columns and performs aggregation (sum, average, etc.).
Input: List of records
Output: List of records
Example: Group sales by categories and calculate the sum in each.
Type → To Number
Converts input data to a number, if possible.
Input: Any type
Output: Number
Example: Convert the string "123" to the number 123.
Number → Round
Rounds a number.
Input: Number
Output: Number
Example: Round the average price to 2 decimal places.
Type → Define
Redefines the data type. Not all combinations work correctly.
Input: Any type
Output: Specified type
Example: Convert a number to a string for concatenation with text.
Logic and Control
When
Executes a nested flow if conditions are true.
Example: If total > 10000, send a notification.
Rows → For each
Executes a nested flow for each record. Input is a list with the current record.
Input: List of records
Example: For each product in the order, check stock availability.
Exit
Terminates the flow execution.
Example: Stop the flow if a required field is empty.
Function → Define
Defines a function for reuse. Use Type → Expect for input expectations.
Function → Call
Calls a defined function.
Input: Expected type
Output: Type of the last command in the function
Example: Call the discount calculation function.
Flow → Use
Executes another flow, passing context and data. Variables from the nested flow are available in the main flow.
Input: Expected type
Output: Type of the last command
Example: Reuse the tax calculation flow.
Condition → Define
Defines a filter and saves it to a variable for reuse.
Example: Save a complex filter "active clients with orders in the last month" to a variable.
JSON
JSON → Set vars
Extracts values from JSON by paths (JSPath) and saves to variables.
Input: JSON string
Output: Input data
Example: Extract data.user.name from an API response.
JSON → Get
Extracts a value from JSON by path (JSPath).
Input: JSON string
Output: String
Example: Get items[0].price from a JSON response.
JSON → For each
Executes a flow for each element of an array or key-value pair of an object.
Input: JSON string
Example: Process each item in a JSON array from an external API.
JSON → Update
Updates values in JSON by paths.
Input: JSON string
Output: JSON string
Example: Replace the status value with "processed" in JSON.
Helpers
Print prev
Returns input data without changes.
Example: Pass data through an intermediate step unchanged.
Message
Displays a message after flow execution. Can use variables.
Example: Display "Processed {{count}} records".
Comment
Adds a visual text block in the editor.
Input: Any data
Output: Input data
Example: Add a comment "Filtering block" for navigation in the flow.
Text output
Outputs the specified text.
Output: String
Example: Generate a report title.
Type → Expect
Defines the expected input data type. Returns them if matched.
Input: Expected type
Output: Input data
Example: Ensure a list of records was received as input.
Tokens context → Expect
Defines the expected context: a set of variables and functions. Useful for nested flows.
External Requests
Fetch Request
Executes a request to an external resource and writes the result to variables.
Input: Any data
Output: Input data
Example: Get exchange rates from an external API. More →
📌 Next step: Flows →
📌 Also useful: HTTP Requests | JSPATH