I have complex (EDI) input that looks like this: { "INS-2000_loop": [ { "INS_05": "A", "INS_06": "D", "INS_08": "AC" }, { "REF_01": "0F", "REF_02": "111111111" }, { "NM1-2100A_loop": [ { "NM1_01": "IL", "NM1_02": "1", "NM1_03": "aaa", "NM1_04": "bbb" }, {…
I have the following example of JSON and there many other fields apart from these 3 [ { "field1": "xyz", "field2": "mno", "res1": "pqrs" }, { "field1": "xyz1", "field2": "mno1", "res1": "pqrs1" }..other entries ] I would like to empty…
I have a nested JSON object like this: { "field1": "value1", "field2": "value2", "field3": { "data": [ { "subField1": "subValue1", "subField2": "subValue2", "subField3": { "nestedField1": "nestedValue1", "nestedField2": "nestedValue2" }, "subField4": { "nestedField1": { "subNestedField1": "subNestedValue1", "subNestedField2": "subNestedValue2" }, "nestedField2": {…
I have input that looks like this: { "INS-2000_loop": [ { "HD-2300_loop": [ { "COB-2320_loop": [ { "COB_01": "11", "COB_02": "12", "COB_03": "13" }, { "COB_01": "21", "COB_03": "23" }, { "COB_01": "31", "COB_02": "32" }, { "COB_02": "42", "COB_03":…
I have the following JSON including a properties array and I would like to transform it with jolt JSON INPUT { "kind": "product", "product": { "id": "product.P-L-0368", "productNumber": "P-L-0368", "name": "myProduct" }, "properties": [ { "values": [ { "value": "222"…
I have valious formats of incoming JSON from 3rd parties that I need to process in unified manner. Considering the data structure is not normalized, I could not apply unified logic of data processing. To achieve that I'm seeking for…
I have the following input JSON value : { "A": { "B": [ { "tempName": "rq3ewas", "name": "test1" }, { "tempName": "", "name": "test2" }, { "tempName": null, "name": "test3" }, { "tempName": "test4" } ] } } and want…
I have an array of 5 elements out of which I want to compare index position 1 and 2 and keep 1 or 2 based on weather it is an integer. Retain other elements as it is. Scenario below: if…
I have input with more than 1000 keys in input and there are few objects in my input as well with key value pairs. I need to transform all the key values to string inside each object as well as…
I am trying to adapt the following JSON with jolt [ { "id": "abc", "colour": "black | orange | anthracite", "material": "polyester | aluminium | v2a | steel", "temp min": "45 °C", "temp max": "-35 °C", "category": "rope", "length": "18…