Modify json array object with jolt
I've been writing a jolt for json transformation and I'm halfway through there. Need to modify json object in array if it is present in array and need to create new if it is not present at all. The object…
Transform JSON with array objects into individual records – JOLT spec
I am working on Jolt transform feature in Apache Nifi. I am new to this and need help. The input JSON can have several objects which contain multiple numerical arrays, that need to be flattened. JSON Input: [ { "ABC":…
How to get rid of $ attribute using JoltTransformJSON in Azure Nifi
My example schema from the Mongodb database looks something like this { "_id" : { "$oid" : "5bd761deae323e45a93cddae" } } From here, I would like to simplify this JSON format using JoltTransformJSON processor in Azure Nifi { "_id" : "5bd761deae323e45a93cddae"…
Flatten a Complex JSON when there are 2 nested arrrays
I am facing a problem, transforming a very complex nested JSON using jolt transformation. Input and output detail is given below. I was trying to create a jolt spec but not getting it. Could anyone please help me. Details as…
Json – JOLT transformation moves fields into each element of arrays
I want to move "id" field to each of element in "user_roles" field of the document below. I used the spec below but it didn't work as my expected, I'm not sure where I may have made an error in…
How to extract json from json array [] of nifi objects?
I have next array: [ { "id" : 1, "key_word" : "бережливое производствоnканбанnсокращение потерь" }, { "id" : 2, "key_word" : "" }, { "id" : 3, "key_word" : "healthynlearnersnlecturesnphysical educationnphysical fitnessnздоровьеnлекцииnобучающиесяnфизическая культураnфизическая подготовленность" }, { "id" : 4, "key_word"…
Json – Jolt – inserting new a field in array list
I'm having issues with Jolt transformation, I need to extract values/fields from array list and add one custom field either from array I'm targeting to extract or outer list. But let me try to explain more in detailed through code.…
JOLT transform to filter JSON array based on object property
In my Nifi dataflow, I'm attempting to filter and transform JSON using the JOLT processor, so I'm very new to this. My input JSON is [ { "id": "1cca9371-b0f2-4c4d-9028-cd534edfecc9", "code": "X00615", "url": "https://acme.com.az/043f00e8-7db8-4cab-bc1d-5a39b0a89882" }, { "id": "4dcacd3d-dbc8-424d-8f13-46706322a4d3", "code": "X01337" },…
Apache Nifi processor to update JSON data before returning into HandleHttpResponse
My Apache processor setup is HandleHttpRequest -> InvokeHTTP ->HandleHttpResponse. I'm hitting an API from Postman which invokes another API and gets the JSON data and returns. Now in between InvokeHTTP -> HandleHttpResponse, I'm trying to add another processor which modifies…
How to merge two JSON arrays into a single merged array using Jolt in NiFi
I have a requirement in which I need to merge two JSON arrays into one. Currently the JSON is like this: [ { "test": [ { "count": 5, "name": "highway" } ] }, { "test": [ { "count": 6, "name":…