SQL Query (Single)

Basic Information

Description	This node is use to extract data from SQL.
Input	Without
Output	One table.
Usage Tags	SQL , READER , SOUCES

Node Settings

SQL Query Connection ( string, required) : A connection string or connection tag.
Output Table (string, optional) : setting description
SQL QUery (string, required) : A list of queries that node executes.

Tips and Advanced usage

Use this node to extract data from SQL. It can execute any query.

Examples

Example 1

This example extracts all the data from SQL table called ExperimentData. It uses connection tag for the connection.

Example configuration

JSON

{
  "properties": {
    "connection": "<storage>",
    "ResultName": "ExportedData",
    "Query": "Select * from ExperimentData"
    
  }
}

Example 2

This example extracts the data from the ExperimentData table but it is filtered for the current user and selected project.

In order for this node to work, project metadata must be already available in process contex (i.e. must be selected from the form or stored as metadata in some other way). The username metadata is built it metadata that will reflect the username of currently logged user.

Example configuration

JSON

{
  "properties": {
    "connection": "<storage>",
    "ResultName": "ExportedData",
    "Query":   "Select * from ExperimentData where User = @username and Project = @project"
    
  }
}