The possible values for applicableOn field are already known but they are not limited to clothes and bags like given in this sample input. Also, there can be multiple elements in purchases array with the same applicableOn type and the…
I am given the below json and it needs to be concatenated based on condition if it not null { "id": "4583", "price": "149.99", "sale_price": "" } Can someone help me out here? expected output { "id": "4583", "price": "149.99…
please provide the jolt spec for the following JSON input : [ { "name": "Manu", "age": 26, "location": "New York", "risk": "0" }, { "name": "Manju", "age": 29, "location": "New York city", "risk": null } ] if risk is 0,…
I have a JSON from source and I am trying to write a JOLT to flatten this data and convert it in to records so that I can insert it in to a Table. I have already written a JOLT…
I have following json input and I need to get 2 additional attributes (head,foot) into the output json using existing Jolt. How I can do that? JSONs and JOLT scripts are attached. Input JSON: [ { "PropertyName": "KER ZONE 1",…
For the details mentioned below, I would like to move the email.values* to payload.*.content.values (preserving the changes) I have created below Jolt - [ { "operation": "shift", "spec": { // set values of the object keys to their accountIds //…
There are multiple items in the array in which I am trying to remove the item whose idTypDesc is id if there is another item in array with idTypDesc as Ultimate ID. if the array doesn't have item with idTypDesc…
I have this JSON input: { "input": { "a": "valueA", "b": "valueB", "c": "valueC" }, "fieldsToFilterBy": [ "a", "c" ] } and i want to have this output: { "input": { "a": "valueA", "b": "valueB", "c": "valueC" }, "filteredValues": […
I have the following inputted Json: { "extraFields": { "language": "french", "status": { "comment": "hey" } } } Using Jolt, I want to achieve the following output: { "extraFields": "{"language": "french", "status": {"comment": "hey"}}" } Note the backslashes. I managed…
I have a JSON formatted payload with nested arrays that I want to modify into a simpler array. Input looks like this: [ { "pim_network": [ { "addresses": [ { "ifindex": 1, "ifname": "lo", "address": "00:00:00:00:00:00", "broadcast": "00:00:00:00:00:00", "addr_info": […