Forum Discussion

KTsnap's avatar
KTsnap
New Contributor III
4 years ago

Insert a new dynamic record in JSON under array field

Hi Everybody, Kindly help. Am trying to insert a dynamic value under the **value** array using extend function but unable to do so. [ { "entity": { "attributes": { "type":"CustomField","url":"A" } ...
bojanvelevski's avatar
bojanvelevski
Valued Contributor
4 years ago

Hey @KTsnap ,

Here is the array before the expression:

and here is the array after the expression:

Re-check if you are doing something wrong. If you were referring to the complete payload, than make sure you check Pass Through in the Mapper.

KTsnap's avatar
KTsnap
New Contributor III
4 years ago

the expected Output is as follows:

[
{
"entity":
{
"attributes":
{
"type":"CustomField","url":"A"
}
"Metadata":
{
"valueSet":
{
"value":
[
{
"color":null,"default":false,"description":null,"isActive":null,"label":"None","urls":null,"valueName":"None"
},
{
"color":null,"default":false,"description":null,"isActive":null,"label":"Country","urls":null,"valueName":"Country"
},
{
"color":null,"default":false,"description":null,"isActive":null,"label":"Employee","urls":null,"valueName":"Employee"
},
{
"color":null,"default":false,"description":null,"isActive":null,"label":"Both","urls":null,"valueName":"Both"
},
{
"color":null,"default":false,"description":null,"isActive":null,"label":"Active","urls":null,"valueName":"Active"
}
]
},
},
},
}
]
  • bojanvelevski's avatar
    bojanvelevski
    Valued Contributor
    4 years ago

    As I said in my previous reply, enable Pass through in the Mapper. You’ll get the following result:

      {
    "entity": {
      "attributes": {
        "type": "CustomField",
        "url": "A"
      },
      "Metadata": {
        "valueSet": {
          "value": [
            {
              "color": null,
              "default": false,
              "description": null,
              "isActive": null,
              "label": "None",
              "urls": null,
              "valueName": "None"
            },
            {
              "color": null,
              "default": false,
              "description": null,
              "isActive": null,
              "label": "Country",
              "urls": null,
              "valueName": "Country"
            },
            {
              "color": null,
              "default": false,
              "description": null,
              "isActive": null,
              "label": "Employee",
              "urls": null,
              "valueName": "Employee"
            },
            {
              "color": null,
              "default": false,
              "description": null,
              "isActive": null,
              "label": "Both",
              "urls": null,
              "valueName": "Both"
            },
            {
              "color": null,
              "default": false,
              "description": null,
              "isActive": null,
              "label": "Active",
              "urls": null,
              "valueName": "Active"
            }
          ]
        }
      }
    }
  }
]
    • KTsnap's avatar
      KTsnap
      New Contributor III
      4 years ago

      Thanks Boston , its working Now.