Turning Embedded JSON into Data
Hi…I have a REST get that returns the following as part of it’s payload:
Not sure what the right approach is, but I ultimately want to take that JSON that comes back as text in that $ field an...
Forum Discussion
Hi @pcoleman,
The following expression
JSON.parse(jsonPath($, "entity.feed.entry[*].content['$']"))
should be enough to parse the JSON string, you don’t need to replace the \n characters.
Unfortunately, it gives me the following when I try that. It seems to somehow interpret it as a list.
“error”:
“Expecting a string argument”Most likely the JSON.parse() method recieved an array instead of string.
If your content it’s always on the same index in your entry array, you can use the following expressionJSON.parse($entity.feed.entry[2].content['$'])or
JSON.parse(jsonPath($, "entity.feed.entry[*].content['$']").toString())This worked, though I needed to preface this with a JSON Splitter. Clearly I overcomplicated this. Thank you!
