Transform multi level JSON message to multi level JSON Output and generate a file output

Anonymous — Sat, 09 Dec 2017 14:05:16 GMT

I need to create a map between multi level json input file and transform using map source json format to json format and generate a multi level output json file as mentioned below.

Sample input :

Order.json

{
"Order":
{
"@Banner": "ABCD",
"@OrderID": "123456",
"@OrderNo": "890",
"OrderLine":
[
{
"OrderedQty":"1",
"ItemID":"ITEM01",
"UnitOfMeasure":"EACH",
"ProductClass":"GOOD"
},
{
"OrderedQty":"2",
"ItemID":"ITEM02",
"UnitOfMeasure":"EACH",
"ProductClass":"MEDIUM"
}
]
}
}

Sample JSON output expected :

PurchaseOrder.json

Re: Transform multi level JSON message to multi level JSON Output and generate a file output

Anonymous — Sat, 09 Dec 2017 14:15:29 GMT

I managed to get it working using approach mentioned below.

tFileInputJson --> tWriteJsonField --> tFileOutputRaw

Note : I am using tFileOutputRaw instead of tFileOutputJson as i am already parsing the data in tWriteJsonField.

Any comment of better practice to improve my solution and maping the same is much appreciated.

json2json_Order2PO_Transform6.zip

topic Re: Transform multi level JSON message to multi level JSON Output and generate a file output in Talend Studio

Transform multi level JSON message to multi level JSON Output and generate a file output

Re: Transform multi level JSON message to multi level JSON Output and generate a file output