I would think this REST service should be doing some sort of quoting for the field with the XML in it so this wouldn’t be a problem. Is that not happening? Can you give an example of the full row of data?
Hi Tim
Thanks for your reply. Attached is a row of data that is throwing the error. There is a custom XML field called “CustomXML”. I attached the file because it wasn’t displaying properly here.
Sample_Data.txt (1.4 KB)
It looks like it’s not quoted, that’s too bad. If the <CustomXML> tag is pretty unique, you could try to add quoting by doing some string replacement using a mapper snap, like so:
$content.replace(/(\n<CustomXML>)/g, '"$1').replace(/(<\/CustomXML>)/g, '$1"')
This expression adds a double quote before the start tag and then another one after the end tag.
