JOLT SPEC: Shift into existing array

Question

Currently I have the following INPUT JSON. The "temp"-Object has been added with the help of a default spec.

{
  "items": [
    {
      "description": "myDescription",
      "attributes": [
        {
          "identifier": "colour",
          "type": "attribute",
          "values": [
            "DE"
          ],
          "hint": "1"
        },
        {
          "identifier": "pin",
          "type": "attribute",
          "values": [
            "4711"
          ],
          "hint": "1"
        },
        {
          "identifier": "price",
          "type": "price",
          "values": [
            "77.27"
          ],
          "hint": "1"
        },
        {
          "identifier": "weight",
          "type": "attribute",
          "values": [
            "0.47"
          ],
          "hint": "1"
        },
        {
          "identifier": "status",
          "type": "attribute",
          "values": [
            "active"
          ],
          "hint": "1"
        }
      ]
    }
  ],
  "temp": {
    "hint": "1",
    "identifier": "additionalDescription",
    "values": [
      {
        "lang": "de",
        "value": "temp"
      },
      {
        "lang": "en",
        "value": "temp"
      },
      {
        "lang": "fr",
        "value": "temp"
      },
      {
        "lang": "it",
        "value": "temp"
      },
      {
        "lang": "es",
        "value": "temp"
      }
    ],
    "type": "attribute"
  }
}

Desired Output:

{
  "items": [
    {
      "description": "myDescription",
      "attributes": [
        {
          "identifier": "colour",
          "type": "attribute",
          "values": [
            "DE"
          ],
          "hint": "1"
        },
        {
          "identifier": "pin",
          "type": "attribute",
          "values": [
            "4711"
          ],
          "hint": "1"
        },
        {
          "identifier": "price",
          "type": "price",
          "values": [
            "77.27"
          ],
          "hint": "1"
        },
        {
          "identifier": "weight",
          "type": "attribute",
          "values": [
            "0.47"
          ],
          "hint": "1"
        },
        {
          "identifier": "status",
          "type": "attribute",
          "values": [
            "active"
          ],
          "hint": "1"
        },
        {
          "hint": "1",
          "identifier": "additionalDescription",
          "values": [
            {
              "lang": "de",
              "value": "myDescription"
            },
            {
              "lang": "en",
              "value": "myDescription"
            },
            {
              "lang": "fr",
              "value": "myDescription"
            },
            {
              "lang": "it",
              "value": "myDescription"
            },
            {
              "lang": "es",
              "value": "myDescription"
            }
          ],
          "type": "attribute"
        }
      ]
    }
  ]
}

The spec that I am looking for should fullfill two requirements:

integrate the "new" object within the attributes array.
replace the value "temp" by the value of the description field, which can be found at the top of the json.

Unfortunately I already struggle with getting the arrays correctly into the output JSON, not to mention the Overwriting of the value "temp"


[
  {
    "operation": "shift",
    "spec": {
      "items": {
        "*": {
          "description": "&2.myDescription",
          "attributes": {
            "@(3,temp)": "&3.&2.&",
            "*": "&3.&2.&"
          }
        }
      }
    }
  }
]

Any help are highly appreciated. Also, I would be happy to receive hints regarding the first requirement as well. I always struggle when building the RHS (right-hand side) whenever arrays are involved.

Hi, I noticed the "items" is an array of one element but can it be multiple elements with different description\attributes? If that is the case how do you associate items elements with the temp object\s? — samsal77
– samsal77, Commented May 4, 2024 at 13:20
Hello Samer, thanks for your Message. Fortunately there is only one description per item. In the meantime I found out, that regarding the integration of the new - object within the attributes array a simple { "operation": "shift", "spec": { "items": "&", "temp": "items[#2].attributes" } } does the trick. I combine this with the solution of Barbaros and the JSON has its desired output. — Katja Bürger
– Katja Bürger, Commented May 4, 2024 at 14:33

Barbaros Özhan · Accepted Answer · 2024-05-04 13:47:50Z

0

What you need is to bring the desired attributes value after 4 levels traversing the tree starting from the the value attribute's level within a modify transformation spec along with overwrite option such as

[
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "temp": {
        "values": {
          "*": {
            "value": "@(4,items[0].description)"
          }
        }
      }
    }
  }
]

answered May 4, 2024 at 13:47

Barbaros Özhan

65.9k11 gold badges36 silver badges64 bronze badges

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

1 Comment

Katja Bürger Over a year ago

Thank you Barbaros for this helpful solution. I just add a simple { "operation": "shift", "spec": { "items": "&", "temp": "items[#2].attributes" } } and the JSON has its desired output. Thank you so much.

Collectives™ on Stack Overflow

JOLT SPEC: Shift into existing array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related