How to Flatten tRESTlient JSON structure with Static code

joefrancois — Wed, 21 Mar 2018 05:19:16 GMT

Hello,

I am trying to extract multiple row from a JSON tRESTClient input with some static data inject in the row creation. My JSON input look like so:

[
{
"OrderID": 6675,
"FirstName": "John",
"LastName": "Doe",

"Address": "123 spring st",

"OrderItemList": [
{
"ItemID": "736940759",
"ItemQty": 1,
"ItemDesc": "Widget One",
"ItemUnitPrice": 68.99,

},
{
"ItemID": "736940858",
"ItemQty": 1,
"ItemDesc": "Widget Two",

"ItemUnitPrice": 37.99,

}
],
"PromotionList": [
{
"PromotionName": "Code",
"Coupon": "Code",
"DiscountAmount": 9.6
}
]

I am trying to get the following out put

I have been pulling my hair out, any help would be greatly appreciated.

Regards,

Joseph

topic How to Flatten tRESTlient JSON structure with Static code in Talend Studio