Docs

Data

Data components connect the flow to external data sources — HTTP APIs, files, databases, object storage, and inbound webhooks.


API Request

Makes an HTTP request to an external URL and passes the response downstream.

Use in a flow

  1. Add an API Request node to the canvas.
  2. Enter one or more URLs and select the HTTP Method.
  3. Optionally configure headers, query parameters, and body.
  4. Connect the Data or DataFrame output to the next step.
API Request (Data) ──► Processing / Agent / Output

You can also paste a cURL command to auto-fill request fields (enable Use cURL).

Parameters — Request

ParameterDefaultHiddenDescription
URLs—NoOne or more URLs to call, separated by commas.
MethodGETNoHTTP method: GET, POST, PATCH, PUT, or DELETE.
Use cURLfalseNoWhen enabled, populate fields from the cURL input instead of manual entry.
cURL—YesPaste a cURL command to fill headers, body, and method. Visible when Use cURL is enabled.
Query Parameters—YesQuery string parameters appended to the URL.
Body—YesRequest body as key-value pairs (for POST, PATCH, PUT).
HeadersUser-Agent defaultYesHTTP headers to send with the request.

Parameters — Options

ParameterDefaultHiddenDescription
Timeout30YesRequest timeout in seconds.
Follow RedirectstrueYesWhether to follow HTTP redirects.
Save to FilefalseYesSave the API response to a temporary file.
Include HTTPx MetadatafalseYesInclude headers, status code, and redirect history in the output.
Enable RetryfalseYesRetry failed requests.
Max Retries3YesMaximum retry attempts.
Backoff Factor2.0YesMultiplier for delay between retries.
Min Backoff (seconds)1.0YesMinimum wait between retries.
Max Backoff (seconds)10.0YesMaximum wait between retries.
Retry Status Codes404,408,429,500,502,503,504YesHTTP status codes that trigger a retry.
Workspace ID—YesWorkspace ID for secret resolution in URLs and headers.

Outputs

OutputDescription
DataThe API response as data objects.
DataFrameThe API response as a table.

Limitations

  • External network — The URL must be reachable from the flow runtime.
  • Secrets — Use workspace secret resolution where supported; do not hard-code credentials in flows.

File

Loads a file (uploaded or from a URL) and makes its content available to the flow.

Use in a flow

  1. Add a File node to the canvas.
  2. Upload files under Files, or connect a Server File Path from another component.
  3. Connect Data, DataFrame, or Message output to downstream steps.
File (Data) ──► CharacterTextSplitter / Agent / Embeddings

Parameters

ParameterDefaultHiddenDescription
Files—NoUpload one or more files, or provide file paths.
Server File Path—YesConnect a Data or Message object with a server file path instead of uploading.
Separator\n\nYesSeparator between multiple file contents when output as Message.
Processing Concurrency1YesNumber of files to process in parallel when multiple files are loaded.
Silent ErrorsfalseYesIf enabled, file errors are logged but do not stop the flow.
Delete Server File After ProcessingtrueYesRemove server-side files after processing.
Ignore Unsupported ExtensionstrueYesSkip files with unsupported extensions.
Ignore Unspecified FilesfalseYesSkip Data objects without a file path property.

Outputs

OutputDescription
DataParsed file content as data objects.
DataFrameFile content as a table.
MessageFile content as a single message string.

Limitations

  • Text files — Primarily supports text-based file types (txt, csv, json, md, and similar).
  • Archives — Zip and tar bundles are supported; contents are extracted and processed.

MySQL

Executes a query against a MySQL database and returns the results.

Use in a flow

  1. Add a MySQL node to the canvas.
  2. Enter the Database URL for your MySQL instance.
  3. Enter the MySQL Query to run.
  4. Connect Query Results to downstream components.
MySQL (Query Results) ──► Agent / Output / Processing

mysql:// URLs are automatically converted to use the PyMySQL driver.

Parameters

