---
title: "getSqlResultList"
canonical: "https://support.appfire.com/space/JCLI/70781003/getSqlResultList"
format: markdown
---
> Macro (aura-html)

See also: [Actions](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70787366)

> Macro (details)
> 
> | **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](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70785862), ([database](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70784989) or [url](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70784481)) |
> | **Optional Parameters** | [limit](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70789871), [columns](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70784781), [select](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70790299), [options](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70784233), [outputFormat](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70789869), [outputType](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70784259), [file](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70784297), [append](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70790085), [encoding](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70785169), [field](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70784837), [channel](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70787241) |
> | **Type** | [Get](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70780909/Action+Types#ActionTypes-Get) |
> | **Category** | [Info](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70780591/Action+Categories#ActionCategories-Info) |
> | **Output Formats** | 1 - CSV table of all columns |
> | **Replacement Variables** |  |
> | **Hosting** |  |
> | **Since Version** | 10.4 |
> | **Examples** |  |

## Related How To's

> Macro (cql-query)