Mapping > Aggregate > Average
Streaming average across iterations.
Streaming average across iterations.
Sample-and-hold memory cell that re-emits the last written value on every trigger.
Streaming count across iterations.
Streaming maximum across iterations.
Streaming minimum across iterations.
Streaming sum across iterations.
Returns array item at the specified index
Shift a Date or DateTime forward by a configurable amount and unit.
Render a Date, Time or DateTime as a string using a strftime-style format.
Convert a text to a date object
Convert a numeric Unix timestamp into a UTC DateTime.
Extract a single component (year, month, day, hour, …) from a date or datetime as a number.
Shift a Date or DateTime backward by a configurable amount and unit.
Convert a text to a datetime object
Calculate the duration between two dates
Returns current date and time
Convert a text to a time object
Assign multiple values to an Excel row
Get multiple values from an Excel row
Get a sheet from an Excel file
Extract cell from an Excel row
Put value into a cell on an Excel row
Get the cell value of an Excel sheet
Converts a number to a geolocation point
Foundational exit node automatically created inside every iterator scope.
Foundational entry node automatically created inside every iterator scope.
Return true only if every element of a list passes the per-element sub-graph predicate.
Keep only the elements of a list whose per-element sub-graph evaluates to true.
Return the first element of a list whose per-element sub-graph evaluates to true.
Flatten a nested JSON object/array into a single-level object whose keys are dotted paths.
Bucket elements of a list into a JSON object keyed by a per-element sub-graph result.
Transform each element of a list by running a sub-graph per element.
Fold a list into a single accumulated value by running a sub-graph per element.
Return true if at least one element of a list passes the per-element sub-graph predicate.
Sort a list by a per-element key extracted by a sub-graph.
Combine N input lists into one list of N-tuples.
Add a value to a JSON object
Data modeling, enforce complex object value.
Remove a single top-level key from a JSON object.
Get multiple values from a JSON object
Find the first object in a JSON array whose key field matches a filter value.
Parse a JSON string into a JSON value.
Add a key and value to a JSON object
Return the list of top-level keys of a JSON object.
Merge multiple JSON objects into one
Remove several top-level keys from a JSON object in one call.
Validate a JSON object against a schema
Extract a value from a JSON object using a path
Return the list of top-level values of a JSON object.
Split a list into a list of fixed-size sub-lists.
Concatenate several input lists into one.
Test whether a list contains a particular value.
Return the first element of a list.
Flatten a nested list — turn `[[1,2],[3,[4,5]]]` into `[1,2,3,4,5]`.
Return the 0-based position of the first occurrence of a value in a list, or -1 if absent.
Return the last element of a list.
Returns a random item from an list
Reverse the order of elements in a list.
Return a contiguous sub-list between start (inclusive) and end (exclusive).
Drop duplicate elements from a list, preserving the first occurrence's position.
Logical AND condition
Compare two Date or DateTime values with a chronological operator and emit a boolean.
TODO
Boolean NOT — emit the negation of an incoming boolean.
Filter number by a condition
First-non-null selector — emit the first wired value matching the configured type.
Logical OR condition
Filter text by a condition
Filter text by multiple conditions
Test whether a value matches a configured PValue type.
Return the absolute value of a number.
Average of numbers
Convert text into a BM25 sparse vector for hybrid vector search.
Restrict a number to a [min, max] range.
Count of numbers
Division of numbers
Compute the logarithm of a number, optionally with a custom base.
Maximum value of numbers
Mininum value of numbers
Remainder of the division of two numbers
Raise a number to the power of another number
Multiplication of numbers
Round a number
Return the square root of a number.
Total addition of numbers
Package an entire mini-graph behind a single reusable node.
Emit a fixed value baked into the configuration on every invocation.
Externally-fed constant — value supplied by the parser caller at execution time.
Convert a text to a number
Map a number to a text
Generate a random number
Extract several columns from a Parquet row in a single pass.
Read a CSV file line by line
Read an Excel file line by line
Read an Excel file workbook
Read a Google Sheet line by line
Read a JSON file elements by elements
Read a JSON file line by line
Read a PDF file page by page
Read an XML file elements by elements
Decode a standard base64 string into its UTF-8 source.
Encode a UTF-8 string to its standard base64 representation.
Concatenate two text values
Test substring containment.
Validate and decompose an email address per RFC 5322.
Test whether a string ends with a given suffix.
Join text values with a separator
Get the length of a text
Convert a text to lowercase
Look up a number from a string via a static mapping table.
Pad a string to a minimum character count by repeating a single fill character.
Validate and format a phone number using libphonenumber.
Generate a random text
Generate a random unique identifier
Capture element from a text using regexp
Replace a text match with another text
Reverse a string by character (Unicode-safe).
Decode a 22-char base64 ShortGuid back into the canonical 36-char UUID.
Slugify a string into a URL-safe form.
Split a text into a list of text values
Test whether a string begins with a given prefix.
Slice a substring out of a string by character indices.
Template text using placeholders
Re-case a string into camelCase, PascalCase, snake_case, kebab-case, and more.
Strip whitespace from the start, end, or both sides of a string.
Cap the output to a maximum number of characters with an optional ellipsis.
Convert a text to uppercase
Encode a canonical UUID into the 22-char base64 ShortGuid form.
Write an CSV file line by line
Write an Excel file line by line
Write a Google sheet line by line
Write elements to a JSON file
Write elements to a JSONL file
Write elements to an XML file
Add a value to a XML node
Get an attribute from a XML path
Get multiple values from an XML node
Learn about XML path
Read or write data from your Pennylane accounting software
Read or write data from your Sage Active accounting software.
Submit a JSONL batch job to an AI provider and stream results back as a file.
One-shot chat completion against a configured AI provider (OpenAI, Mistral, Anthropic, Gemini, Cohere, Moonshot, Scaleway AI).
Split JSONL records into smaller chunks using an LLM-driven chunking method.
Generate vector embeddings for each record in a JSONL file using a configured AI provider.
Vectorize a query attribute on a JSON record so it can be searched against a vector store.
Add LLM-extracted fields (sentiment, entities, classifications, …) to every record of a JSONL file.
Keep or drop each record of a JSONL file based on a natural-language acceptance criterion evaluated by an LLM.
Deterministically split text into fixed-size character chunks with optional overlap.
Extract a knowledge graph (entities + relations) from documents or JSON records using an LLM.
Split markdown text along heading boundaries into size-bounded chunks.
Expose connected Virtual Tools as a Model Context Protocol (MCP) endpoint that external MCP clients can call.
Submit a JSONL batch job to Mistral and stream results back as a file.
Send message to mistral chat
Generate embeddings
Generate embeddings search query
Run Mistral OCR on a document URL or file and emit page text plus optional structured annotations.
Generate embeddings using OpenAI's embeddings API.
Generate a single search vector via OpenAI's embeddings API.
Embed vector into Qdrant vector database
Generate embeddings search query
Deterministically split text by trying separators from coarsest to finest until chunks fit a size budget.
Re-score and filter a list of candidate documents against a query using an LLM/reranker provider.
Run a tool-calling LLM agent that picks among connected Virtual Tools to satisfy a prompt.
Declare a tool callable by a Virtual Agent or exposed via an MCP Endpoint, with typed argument outputs.
Read or write data from your Hubspot CRM
Read or write data from your Sage Sales Management CRM.
Entry-point node that fires when Sage Sales Management pushes a webhook for a configured entity/action.
Run SOQL Query / QueryAll / Search calls against your Salesforce instance.
Submit a Salesforce Bulk API 2.0 ingest job (insert / upsert / update / delete / hard-delete).
Run a vector search against a Pinecone index.
Insert or update vector points into a Pinecone index.
Run a dense or hybrid (dense + sparse) search against a Qdrant collection.
Insert or update points (id + dense + optional sparse vectors + payload) into a Qdrant collection from a JSONL file.
Invoke a deployed Supabase edge function over HTTP.
Insert (or upsert) rows into a Supabase / PostgREST table.
Read rows from a Supabase / PostgREST table with filters, ordering, and pagination.
Update rows in a Supabase / PostgREST table matching one or more filters.
Interact with Big Query
Download a file from Google Drive when a trigger fires.
Upload a file (or JSON payload) into a Google Drive folder.
Read a sheet from Google
Write into a Google sheet
Protect your workflow with ED25519 algorithm check
Protect your workflow with static check
Trigger your workflow from a hook
Call your backend from a hook
Entry-point node that exposes typed inputs to be invoked from another workflow via Trigger Workflow.
Start another workflow at a Start-From-Workflow entry node, optionally waiting for it to finish.
Perform a DELETE http request
Extract cookie from http response
Extract header from http response
Perform a GET http request
Perform a paginated loop of http request
Perform a PATCH http request
Perform a POST http request
Perform a PUT http request
Make an HTTP request
Web file endpoint
Web file endpoint response
Web JSON endpoint
Web JSON endpoint response
Public HTTP endpoint that accepts multipart/form-data uploads with multiple files and triggers the workflow once per file.
Extract data from a JSON
Build a JSON Object
Build a text from a template
Convert an Excel sheet to a JSONL file
Execute given mapping
Keep a range of lines from a JSONL file
Convert a JSONL file to an Excel file
Publish products to Salsify SXM platform.
Export or bulk-import products against your Shopify store.
Import products into your Syndigo PIM environment.
Entry-point node that runs the workflow once when the user clicks Play.
Periodically launch workflows.
Download a file from a remote SFTP server.
Upload one or more files (or JSON payloads) to a remote SFTP server.
Launch workflows from slack command.
Send message to slack channel.
Download file from storage.
Rename a file flowing through the workflow according to a templated pattern.
Upload file from storage.