- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Jolt Transform help on json to add another array layer
- Labels:
-
Apache NiFi
Created 03-08-2022 02:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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"}
}
}]
Created 03-08-2022 03:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created 03-08-2022 03:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created 03-09-2022 05:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This works perfectly! Thank you
