Hi all, I have the following problem: I receive emails with data from applicants. The data of the applicants are attached as XML file. I want to read the XML attachment and then transfer the data it contains to a Google Sheet or other app. However, I can’t access the contents of the XML file with the XML parser. I have also tried using the iterator to separate the XML from the email and store it in a Google Drive. This also works so far. The problem is that the file loses the XML specifications and when I parse the saved file I get the error that there is no valid XML format. What can I do to read the contents of an XML file that I receive by email?
I have worked on similar setup before and this is what I did,
- Download the XML File either using Get a File Module or in my case Dropbox
- Define the DataStructure of XML in Make Data Structure
- Parse XML
Please do let me know if helps.
1 Like
Hi, yes this has been helpfull. Thank you. I do face another issue
I have a lot of strucutured data in my bundles which I can parse through and catch the data. But there is one array or bundle constisting of a bunch of data. It is strucutured like having title and a value behind, each seperated by semicolons. I could not find a tutorial on how to parse this and fetch some of the data which I warnt to use only
Can you share me how it looks like?
1 Like
Hi, Thanks for reaching out. I allready solved it.