jolt

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 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 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…

I have three scenarios: Scenario 1: When Fee1 has a value and Fee2 is "", output attribute FinalFee should have Fee1 value Scenario 2: When Fee1 is "" and Fee2 has a value, output attribute FinalFee should have Fee2 value…

In the attached JOLT, I want to change the date format, type conversion and string operation as follows. Date needs to change into yyyy-mm-dd hh:mm:ss format (2024-06-16 23:54:14) from UTC (2024-06-16T23:54:14.711456Z) The value of WEIGHT code needs to convert into…

Hi I'am trying a jolt transform of below { "Others": { "eventTime": "2024-09-05T01:50:05.861", "groupArticleNumber": "IW6012", "groupModelNumber": "JSO42", "seasonCode": "20242" }, "x": [ { "materialComposition": "100% PET-REC", "mainMaterialFlag": true } ], "y": [ { "sourcingSizeCode3": "550" }, { "sourcingSizeCode3": "540" }…