Skip to content

Data processing

Following example shows how Input data are processed, transformed and returned from input to output.

Input schema

Column	Data type
DataJSON	JSON
Source	string

Input data

{
  "DataJSON": {
    "Company": "ZQQa-5sssdF",
    "CustomerAccount": "Za-2aQQB",
    "OrganizationName": "Company1"
  },
  "Source": "Application1"
}

Output schema

Column	Data type
Code	string
Code2	string
OriginID	string
CreatedDate	DateTime
ModifiedDate	DateTime
UpdateType	string
TaskRunID	integer
DataJSON	JSON

Output data

{
  "Code": "ZQQa-5sssdF",
  "Code2": "Za-2aQQB",
  "OriginID": "44718f0d-8317-eb11-96c9-4ccc6af6a7ae",
  "CreatedDate": "2020-10-26T12:02:01.063",
  "ModifiedDate": "2020-10-26T12:02:01.063",
  "UpdateType": "I",
  "TaskRunID": "999",
  "DataJSON": {
    "Company": "ZQQa-5sssdF",
    "CustomerAccount": "Za-2aQQB",
    "OrganizationName": "Company1"
  }  
}