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": […
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…