FTP download of XML files

Question

Hello All,

I have been using a workflow for a while now to download .csv files and this works fine. Now however, I need to start downloading .xml files and I get the following error:

Error: Dynamic Input (9): Error reading "C:\Users\NAME\OneDrive - COMPANY\A_Alteryx GSIP Workflows\WIP workflows\CL_01_Test_IRM_mnent.exp.xml": Too many fields in record #29513

So the download works and the files arrive, the above error is in the 'Dynamic input', any suggestion on why a .csv would work and a .xml wont?

Bigmonki · Answer

Hi @Maskell_Rascal On the macro input data tool, what should the action type be set to and is it required? With the XML parse tool, I get this error message: XML Parse (7) invalid document structure at Line:1 and Column:39 This is line 1 in my output - Here is the structure of my .xml file, there are multiple entries

Maskell_Rascal · Answer

Hi @Bigmonki

You need to read in your XML files as a .CSV and then use the XML Parse tool to get the data.

Here is a post that covers a dynamic xml input.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamic-XML-input/td-p/442403

If this solves your issue please mark the answer as correct, if not let me know!

Thanks!

Phil