I'm pretty new to Workato and am looking for help on the right path for creating a recipe. I am working on a project that requires a recipe to retrieve SQL data and generate an XML file, then FTP it to a client. Ideally I would like to also be able to send an email with the file attached.
I've been looking into the documentation and haven't found what I think would be the correct solution. I've found the Compose CSV connector, but nothing for XML compose. From what I can tell, the XML parser connector is only for reading documents not creating new ones.
Does anyone have a suggestion on how to go about doing this?
Rwerning
How to compose an XML for FTP upload?
I'm pretty new to Workato and am looking for help on the right path for creating a recipe. I am working on a project that requires a recipe to retrieve SQL data and generate an XML file, then FTP it to a client. Ideally I would like to also be able to send an email with the file attached.
I've been looking into the documentation and haven't found what I think would be the correct solution. I've found the Compose CSV connector, but nothing for XML compose. From what I can tell, the XML parser connector is only for reading documents not creating new ones.
Does anyone have a suggestion on how to go about doing this?
TIA
Rich