Below is the JSON I have [ { "item_attr1": "abc", "item_attr2": "123", "item_attr3": "123", "item_id": "12345", "bucket_attr1": 1919, "bucket_attr2": "abc", "bucket_attr3": 1922, "bucket_attr4": "abc", "bucket_id_1": "abc", "bucket_id_2": "def", "bucket_id_3": "ghi", "articleattribute1": "abc", "articleattribute2": "abc", "articleattribute3": "2233", "article_id": "123458" }, {…
Trying to find the middle initial Jolt configuration. Ask is, i need to consider only first character in Middle name return from Json. Also first character should be Alphabet (either caps or small case), else i need to return null.…
I am trying to find the solution for transforming the below JSON data. Mainly I want the date which is having '/' to be replaced with '-'. The replace logic which I tried below is not working. Can someone help…
This is a continuation of question asked in Grouping Json with same value of a key with Jolt I want to do following changes in output JSON with JOLT. Could you please help on getting the desired JSON output. Thank…
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 ]…