JSON response in array format

[Uday Reddy]

Hi Team,

Can you please help me on below requirement.

we have requirement to format the JSON response into array structure ( highlighted structure in expected response ) , please find below response JSON and expected JSON.

Json response
------------------
{
searchresult:{
      "address": {
           "sequenceNumber": 1,
            "sequenceNumber": 1,
             "country": "US", 
              "city": "NEW YORK CITY",
               "line": "1234 ECDC ST",
                "latitude": 40.7204,  
                  "stateProvince": "NY"
                 }
        "email":  {
             "type": "WORK",
              "sequenceNumber": "1",
              "precedenceCd": "ONE",
               "value": "[e-mail]"
}
}
}

Expected Response 
-------------------------------
{
searchresult:{
   "address":  [{
        "sequenceNumber": 1,
        "country": "US",
        "city": "NEW YORK CITY",
         "line": "1234 ECDC ST",
        "latitude": 40.7204,
        "stateProvince": "NY"
}]
  "email":  [{
         "type": "WORK", 
         "sequenceNumber": "1",
         "precedenceCd": "ONE", 
         "value": "[e-mail]" 
}]
} 
}

Appreciate your help on this.
thanks in advance,

--Uday.

[Suhas M V]

Hi Uday,

You can use Evaluate Regular Expression with Match & Replace Option to get this output.

Find        : ("address":)(.*?)}
Replace  : "address":[$2}]

Thanks !

[Uday Reddy]

Hi Suhas M V,

{ 
   "searchresult":{ 
      "address":[ 
         { 
            "sequenceNumber":1,
            "country":"US",
            "city":"NEW YORK CITY",
            "line":"1234 ECDC ST",
            "latitude":40.7204,
            "stateProvince":"NY"
         },
         { 
            "sequenceNumber":2,
            "country":"US",
            "city":"NEW YORK CITY",
            "line":"1234 ECDC ST",
            "latitude":49.7204,
            "stateProvince":"NY"
         }
      ],
        "email":  [ 
         { 
            "sequenceNumber":1,
            "precedenceCd":"ONE",
            "type":"WORK",
            "value":"[e-mail]"
         },
         { 
            "sequenceNumber":7,
            "precedenceCd":"ONE",
            "type":"PERSONAL",
            "value":"[e-mail]"
         }
      ]
   }
}​

Thanks a lot for your reply
,
yes, its working for one node and one entry  but we need to apply for multiple nodes in response like email and telephone  and some time response coming with array format( like below), that time its  applying two time [] brackets.

[Suhas M V]

Hi Uday,

You will have to repeat this regular expression for all the fields that is expected to be an array. Also execute it logically. You can evaluate JSON Path/Xpath to get number of objects/elements & then if the count =1 , execute regular expression.

[Uday Reddy]

Hi Suhas M V,

Thanks a lot for your help on this.

I have resolved this issue with regex expression. the expression is applied in complete response and finding the tag which is not in array then replacing with array[].

find :        ("email":\s*\{)(.*?)}

Replace:    "email":[$2}]

Thank you.
Uday.