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

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

> Macro (details)
> 
> | **Description** | Run actions generated by SQL provided by the sql parameter, a file, or standard input. Replacement variables will be set representing each column (case sensitive, blanks removed) in the result set and the corresponding column value for each row processed. |
> | --- | --- |
> | **Required Parameters** | [sql](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70785862), ([file](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70784297) or [common](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70790043) or [input](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70789760)), ([database](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70784989) or [url](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70784481)) |
> | **Optional Parameters** | [dbUser](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70784887), [dbPassword](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70785211), [propertyFile](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70785111), [continue](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70790023), [simulate](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70784353), [field](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70784837), [encoding](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70785169), [clearFileBeforeAppend](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70784803), [findReplace](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70790127), [findReplaceRegex](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70785127) |
> | **Type** | [Run](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70780909/Action+Types#ActionTypes-Run) |
> | **Category** | [Run](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70780591/Action+Categories#ActionCategories-Run) |
> | **Output Formats** |  |
> | **Replacement Variables** |  |
> | **Hosting** |  |
> | **Since Version** |  |
> | **Examples** | [runFromSql](https://appfire.atlassian.net/wiki/spaces/JCLI/pages/70782732/Examples#Examples-runFromSql) |

## Related How To's

> Macro (cql-query)