Flow Studio
Datasources Capability Overview
Querying external databases, REST APIs, and the Data Ocean from workflow nodes — the datasource registry pattern, parameterized queries, and connection credential management.
Datasource Types
| Node Type | Source | Query Style |
|---|---|---|
SqlQueryNode | PostgreSQL, SQL Server, MySQL | Parameterized SQL (@param style) |
RestDatasourceNode | External REST API | HTTP GET/POST with path + query parameters |
DataOceanQueryNode | BizFirstGO Data Ocean | DataOcean query DSL with filters and projections |
Datasource Registry
Datasources are registered by datasourceId (string key). Node config references a datasourceId — never a raw connection string. The IDatasourceRegistry resolves the datasource definition and the IDatasourceConnectionFactory creates connections with credentials from ICredentialResolver.
Common Output Shape
// SQL and REST datasources:
{
"rows": [
{ "invoiceId": "inv-001", "total": 4750.00, "status": "pending" },
{ "invoiceId": "inv-002", "total": 2100.00, "status": "pending" }
],
"rowCount": 2
}
// Access in expressions:
// $output.queryInvoices.rows[0].total
// $output.queryInvoices.rowCount
SQL injection prevention: Only parameterized queries are allowed. String interpolation in SQL (building query strings with
$output values) is blocked at the executor level. Always use the parameters map.