I have to make a JOLT filter to delete a field based on condition, also the filter has to work with two different JSON structures. So, here is the case. I have these JSONs: JSON 1: { "header": { "key":…
For each array object, get the id and assign it as a key to the array object. I am trying to use the JOLT processor in NIFI. Any help would be much appreciated! Input: { "list": [ { "catalog": {…
JSON to JSON transformation - Need to define a JOLT specification which will remove empty string, space element from a group array element. Below example has two sets of array group records with " " empty string and a space.…
I'm looking for flattening nested JSON file into SQL ready format. JSON file's content: { "ProductLine": [ "Product 1", "Product 2" ], "Purchase": 364, "Cancel": [ 140, 2 ] } My current transformation: [ { "operation": "shift", "spec": { "*":…
I'm looking for breaking nested JSON file and trying to flatten them to fit into a SQL database. Current JSON: { "content": { "failedPerProductLineAndReason": { "Product1": { "Downsizing licenses is not allowed": 1 } } } } Expected outcome: {…
I am new to JOLT and I don't know much about it, and I need the JOLT spec to convert my below JSON to CSV file: { "bigRecords": [ { "Records": { "Name": "R1", "Id": "1P02XV425KCASEZGQLB8LPQMF4ZXCUBCTA01", "Type": "New", "Area": "Eng",…
I need to merge array data from two different arrays from the Input JSON and make a flat list of items in the Output JSON. The first array contains the key required for the output and the second array contains…
I am new to JOLT transformation, can someone help me in transforming the Input JSON to the desired output? Input JSON: [ { "product_id": 1, "product_description": "Product 1 details", "billing_details": { "product_id": 1, "billing_description": "Product 1 billing Details" }, "product_part_desc":…
I want to write a JOLT definition that loops through each object in my data array, and move the object to the "found" array if the key "parent_id" is present, but otherwise, if the "parent_id" key is not present, move…
I have a service that receives a JSON and needs to transform it to a different structure before sending to a third party API. Our team is using JOLT for transformations in the application. I have detailed the current scenario…