Skip to content

Processing simple input data

This example shows how to easily transform input data into another structure.

Input schema

Column	Data type	Allow null	Description
ObjectID	`integer`	No	`ObjectID` value
ObjectName	`string`	No	`ObjectName` value
ObjectJson	`JSON`	Yes	`ObjectJson` value
ObjectContent	`Base64`	No	`ObjectContent` value

Input data

[
    {
        "ObjectID": 125,
        "ObjectName": "Testing object",
        "ObjectJson": 
        { 
            "ID": 125, 
            "Name": "Testing object",
            "CreationDate": "2023-03-13T09:16:47.780"
        },
        "ObjectContent": "VGVzdGluZyBvYmplY3QgY29udGVudA=="
    },
    {
        "ObjectID": 215,
        "ObjectName": "New testing object",
        "ObjectJson": 
        { 
            "ID": 215, 
            "Name": "New testing object",
            "CreationDate": "2023-03-16T03:35:10.700"
        },
        "ObjectContent": "VGVzdGluZyBvYmplY3QgY29udGVudA=="
    },
]

Mapping configuration

Mapping value
`${input.ObjectID}`
`Testing description`
`${input.ObjectID} - ${input.ObjectName}`
`${input.ObjectJson}`
`${input.ObjectContent}`

Ouput schema

Column	Data type	Allow null	Description
ID	`integer`	Yes	`ObjectID` value
Description	`string`	Yes	Fixed string value
ObjectIDWithName	`string`	Yes	Concatenation of input schema properties `ObjectID` and `ObjectName`
Json	`JSON`	Yes	`ObjectJson` JSON value
Content	`Base64`	Yes	`ObjectContent` Base64 value

Output data

ID	Description	ObjectIDWithName	Json	Content
125	Testing description	125 - Testing object	{ "ID": 125, "Name": "Testing object", "CreationDate": "2023-03-13T09:16:47.780" }	VGVzdGluZyBvYmplY3QgY29udGVudA==
215	Testing description	215 - New testing object	{ "ID": 215, "Name": "New testing object", "CreationDate": "2023-03-16T03:35:10.700" }	VGVzdGluZyBvYmplY3QgY29udGVudA==