question Re: Jolt Transform help on json to add another array layer in Support Questions

Jolt Transform help on json to add another array layer

learnNifi — Tue, 08 Mar 2022 22:41:55 GMT

I am a newbie to Nifi Jolt transform. I've been looking through the document, but still cannot figure out how to do a simple Jolt Transform.

Input:

{"id": 123456,

"manager_id": 98765}

desired output:

{"reportTo": [{"userId": 98765}]}

I've got the part to change the manager_id to userId by the following Spec. But I was stuck how to make it another layer. Any insights/help to solve this?

[{
"operation": "shift",
"spec": {
"manager_id": "userId"}
}
}]

Re: Jolt Transform help on json to add another array layer

araujo — Tue, 08 Mar 2022 23:26:50 GMT

@learnNifi ,

Try this one out:

[ { "operation": "shift", "spec": { "id": "&", "manager_id": "report_to[0].id" } } ]

Cheers,

André

Was your question answered? Please take some time to click on "Accept as Solution" below this post.

If you find a reply useful, say thanks by clicking on the thumbs up button.

Re: Jolt Transform help on json to add another array layer

learnNifi — Wed, 09 Mar 2022 13:46:52 GMT

This works perfectly! Thank you