topic Re: How to set the values as tag name in JSON output in Talend Studio

How to set the values as tag name in JSON output

McJingles — Fri, 13 Mar 2020 13:57:50 GMT

Hey,

I want to get the JSON output by using the CSV file. If the input like below,

category_id;item_id;quantity

12;98;100

12;27;48

12;98;50

and I want to get output like below

{
"applicationMap": {
"applications": {
"12": {

"98": 100,

"27": 48,

"98": 50,

           }
        }
    }

}

Please let me know if there is any way to do it.

Thanks in Advance.!!

root — Fri, 13 Mar 2020 14:35:43 GMT

I suggest using tJsonDoc component from the Talend Exchange.

https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%252F1%252Fproducts%252F1438&pi=marketplace%252F1%252Fproducts%252F1438%252Fitems%252F2887

I have used tWriteJsonField component, it can achieve this, but, its not too powerful compared to tJsonDoc. If you can share what you have currently setup, we can try to generate the required output.

McJingles — Sat, 14 Mar 2020 06:15:12 GMT

Thanks for the reply @mbocquet

Let's take a look at what I've done here

Gave the CSV metadata and extract the columns which I need to generate the JSON using Tmap.

And convert the extracted values as JSON output by using TwriteJson. The output is looking like below

But I want to get the output like below.

{
    "applicationMap": {
        "applications": {
            "1266001": {

"986373001": 17.78,

"986368001": 48,

"986383001": 48,

}
}

}

On that place of invoice_id tag, I want to set the value as Tag name and same in the item_id tag too.

I don't need that tag names. Just I want to extract the values from that CSV file.

McJingles — Mon, 16 Mar 2020 08:04:33 GMT

If anyone knows the solution please let me know...!!!!