Support Questions

Find answers, ask questions, and share your expertise

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