Database¶
SQL¶
Runs SQL against SQL Server, PostgreSQL or SQLite, once per input item. Query returns the rows as items, Execute the number of affected rows.
Inputs: main · Outputs: main
| Parameter | Type | Description |
|---|---|---|
Connection (required)credentialId |
credential (Connection String) | Connection String credential: provider (sqlserver, postgres or sqlite) and connection string. |
Databaseprovider |
one of: fromCredential, sqlServer, postgreSql, sqlite |
From credential: its provider field (sqlserver, postgres or sqlite). Default: fromCredential. |
Operationoperation |
one of: query, execute |
Default: query. |
SQL (required)sql |
code | Use @name for values; they are passed as parameters, never inserted into the SQL text. Source code; {{ }} is not evaluated. |
Parametersparameters |
key/value pairs | @name → value or expression, evaluated per item. |
Timeout (seconds)commandTimeout |
integer | Default: 30. |