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", ...
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 🙂