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
Realized I can skip the File Writing by doing a JSON.parse() on the whole thing. Still seems like there should be a better way.
JSON.parse(JSON.stringify(jsonPath($, "entity.feed.entry[*].content['$']")).replaceAll('\\n','').replaceAll('\\','').replaceAll('"{','{').replaceAll('}"','}'))
Hi Paul,
Good day, have you tried to set the Response Entity Type to BINARY in the REST Get snap?
then followed by a mapper with an output view as binary setting up the $content object in prep for writing
If you want to stream the document, use JSON parser snap instead of a File Writer snap
I’ve done that before, but I don’t think it will work in this case because the entity is a whole lot more than just that JSON. I’ll give it a try though. If they were only sending that code as the entity, then I think I’d be ok. I think the mixed modes (xml with embedded JSON) of this data is rightfully causing an issue.
