I have a JSON formatted payload with nested objects that I want to modify into an array so Nifi can process the array elements pushing them into SQL. Input looks like this: [ { "architecture": "x64", "hostname": "LAPTOP-B442R49A", "memory": "32",…
I have an array of JSON Objects that I need to transform into a new array of JSON Objects that align with my schema. I am new to Jolt and my output is not what I need. I tried multiple…
Given dynamic accountId return the onlineId and signinId for that specific user. Input JSON: [ { "request": { "body": { "inputAccountId": "1234" } } }, { "accountId": "1234", "ageGroup": 3, "role": 1, "gender": "f", "signinId": "[email protected]", "onlineId": "one" }, {…
Does anyone how to write a JOLT Transform with this situation: Input : [ { "id": "65cf06b62fadc0122dc30f29", "code": "H34.23.9-240216-0003", "applicant": { "eformId": "60d990f88e6893001e5a7b42", "userId": "6186433deee4513fe0d86efc", "data": { "birthday": "", "address": "Thôn Kon Năng Treang", "gender": 2, "nation": { "label": "Việt…
Is it possible to do more than one condition on a JOLT transformation to create or's or and's? I found some documentation on If Else but haven't been able to apply it to what I'm trying for. This is an…
So I have geo Coordinates and I want to create polygon string that i can insert into Postgres as geometry type. I am using apache Nifi. Input: [ [ 13, 52 ], [ 13, 55 ], [ 14, 15 ]…
I'm currently trying to perform an operation in jolt that I believe would be easiest if I could group my data by a value first. I am trying to group this list by the value columnIndex Input: { "temp_sfp": […
I have an attribute "TEST" storing a JSON object, I tried this JOLT but I'm getting "Unable to marshal json to an object" error TEST: [ { "ORDER_DATE": "2022-04-11", "TIME_STAMP": "1667543037000" }, { "ORDER_DATE": "2022-05-05", "TIME_STAMP": "1651741666000" } ] 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…
I have input JSON as { "eventTime" : "2024-01-17T15:10:06.858", "groupArticleNumber" : "FT6559", "groupModelNumber" : "FRX88", "productDescriptionEN" : "ESTRO 19 JSYY", "subBrand" : "1", "brand" : "11", "businessSegment" : "104", "salesLine" : "L84", "materialComposition" : [ "100% PET-REC", "100% PET-DAT" ],…