79338438

Date: 2025-01-08 08:47:12
Score: 1
Natty:
Report link

you can try to use the shift operation to map the nested JSON structure to the desired flat structure while iterating over the SalesArea list. Below is the JOLT spec for your use case: [ { "operation": "shift", "spec": { "CustomerMaster": { "Rootnode": { "KUNNR": "[&1].KUNNR", "NAME1": "[&1].NAME1", "LAND1": "[&1].LAND1", "Indicator": "[&1].Indicator", "TimeStamp": "[&1].TimeStamp", "SalesArea": { "": { "VKORG": "[&2].[&1].VKORG", "VTWEG": "[&2].[&1].VTWEG", "SPART": "[&2].[&1].SPART" } } } } } }, { "operation": "shift", "spec": { "": { "*": "" } } } ]

Reasons:
  • Long answer (-0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: Ryan Mehrotra