Flow Studio
Integration Nodes
Integration nodes connect your workflow to external systems — REST APIs, GraphQL endpoints, and databases. All credentials are resolved via the ICredentialResolver service (never stored as plain text in node config).
http-request
Makes an HTTP/HTTPS request to any REST endpoint.
| Field | Description |
|---|---|
| Method | GET, POST, PUT, PATCH, DELETE, HEAD, OPTIONS |
| URL | Endpoint URL (supports expressions: https://api.example.com/users/{{$json.userId}}) |
| Headers | Key-value pairs. Values support expressions. |
| Body | Request body (JSON, form, raw). Supports expressions. |
| Credential ID | ID of stored credential (bearer token, API key, OAuth) resolved at runtime |
| Timeout | Request timeout in seconds (default: 30s) |
| Retry | Retry on failure: count, delay, exponential backoff |
Output: { status, headers, body }
graphql
Executes a GraphQL query or mutation against a GraphQL endpoint.
| Field | Description |
|---|---|
| Endpoint | GraphQL server URL |
| Query / Mutation | GraphQL document (multi-line editor) |
| Variables | JSON variables passed to the operation (supports expressions) |
| Credential ID | Auth credential |
Database Nodes
All database nodes share a common configuration pattern: connection credential + SQL/query + parameters.
| Node | TypeCode | Supports |
|---|---|---|
| MySQL | mysql-query | SELECT, INSERT, UPDATE, DELETE, stored procedures |
| PostgreSQL | postgresql-query | All SQL + JSON operators, RETURNING clause |
| SQL Server | sqlserver-query | T-SQL, stored procedures, OUTPUT clause |
| MongoDB | mongodb-query | find, insertOne, updateOne, aggregate pipelines |
| Redis | redis-command | GET, SET, DEL, HGET, HSET, LPUSH, LPOP, EXPIRE |
// Parameterised SQL example (prevents injection):
query: "SELECT * FROM orders WHERE customer_id = @customerId AND status = @status"
parameters: {
customerId: "{{$json.customerId}}",
status: "pending"
}
Credential Security
Never paste database connection strings or API keys directly into node configuration fields. Always create a named credential in the Credentials vault and reference it by ID. Credentials are encrypted at rest and resolved only at execution time.