Question
CTS
NL
Last activity: 23 Feb 2017 5:02 EST
JSON response starts with an array
Hi,
We have configure service rest and send out pagelist data in json format as response. We are getting the response, but the response starts with an array. Example below-
[{ "data":[{"a":"123","b":"456"}]},{ "data":[{"c":"123","d":"456"}]}].
We want only one object data with array of results. Example below-
{ "data":[{"a":"123","b":"456"}], "data":[{"c":"123","d":"456"}]}. How could i achieve this. Please help.
Thanks in advance.
WellsFargo
IN
Hi ,
Take the response in the parameter and then use the adoptjson( stepPage.adoptJSONObject(JSONResponse); ) to convert the string into Clipboard Page format.
Regards
Ram
Pegasystems Inc.
GB
If you input JSON is guaranteed to *always* going to be held within an array like you post; you could treat it as a string and remove the "[" and "]" characters at the start and end using a REGEX.
Like this:
@pxReplaceAllViaRegex(param.input,"^\\[|\\]$","")
However: treating JSON like a String isn't particularly robust; you should consider using a JSON library to do this properly. (There are some JSON libraries available already in PRPC ; take a look at the JARs available in the 'pr_engineclasses' table for example).
Pegasystems Inc.
GB
Possibly this REGEX is better as it takes into account whitespace:
@pxReplaceAllViaRegex(param.input,"^\\s*\\[|\\\\s*]\\s*$","")