So basically, I have a JSON within a JSON. I've tried using tExtractJSONFields with both JsonPath and XPath, but the only way I can get it to work is if I escape out the double quotes in the nested JSON. Unfortunately, it doesn't look like the service upstream of my job will be able to generate the JSON this way, so I'm stuck trying to parse the nested JSON without the double quotes escaped.
Does anybody have any experience with this and know of a way (using stock Talend components) that I can parse the JSON above? My team tries to avoid using external java libraries and raw code as much as we can, but I'm starting to think that might be my only option.