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":…
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"…
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…
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…
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"…
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.…
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" },…
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…
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":…
I need a JOLT spec to do the below transformation in an Apache NiFi JOLT processor. So there are arrays that are all the same length (in this case 3), and so I want to expand it into 3 records…