Select SQL Data
Perform select queries in SQL schema
Parameters¶
| Label (internal name) | Type | Default | Description |
|---|---|---|---|
| Schema Variable Name (var) | string | DbDescriptor | Name of the variable where schema is stored. |
| SQL SELECT query (select_sql) | textarea | SQL SELECT Query. | |
| Expected Format (format) | Possible Values Below | object | Try to map request output to a specific format |
| • Generic Object (object) | format | ||
| • Known Schema (schema) | format | ||
| - Table Name (tableName) | string | Table schema for parsing rows selection. | |
| • Integer for count(*) queries (int64) | format | ||
| Output Format (output) | Possible Values Below | jsonbody | How to store output |
| • JsonBody (jsonbody) | output | ||
| • Variable (variable) | output | ||
| - Variable Name (outputVar) | string | Name of the variable to store |