Doubt about changing format of JSON

Anonymous — Sat, 16 Nov 2024 02:01:12 GMT

Hi,

I'm receiving some JSON data in this format:

{
    "paging": {
        "pageIndex": 1,
        "pageSize": 100,
        "total": 1
    },
    "measures": [
        {
            "metric": "A",
            "history": [
                {
                    "date": "2019-04-23T20:56:48+0000",
                    "value": "15"
                }
            ]
        },
        {
            "metric": "B",
            "history": [
                {
                    "date": "2019-04-23T20:56:48+0000",
                    "value": "1.0"
                }
            ]
        }
    ]
}

What I'd like to obtain is another JSON with the date (which is the same for all the metrics that I'm going to take) and, then, the metrics with their values this format (some kind of denormalizing the data related to metrics in order to get the pairs "metric_name":"metric_value").

{
    "date":"2019-04-23T20:56:48+0000", "A": "15","B": "1.0"...// and all other metrics
}

Is there any Talend component with which I can take this output or similar?

topic Doubt about changing format of JSON in Talend Studio

Doubt about changing format of JSON