ParameterDefaultHiddenDescription
Database URL—NoMySQL connection URL (e.g., mysql://user:pass@host:3306/dbname).
MySQL Query—NoThe SQL query to execute.
Schema—YesOptional schema or database name (can also be set in the URL).
Include ColumnstrueYesInclude column names in the result.
Add Error DetailsfalseYesInclude detailed error information in the result when a query fails.
Pool Size5YesNumber of connections kept in the pool.
Max Overflow10YesExtra connections allowed beyond the pool size.

Outputs

OutputDescription
Query ResultsQuery results as a DataFrame.

Limitations

  • MySQL only — Requires a valid MySQL connection URL.
  • Credentials in URL — Connection strings may contain passwords; handle securely.
  • Query permissions — Results depend on the database user’s access rights.

PostgreSQL

Executes a query against a PostgreSQL database and returns the results.

Use in a flow

  1. Add a PostgreSQL node to the canvas.
  2. Enter the Database URL for your PostgreSQL instance.
  3. Enter the Postgresql Query to run.
  4. Connect Query Results to downstream components.
PostgreSQL (Query Results) ──► Agent / Output / Processing

postgresql:// URLs are automatically converted to use the psycopg driver.

Parameters

ParameterDefaultHiddenDescription
Database URL—NoPostgreSQL connection URL (e.g., postgresql://user:pass@host:5432/dbname).
Postgresql Query—NoThe SQL query to execute.
Schema—YesOptional schema name (can also be set in the URL).
Include ColumnstrueYesInclude column names in the result.
Add Error DetailsfalseYesInclude detailed error information in the result when a query fails.
Pool Size5YesNumber of connections kept in the pool.
Max Overflow10YesExtra connections allowed beyond the pool size.

Outputs

OutputDescription
Query ResultsQuery results as a DataFrame.

Limitations

  • PostgreSQL only — Requires a valid PostgreSQL connection URL.
  • Credentials in URL — Connection strings may contain passwords; handle securely.
  • Query permissions — Results depend on the database user’s access rights.

Redshift

Executes a query against an Amazon Redshift data warehouse and returns the results.

Use in a flow

  1. Add a Redshift node to the canvas.
  2. Enter the Database URL for your Redshift cluster.
  3. Enter the Redshift Query to run.
  4. Connect Query Results to downstream components.
Redshift (Query Results) ──► Agent / Output / Processing

redshift:// URLs are automatically converted to use the redshift_connector driver.

Parameters

ParameterDefaultHiddenDescription
Database URL—NoRedshift connection URL (e.g., redshift://user:pass@host:5439/dbname).
Redshift Query—NoThe SQL query to execute.
Schema—YesOptional schema name (can also be set in the URL).
Include ColumnstrueYesInclude column names in the result.
Add Error DetailsfalseYesInclude detailed error information in the result when a query fails.
Pool Size5YesNumber of connections kept in the pool.
Max Overflow10YesExtra connections allowed beyond the pool size.

Outputs

OutputDescription
Query ResultsQuery results as a DataFrame.

Limitations

  • Redshift only — Requires a valid Redshift connection URL and network access to the cluster.
  • Credentials in URL — Connection strings may contain passwords; handle securely.
  • Query permissions — Results depend on the database user’s access rights.

S3 Operations

Reads from or writes to an Amazon S3 bucket by listing buckets and objects and generating pre-signed URLs for secure access.

Use in a flow

  1. Add an S3 Operations node to the canvas.
  2. Select AWS Region, S3 Bucket, and one or more Object Keys.
  3. Choose Operations (GET, PUT, POST, DELETE) for the pre-signed URLs you need.
  4. Connect Result output to downstream steps.
S3 Operations (Result) ──► API Request / Agent / Output

Pre-signed URLs allow time-limited access to S3 objects without embedding long-lived credentials in the flow.

Parameters

ParameterDefaultHiddenDescription
AWS Regionus-east-1NoAWS region where the bucket is located.
S3 Bucket—NoSelect a bucket from your AWS account. Refresh to reload the list.
Object Keys—NoSelect one or more objects in the bucket.
OperationsGETNoOne or more operations for the generated URLs: GET, PUT, POST, or DELETE.
Schema JSON (Optional)—YesJSON override for region, bucket, object keys, and operations. When set, manual inputs are ignored.

Outputs

OutputDescription
ResultPre-signed URLs and metadata (bucket, objects, operations, region) as a data object.

Limitations

  • AWS credentials — IAM permissions must allow listing and pre-signing for the selected bucket.
  • Pre-signed URLs — Access is via generated URLs, not direct in-flow object streaming.
  • URL expiry — Pre-signed URLs use a fixed expiration configured by the runtime.

SQL Query

Executes a SQL query against a configured database connection and returns the results.

Use in a flow

  1. Add a SQL Query node to the canvas.
  2. Enter the Database URL for your database.
  3. Enter the SQL Query to run.
  4. Connect Query Results to downstream components.
SQL Query (Query Results) ──► Agent / Output / Processing

Works with any database supported by SQLAlchemy when a valid connection URL is provided.

Parameters

ParameterDefaultHiddenDescription
Database URL—NoSQLAlchemy-compatible connection URL.
SQL Query—NoThe SQL query to execute.
Include ColumnstrueYesInclude column names in the result.
Add ErrorfalseYesAppend error details to the result when a query fails.

Outputs

OutputDescription
Query ResultsQuery results as a DataFrame.

Limitations

  • Connection URL — Must be a valid SQLAlchemy database URL for your engine.
  • Credentials — Connection strings may contain passwords; handle securely.
  • Query permissions — Results depend on the database user’s access rights.

URL

Fetches content from a URL and returns the response. Can crawl linked pages recursively from a root URL.

Use in a flow

  1. Add a URL node to the canvas.
  2. Enter one or more URLs to fetch.
  3. Set Max Depth to control how far linked pages are followed.
  4. Connect Data, Message, or DataFrame output downstream.
URL (Message) ──► CharacterTextSplitter / Agent / Embeddings

At depth 1, only the initial page is loaded. Higher depths follow links on those pages.

Parameters

ParameterDefaultHiddenDescription
URLs—NoOne or more root URLs to crawl.
Max Depth1NoHow many link levels to follow from each root URL (1 = initial page only).
Prevent OutsidetrueYesStay within the same domain as the root URL.
Use AsynctrueYesUse asynchronous loading for faster crawls.
Output FormatTextYesText extracts readable text from HTML; HTML returns raw HTML.
Timeout30YesRequest timeout in seconds.
HeadersUser-AgentYesHTTP headers to send with requests.

Outputs

OutputDescription
DataFetched page content as data objects (text or HTML per Output Format).
MessageCombined text from all fetched pages as a single message.
DataFrameFetched content as a table.

Limitations

  • Network access — URLs must be reachable from the flow runtime.
  • Crawl scope — Max Depth and Prevent Outside control how much of a site is loaded; large sites can produce large outputs.
  • Invalid URLs — Malformed URLs cause the component to fail.

Webhook

Receives an inbound HTTP request and uses the payload as input to the flow.

Use in a flow

  1. Add a Webhook node to the canvas (typically at the start).
  2. Copy the Endpoint URL from the component — external systems send requests to this URL to trigger the flow.
  3. Connect Data output to downstream components.
External system ──POST──► Webhook ──► Processing ──► Output

When a live request arrives, the request body is passed downstream. Use Payload to test with sample JSON without an external caller.

Parameters

ParameterHiddenDescription
EndpointNoThe webhook URL for external systems to call. Copy this value into your integration.
PayloadYesSample request body for testing (JSON). Used when no live HTTP request is received.
cURLYesExample cURL command for the webhook endpoint.

Outputs

OutputDescription
DataThe webhook payload as a data object. JSON bodies are parsed; non-JSON text is wrapped in a payload field.

Limitations

  • Public endpoint — The webhook URL must be reachable by the calling system.
  • Flow must be deployed — Inbound webhooks require a published or running flow endpoint.
  • Payload format — Downstream components receive whatever structure the caller sends.