JSON Request Modification

Question

I need to modify my JSON. I want to remove " before [ and ]

Current Request :

{"marital-status":"Single","hospitalisation":"["hello", "world"]","ill-health":false,"specialist-condidtions":"["HEADACHE", "PANIC ATTACK"]","smoker":false,"health-concerns":false}

Modified request :

{"marital-status":"Single","hospitalisation":["hello", "world"],"ill-health":false,"specialist-condidtions":["HEADACHE", "PANIC ATTACK"],"smoker":false,"health-concerns":false}

I tried using the translate function fn:translate(req,'"[','[') but this replaced all my " as well as [.

Second point is that this is not syntactically valid JSON, so no JSON parser will touch. The real problem is creating it as valid in the first place. But since you don't say how it is being created, it is hard to know how to help. — Stephen C, Feb 20 '18 at 07:35
Let consider the whole request as valid , what i am looking for is replacing the "[ and ]" with [ and ] respectively.. — Anirban Roy, Feb 20 '18 at 07:40
Fix your java code to produce valid JSON and save yourself a lot of trouble and future headaches. — Mads Hansen, Mar 11 '18 at 19:13

score 0 · Answer 1 · answered Feb 20 '18 at 10:15

If you have the XML in the pipeline, why don't you just use NXSD to translate automatically to json.

To do this aslong as you have the XSD For the JSON then just use a nXSD componenant the translation will happen automatically?

https://svgonugu.com/2015/12/27/using-translate-activity-for-xml-to-json/

score 0 · Answer 2 · answered Mar 11 '18 at 19:33

<rant>You really should fix the Java process that is generating mangled output to ensure that it generates valid JSON. Trying to repair broken data is a waste of time and defeats the purpose of using standard data formats. It also likely to fail at random times when the "fix" fails to handle all of the edge cases.</rant>

The reason why fn:translate() didn't work the way you expected is that you were probably expecting it to work more like a find/replace of the full strings, but it is character based. The first character from the second param will be replaced with the first character from the third param (or removed, if there is no corresponding character), and then each subsequent character in the strings. So, fn:translate(req,'"[','[') really meant, "replace a double quote with [ and replace [ with nothing".

In order to remove the offending characters, you could use fn:replace(), which takes a regex pattern for what to find, and a string for what to replace with:

fn:replace(fn:replace(req, '"\[', "["), '"\]', "]")

JSON Request Modification

2 Answers2