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 and turn it into documents. Not sure if I should be looking at the map() function or what. Any thoughts?
OK. I finally got this to work, but the method I used seems kind of overlong and hacky. First I took the input and ran it through this:
JSON.stringify(jsonPath($, "entity.feed.entry[*].content['$']")).replaceAll('\\n','').replaceAll('\\','').replaceAll('"{','{').replaceAll('}"','}')
This cleaned up the string to look like clean JSON minus the \n, escape and extra quote characters.
After this I turned it into a document and read it back in and used a JSON parser.
This worked, but Iโm not really happy with the method. Is there any sort of clean function that takes control characters and escapes and just scrubs them? Iโve seen payloads in the past that come in a single field in a REST call and it seems like Iโm doing a lot of extra and unnecessary work if I have to write it to disk just to read it back in.
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
