I am trying to build an xml document containing customer orders to be automatically sent to my manufacturer.
Orders come in from my online shop (Ecwid platform) in a particular format which needs to be reformatted to a different layout for my manufacturer.
I’ve managed to use the formatting tool to arrange them in the layout that my manufacturer needs.
They require it in a text file attached to an email in xml layout like this (partial example file shown);
<?xml version="1.0" encoding="UTF-8"?>
<Order_Date>2023-08-17 12:40:06 +0000</Order_Date>
<AddressLine>1 Any Street</AddressLine>
I’ve successfully built the formatting steps to build this using the Convert to ASCII formatter step, but when it’s passed to google docs all the XML specific code characters and everything in between such < / > are removed and the following is what is created in the google doc;
2023-08-17 12:40:06 +0000
1 Any Street
As the contents of the google doc require it to contain the XML layout codes, I’m stuck. Anyone have any pointers as to what I’m doing wrong or a fix for this?
Thanks in advance.