Dacris.Maestro.Data.Select Interaction

Executes a SQL SELECT query on an in-memory SQL table, producing a JSON array in the state.

Sample State.json Input

{
  "sampleKey": {
    "connPath": "$.yourStateKey",
    "timeout": "10",
    "outputFile": "folder1/folder2/yourFile.txt",
    "outputPath": "$.yourStateKey",
    "schemaPath": "$.yourStateKey",
    "separator": "yourText",
    "query": "Txt_File_In_Constants_Folder",
    "parameters": {
      "schema": {
        "your_fieldName": "string|integer|number|date|CustomValue"
      },
      "data": {
        "your_fieldName": "yourText"
      }
    },
    "retryTimes": "10",
    "retryDelay": "10"
  },
  "dataConnections": {
    "your_connName": {
      "systemType": "MemorySql|SqlServer|Firebird|Postgres|MySQL|MockData|CustomValue",
      "connString": ""
    }
  },
  "customDataProviders": {
    "your_systemType": "yourText"
  }
}