I need to unwrap JSON objects in order to reduce the nesting of input like [ { "key1": { "value": "abc" }, "key2": { "value": "xyz" } }, { "key1": { "value": "123" }, "key2": { "value": "456" } } ] Instead it can just map straight to the value without the unnecessary object nesting.… Read More Jolt Transformation: Un-nest object of form "key":{"value":"xyz"} to "key":"value"

I want to write a Jolt definition using cardinality-Many that can transform object "PO_POD_LN_EVW1" into list and ignore if its already a list. Input JSON : { "PURCHASE_ORDER_DISPATCH": { "MsgData": { "Transaction": { "PSCAMA": { "PUBLISH_RULE_ID": { "IsChanged": "Y" } }, "PO_POD_HDR_EVW1": { "STATE_BILL": "", "CURRENCY_CD": { "IsChanged": "Y", "content": "USD" }, "ADDRESS4_VNDR": "", "PO_POD_LN_EVW1":… Read More Perform cardinality-Many in JOLT

I’m using jolt and I have an input object where I would like to take the keys out of one property and insert them into each object of an array in another property: My input: { "jolt_marketplaceMetadata": { "NAN_KEY": 1, "TEMP": 3 }, "jolt_attributes": [ { "name": "HELLO", "yyup": 3 }, { "huh": "please", "work":… Read More How can I add key and values from one object into each object in an array via jolt

I want to know how to use shift and modify-overwrite-beta for the below input. Please explain how it works with your answer. my input [ { "data": { "firstName": "Leanne", "lastName": "Graham", "id": 111 } }, { "data": { "firstName": "Ervin", "lastName": "Howell", "id": 222 } } ] I want this output { "111": {… Read More How to use shift and modify-overwrite-beta in jolt

I am trying to transform a JSON into another JSON using JOLT. My source JSON has the following format (the number of levels of child modules is not known): { "modules": [ { "id": "1", "modules": [ { "id": "1.1", "modules": [] }, { "id": "1.2", "modules": [ { "id": "1.2.1", "modules": [] } ]… Read More Recursively transform JSON using jolt

I’m looking for breaking nested JSON file and try to flat it to fit into a SQL database. Current JSON: { "content": { "failedPerProductLineAndReason": { "Product1": { "Downsizing licenses is not allowed": 1 } } } } Expected outcome: { "ErrorType": "failedPerProductLineAndReason", "product": "Product1", "error": "Downsizing licenses is not allowed", "quantity": 1 } Flat nested… Read More Broke nested JSON array with JOLT

I’m trying to construct a JOLT transformation such that it will change a parameter value if the paramter name matches in a given array. Example Input: { "component": { "parameters": [ { "parameter": { "name": "var_name", "value": "val" } }, { "parameter": { "name": "1", "value": "2" } } ] }, "additional": "onemore" } Desired… Read More JOLT Keep structure after array shift

Please help me write the jolt spec to rename the key with a special character "@". When I place "@" in jolt spec, it is not working. I am getting the below error Error running the Transform. JOLT Chainr encountered an exception constructing Transform className:com.bazaarvoice.jolt.Shiftr at index:0. Invalid key:Company@1 can not have an @ other… Read More Renaming Special character key with Jolt transform

I am trying to default an email id called "test@test.com" to a field "userEmailId" in JOLT but it is not working. Any idea on what wrong I am doing and what changes I need to do in my JOLT spec to get the email id? Right now in the spec I have removed the "@"… Read More At the rate symbol not working for email id in JOLT

I’m trying to map one key to each value in array to a new array by using JOLT. Could someone please help give me a solution for this: My JSON: [ { "person_id": "1", "resources": ["asd", "zxc"] }, { "person_id": "2", "resources": ["ghj", "asd"] } ] And my expected JSON: [ { "person_id": "1", "resource":… Read More JOLT JSON transform values from one-to-many to one-to-one