Advertisements 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… Read More Jolt Transformation: Un-nest object of form "key":{"value":"xyz"} to "key":"value"
Advertisements 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": "",… Read More Perform cardinality-Many in JOLT
Advertisements 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",… Read More How can I add key and values from one object into each object in an array via jolt
Advertisements 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
Advertisements 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
Advertisements 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… Read More Broke nested JSON array with JOLT
Advertisements 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" }… Read More JOLT Keep structure after array shift
Advertisements 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 @… Read More Renaming Special character key with Jolt transform
Advertisements 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
Advertisements 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",… Read More JOLT JSON transform values from one-to-many to one-to-one