/
getSqlResultList


getSqlResultList

See also: Actions

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, (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 Version10.4

Examples

Related How To's

Related content