Turn array of objects into list of objects in Jsonata

Question

I need to write a Jsonata query to turn array of objects into list of key/value objects where the key is the index of the object. For example I need to turn the following JSON structure

{
  "Account": {
    "Account Name": "Firefly",
    "Order": [
      {
        "OrderID": "order103",
        "Product": [
          {
            "Product Name": "Bowler Hat",
            "ProductID": 858383,
            "SKU": "0406654608",
            "Description": {
              "Colour": "Purple",
              "Width": 300,
              "Height": 200,
              "Depth": 210,
              "Weight": 0.75
            },
            "Price": 34.45,
            "Quantity": 2
          },
          {
            "Product Name": "Trilby hat",
            "ProductID": 858236,
            "SKU": "0406634348",
            "Description": {
              "Colour": "Orange",
              "Width": 300,
              "Height": 200,
              "Depth": 210,
              "Weight": 0.6
            },
            "Price": 21.67,
            "Quantity": 1
          }
        ]
      }
    ]
  }
}

Into the following json structure.

{
  "result": {
    "0": {
      "Product Name": "Bowler Hat",
      "ProductID": 858383,
      "SKU": "0406654608",
      "Description": {
        "Colour": "Purple",
        "Width": 300,
        "Height": 200,
        "Depth": 210,
        "Weight": 0.75
      },
      "Price": 34.45,
      "Quantity": 2
    },
   "1": {
      "Product Name": "Trilby hat",
      "ProductID": 858236,
      "SKU": "0406634348",
      "Description": {
        "Colour": "Orange",
        "Width": 300,
        "Height": 200,
        "Depth": 210,
        "Weight": 0.6
      },
      "Price": 21.67,
      "Quantity": 1
    }
  }
}

I appreciate any help to find the right Jsonata query or queries that could achieve this transformation.

Maciej · Accepted Answer · 2022-06-27 07:57:02Z

1

One solution that I found is to use positional variable binding (#).

{
  "result": Account.Order.Product#$i{
    $string($i): $
  }
}

The full solution on JSONata Playground: https://stedi.link/4Pj8Rvd

edited Jun 27, 2022 at 7:57

answered Jun 27, 2022 at 7:05

Maciej

531 silver badge8 bronze badges

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

Collectives™ on Stack Overflow

Turn array of objects into list of objects in Jsonata

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related