Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Jolt Transform help on json to add another array layer

avatar
New Contributor

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"}
}
}]

1 ACCEPTED SOLUTION

avatar
Super Guru

@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.
--
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.

View solution in original post

2 REPLIES 2

avatar
Super Guru

@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.
--
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.

avatar
New Contributor

This works perfectly!  Thank you