Forum Discussion

KTsnap's avatar
KTsnap
New Contributor III
4 years ago

Combining all records in one single JSON

Hi Team, I have below input [ { "parents": "A", "value": "1" }, { "parents": "B", "value": "2" }, { "parents": "C", "value": "3" }, { "parents": "D", ...
bojanvelevski's avatar
bojanvelevski
Valued Contributor
4 years ago

Hi @KTsnap,

Don’t know what you mean by “JSON” output? If you are referring to the Array value of “controllingFieldValue”, than just remove the square brackets from your expression

  • KTsnap's avatar
    KTsnap
    New Contributor III
    4 years ago

    Hi Bojan,
    IN this way ,

    [
"Value" : {
  {
    "controllingFieldValue": [
      "A"
    ],
    "valueName": "1"
  },
  {
    "controllingFieldValue": [
      "B"
    ],
    "valueName": "2"
  },
  {
    "controllingFieldValue": [
      "C"
    ],
    "valueName": "3"
  },
  {
    "controllingFieldValue": [
      "D"
    ],
    "valueName": "4"
  }
}
]
    • bojanvelevski's avatar
      bojanvelevski
      Valued Contributor
      4 years ago

      This is not a valid JSON. The value of the “Value” object can either be a string,number,boolean, array , or object with key value pairs, but not multiple object literals. You can group all of the documents in one array ($group) , and use the following expression:

      $group.map(x=>{"controllingFieldValue":[x.parents],"valueName":x.value})

      And map the target path as Value, than you’ll have all of the objects but in an array.

      • KTsnap's avatar
        KTsnap
        New Contributor III
        4 years ago

        This helped… Thank you 🙂