FTP download of XML files

[Bigmonki]

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?

[Maskell_Rascal]

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

[Bigmonki]

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 - <?xml version="1.0" encoding="UTF-8"?>

Here is the structure of my .xml file, there are multiple <TableRecord> entries