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?
Send us a ticket, we will try our best to assist you with your problem