Jolt Transform JSON Spec map with dynamic values

Question

I need to transform below Input JSON to output JSON and not sure about how to write spec for that output. compare filed values in JOLT transformation

Here is the input:

{
  "body": {
    "productConfigurations": [
      {
        "productConfiguration": {
          "selected": true,
          "productSpecification": {
            "id": "1776911"
          },
          "productOffering": {
            "id": "1777341"
          }
        }
      },
      {
        "productConfiguration": {
          "selected": true,
          "productSpecification": {
            "id": "247541"
          },
          "productOffering": {
            "id": "735501"
          }
        }
      },
      {
        "productConfiguration": {
          "productSpecification": {
            "id": "280801"
          },
          "productOffering": {
            "id": "735501"
          }
        }
      }
    ]
  }
}

expected output: I need to transform below Input JSON to output JSON and not sure about how to write spec for that output. compare filed values in JOLT transformation.

{
  "body": [
    {
      "id": "1777341",
      "products": [
        {
          "id": "1776911"
        }
      ]
    },
    {
      "id": "735501",
      "products": [
        {
          "id": "247541"
        },
        {
          "id": "280801"
        }
      ]
    }
  ]
}

Barbaros Özhan · Accepted Answer · 2021-11-09 10:15:33Z

2

You can use the following successive shift transformations

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "*": {
          "*": {
            "*": {
              "productSpecification": {
                "id": "@(2,productOffering.&).products[].&"
              }
            }
          }
        }
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "*": {
        "$": "&1.id",
        "*": "&1.&"
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "*": "body[]"
    }
  }
]

where the main idea is to determine the common id values of the productOffering attributes through use of "id": "@(2,productOffering.&).products[].&" nested within "productSpecification" tagged object.

edited Nov 9, 2021 at 10:15

answered Oct 27, 2021 at 8:48

Barbaros Özhan

65.9k11 gold badges36 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sandy Over a year ago

This is failing when we have only one productConfiguration.

Barbaros Özhan Over a year ago

Yes, you're right @Sandy . The redundant step(the former third one) is removed. Btw, have you ever checked out the answer provided for your second question?

Collectives™ on Stack Overflow

Jolt Transform JSON Spec map with dynamic values

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related