Error downloading from SharePoint List with Versions

Question

Hello,

We have a workflow that hits a SharePoint List View using the Download and XML Parse tools.

When running against the main body of the list it is fine and we get ~25k rows back.

However when running with "&IncludeVersions=TRUE" to get all versions we get the following error:

A '<' character cannot be used in attribute 'dir', except through < at Line:4 and Column:13 (Tool Id: 7)

Tool 7 is the XML Parse

I tried using a max rows condition and successfully got to about 340k rows being returned before it began failing again.

Any thoughts?

danilang · Answer

Hi @Nicholas_Sinclair

It looks like the versioned info contains data that is not valid XML.   Try to find the row that the XML tool is choking on.  Maybe you can do some preprocessing on it to remove the invalid XML.

Dan

gabrielvilella · Answer

I am not sure what you need to extract from SharePoint, but there is a new tool to connect to SharePoint that for lists and files.

https://community.alteryx.com/t5/Public-Community-Gallery/Sharepoint-Files-Tool/ta-p/877903