3 Replies Latest reply on Apr 7, 2021 8:32 AM by User6392 N

    How to remove {} in with empty arrays

    User6392 N Seasoned Veteran
    User6392 N Apr 7, 2021 8:32 AM

      Hi All,

      I have an output from my ICRT process like below:

      {

          "Response": {

              "ABC": [

                  {

                      "x1": " XX",

                      "x2": "43TRG",

                      "x3": "0",

                      "x4": " RGFD",

                      "ABC12": [

                          {

                              "Y1": "W4645U6Y",

                              "Y2": "3",

                              "Y3": "0"

                          }

                      ],

                      "ABC34": [

                          {}

                      ]

                  }

              ]

          }

      }

       

      The requirement is if an array is empty, then the array should return only [] and not [{}].

      In the above example, ABC34 is an empty array but in output it has [{}] . But it should have only this [].

      So Expected Output should be:

      {

          "Response": {

              "ABC": [

                  {

                      "x1": " XX",

                      "x2": "43TRG",

                      "x3": "0",

                      "x4": " RGFD",

                      "ABC12": [

                          {

                              "Y1": "W4645U6Y",

                              "Y2": "3",

                              "Y3": "0"

                          }

                      ],

                      "ABC34": [ ]

                  }

              ]

          }

      }

       

      NOTE: I am using a process object to return my output

      • 96 Views
      • Categories: I Have a Question
      • Tags:
        • 1. Re: How to remove {} in with empty arrays
          Rich Bateman Seasoned Veteran
          Rich Bateman Mar 5, 2021 6:12 AM (in response to User6392 N)

          Hello-

          Have you tried this expression on your output?

           

          util:parseXML(util:toXML(your_field))

           

          When I run that on your sample payload this is the response:

          {
  "Output": [
    {
      "Response": {
        "ABC": [
          {
            "ABC12": [
              {
                "Y1": "W4645U6Y",
                "Y2": "3",
                "Y3": "0"
              }
            ],
            "ABC34": [
              null
            ],
            "x1": " XX",
            "x2": "43TRG",
            "x3": "0",
            "x4": " RGFD"
          }
        ]
      }
    }
  ]
}
          • 2. Re: How to remove {} in with empty arrays
            User6392 N Seasoned Veteran
            User6392 N Mar 7, 2021 7:57 PM (in response to Rich Bateman)

            Hi Rich,

             

            Thanks for your response. I did try the solution suggested by you. But i am getting this error :

             

             

            Could you please show the assignment of output you are doing in process?

             

             

             

            Thanks

            • 3. Re: How to remove {} in with empty arrays
              Prakash Jain Guru
              Prakash Jain Mar 16, 2021 6:04 AM (in response to User6392 N)

              Hi,

               

              You may also try to use replace function to {} with nothing like replace($variable, '{}','')

               

               

              Thanks,

              Prakash Jain