How to transform JSON array?

Question

I need to transform this json array:

[
    {
        "timestamp": "2025-01-19T17:00:00Z",
        "absoluteDeviationsX": [10, 11, 12 ]
    },
    {
        "timestamp": "2025-01-20T17:00:00Z",
        "absoluteDeviationsX": [20, 21, 22 ]
        ]
    }
]

to:

[
    {
    "timestamp": "2025-01-19T17:00:00Z",
    "absoluteDeviationsX0": 10,
    "absoluteDeviationsX1": 11,
    "absoluteDeviationsX2": 12,
    },
    {
    "timestamp": "2025-01-20T17:00:00Z",
    "absoluteDeviationsX0": 20,
    "absoluteDeviationsX1": 21,
    "absoluteDeviationsX2": 22,
    }
]

with JSONata.

I need this to process data in Infinity plugin in Grafana.

Vlad Dimov · Accepted Answer · 2025-01-22 11:05:07Z

1

$map($, function($v) {
  $merge([
    { 'timestamp': $v.timestamp },
    $map($v.absoluteDeviationsX, function ($v, $i) {
      { 'absoluteDeviationsX' & $i: $v }
    })
  ])
})

Playground link: https://jsonatastudio.com/playground/71584a20

Explanation: the first $map function iterates over all items of the root input and produces a duplicate array. The second $map iterates over the deviations array, transforms each item into an object and appends the item index to each key name. Eventually, all of transformed objects are merged with $merge and passed back to the first $map function as a final output.

answered Jan 22 at 11:05

Vlad Dimov

2062 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andrew Coleman · Accepted Answer · 2025-01-22 08:44:43Z

0

$.$merge([
    { "timestamp": timestamp },
    absoluteDeviationsX#$i{
        "absoluteDeviationsX" & $i: $
    }
])

See https://try.jsonata.org/EtmrHNM7U

answered Jan 22 at 8:44

Andrew Coleman

1,61711 silver badges9 bronze badges

2 Comments

DarkBee Jan 22 at 8:50

Please explain how this solves the issue. Code-only answers are not good answers.

Vlad Dimov Jan 22 at 11:05

That is a very neat solution!

Collectives™ on Stack Overflow

How to transform JSON array?

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related