Dacris.Maestro.Data.Modify Interaction

Executes a SQL modification query or stored proc.

Sample State.json Input

{
  "sampleKey": {
    "connPath": "$.yourStateKey",
    "timeout": "10",
    "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"
  }
}