Description | Get a list of results from a dynamic SQL query or other dynamic SQL request. Specify the SQL using the sql parameter or indirectly using '--sql @' to specify a file with SQL. Use a site configuration entry with database connection information either directly as a site for the action or indirectly as a reference on the database parameter like '--database @'. |
|---|
Required Parameters | (sql or file), (database or url) |
|---|
Optional Parameters | limit, columns, select, options, outputFormat, outputType, file, append, encoding, field, channel |
|---|
Type | Get |
|---|
Category | Info |
|---|
Output Formats | 1 - CSV table of all columns |
|---|
Replacement Variables | |
|---|
| Hosting | |
|---|
| Since Version | 10.4 |
|---|
Examples | |
|---|
|