7 Replies Latest reply on Jun 29, 2021 2:39 AM by mani vincent

    how to retrieve json child nodes

    mani vincent Active Member

      How to retrieve only the child elements from

      '{ "a": {    "b": "value",    "c1": 1,    "c2": 2,    "d": null,    "e": {      "f": true,      "g": ["v1", "v2", "v3"]    }} }'

      to

      {    "b": "value",    "c1": 1,    "c2": 2,    "d": null,    "e": {      "f": true,      "g": ["v1", "v2", "v3"]    }}

       

      using informatica process

       

      tried below steps but no luck.

      step 1;

           util:parseJSON('{ "a": {    "b": "value",    "c1": 1,    "c2": 2,    "d": null,    "e": {      "f": true,      "g": ["v1", "v2", "v3"]    }} }')

      step 2:

           util:toJSON($temp.convertedInp)/a[c1=1]