Atlassian uses cookies to improve your browsing experience, perform analytics and research, and conduct advertising. Accept all cookies to indicate that you agree to our use of cookies on your device. Atlassian cookies and tracking notice, (opens new window)
Teams
, (opens new window)
CSV Command Line Interface (CLI)
  • Reference
    Reference
     This trigger is hidden
  • User's Guide
    User's Guide
     This trigger is hidden
  • Administrator's Guide
    Administrator's Guide
     This trigger is hidden
  • Release notes
    Release notes
     This trigger is hidden
  • Share data with the Support team
    Share data with the Support team
     This trigger is hidden
  • Downloads
    Downloads
     This trigger is hidden
Results will update as you type.
  • User's Guide
    • Advanced Topics
    • Examples
    • Reference
      • Actions
        • convertCsv
        • copyCsv
        • getClientInfo
        • getReplacementVariableList
        • help
        • run
        • runFromCsv
        • runFromJson
        • runFromList
        • runFromSql
        • runIf
        • setReplacementVariables
        • copyFile
        • getUpgradeInfo
        • provideFeedback
        • runFromPropertyFile
        • sleep
        • getSqlResultList
        • getAutomation
        • getAutomationList
        • runAutomation
        • runFromAutomationList
      • Parameters
      • Action Categories
      • Action Types
  • Administrator's Guide
    Calendars
You‘re viewing this with anonymous access, so some content might be blocked.
/
getSqlResultList

    


getSqlResultList

Dec 03, 2024

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

Since Version10.4

Examples

Related How To's

, multiple selections available, Use left or right arrow keys to navigate selected items
cli-action
cli-action-getsqlresultlist
cli-parameter-sql
cli-parameter-file
cli-parameter-database
cli-parameter-url
cli-parameter-limit
cli-parameter-columns
cli-parameter-select
cli-parameter-options
cli-parameter-outputtype
cli-parameter-append
cli-parameter-encoding
cli-parameter-channel
cli-parameter-action
cli-parameter-dateformat
cli-parameter-dateformat2
cli-parameter-help
cli-parameter-special
cli-parameter-quiet
cli-parameter-verbose
cli-parameter-debug
cli-action-category-info
cli-action-type-get
cli-parameter-field
cli-parameter-outputformat
Unable to render {include} The included page could not be found.
Unable to render {include} The included page could not be found.
{"serverDuration": 15, "requestCorrelationId": "e88a5ff976254015b8dc600d8c31a126"}