I have data coming into NiFi in JSON format. Below is the sample { "company_name": "mycompany", "companytyp": "producer", "Welcomemes": "welcome_message1", "logo": "//somepath/to/logo URL " } I have been trying to apply a JOLT transformation for the following condition: If the…
I am facing a problem, transforming a very complex nested JSON using jolt transformation. Input and output detail is given below. Input [ { "metadata": { "event_time": "2023-09-04T08:46:15.0842Z" }, "payload": [ { "plant": "0DE1", "store": "", "t_objectandcharvalcomb": [ { "productalloccharacteristic01":…
I am facing a problem, transforming a JSON . Requirement is to concatenate only if my two columns are not Null, default value if any of one column is NULL Input 1 : [ { "division_Code": "F", "department_Code": "L3D4", "department":…
I am trying to generate the JSON output based on JSON input using JOLT. Output should contain flatten array of objects for storing in db. Each object should contain following fields: rateplan = subscriptions.subscription[].products[specification=rateplan].code code = subscriptions.subscription[].options[].products[].code mandatory = subscriptions.subscription[].options[].mandatory…
I have simple JSON and I want to reorganize the keys with JOLT transformation: Input JSON looks like this: [ { "Firstname": "John", "LastName": "JohnLastName", "City": "TestCity", "PostCode": "25466", "Street": "85.", "HousNumber": "5", "Phone": "0054565685", "Email": "-" } ] and…
I'm trying to convert an array of strings into objects. Which is not workings as I expected. Can someone help me with this? I got struck by splitting the array of items into individual objects. Some of the items are…
I'm new to Jolt transformations. I will try to describe my case in detail. I suspect that you will need to combine shift and modify-default operations HERE: TRANSFORMATION RULE: if field detail have value (exist and is not"" or null)then…
I am using JOLT to transform a JSON array to JSON array but flattening the inner string array list. Below is the input, expected output and JOLT used for generating the data. [ { "name": "St", "Subjects": [ "A1" ,…
I have an input like this - [ { "time": "2014-10-31T01:59:59.000+10:00", "value": { "nil": null }, "metadata": { "TVPMeasurementMetadata": { "qualifier": { "title": null, "href": null } } }, "longitude": "115.1248985", "latitude": "-33.963617", "gathered_time": "1685662804091" }, { "time": "2014-11-30T02:00:00.000+10:00", "value":…
I need to transform below Input JSON where the ID has multiple ORG_LVL_2 codes and it should fall under the same OrgUnits array, whereas in my spec a separate object is getting created. [ { "id": "0000606800", "ORG_LVL_2": "Co0053" },…