'Grouping of array items by locale - JSON transformation in Node JS using JSONata

I am stuck in transformation of JSON in JSONata. Any help on this is appreciated.

Is there any library which makes this possible in Node JS apart from JSONata.

Moreover direct transformation of the data is possible or needs manipulation in JS?

my input json looks like

  "species": "mammels",
  "title": [
    {
      "locale": "en-GB",
      "value": "GB Title"
    },
    {
      "locale": "en-US",
      "value": "US Title"
    },
    {
      "locale": "en-RS",
      "value": "RS Title"
    }
  ],
  "shortDescription": [
    {
      "locale": "en-GB",
      "value": "GB shortDesc"
    },
    {
      "locale": "en-US",
      "value": "US shortDesc"
    }
  ],
  "longDescription": [
    {
      "locale": "en-GB",
      "value": "GB longDesc"
    }
  ],
  "zoos": [
        {
            "location": "Englang",
            "value": "National Zoo"
        },
        {
            "location": "Ireland",
            "value": "Nature home"
        }
    ],
  }

I need transformed output as follows.

   "dataSet":[
      {
         "data":[
            {
               "key":"Territory",
               "value":"SG"
            },
            {
               "key":"studios",
               "value":"National Zoo,Nature home"
            }
         ],
         "locale":"none"
      },
      {
         "data":[
            {
               "key":"Title",
               "value":"GB Title"
            },
            {
               "key":"shortDescription",
               "value":"GB shortDesc"
            },
            {
               "key":"longDescription",
               "value":"GB longDesc"
            }
         ],
         "locale":"en-GB"
      },
      {
         "data":[
            {
               "key":"Title",
               "value":"US Title"
            },
            {
               "key":"shortDescription",
               "value":"US shortDesc"
            }
         ],
         "locale":"en-US"
      },
      {
         "data":[
            {
               "key":"Title",
               "value":"RS Title"
            }
         ],
         "locale":"en-RS"
      }
   ]
   }

Solution 1:^[1]

    {
    "dataSet":[{
    "territory": {"territory":species} ~> $each(function($v, $k) {
    {
        "locale": "none",
        "data": [{
        "key":$k,
        "value":$v}
        ]
    }
  }),    
    "title": $spread(title {
        locale: [ $ ~> | $ | {"key":"Title"}, "locale" | ]
    }).{
        "locale": $replace($keys()[0],"-","_"),
        "data": *
    },
    "shortDescription": $spread(shortDescription {
        locale: [ $ ~> | $ | {"key":"Synopsis"}, "locale" | ]
    }).{
        "locale": $replace($keys()[0],"-","_"),
        "data": *
    },"longDescription": $spread(longDescription {
        locale: [ $ ~> | $ | {"key":"Description"}, "locale" | ]
    }).{
        "locale": $replace($keys()[0],"-","_"),
        "data": *
    },
    "studios": $spread(zoos {
        locale: [ $ ~> | $ | {"key":"studios"}, "locale" | ]
    }).{
        "locale": $replace($keys()[0],"-","_"),
        "data": *
    }
}.[title,shortDescription,longDescription,studios,territory]{locale:data} ~> $each(function($v, $k) {
    {
      "data": [$v],
      "locale": $k
    }
  })]
    }

Try it out here. https://try.jsonata.org/-ZRuUcUwM

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Divya J

'Grouping of array items by locale - JSON transformation in Node JS using JSONata

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]