Welcome to the Alteryx Knowledge Base

Issue

 

When reading in data with a Sharepoint Input tool, the below error appears:

 

Error encountered: There is an error in XML document (, 

).

 

Environment

 

• Product - Alteryx
• Product - Sharepoint Input Tool

 

Cause

 

The SOAP API response from Sharepoint that Alteryx uses to pull data contains illegal characters per the XML v1.0 standard.

 

Solution

 

1. In a browser, while logged in to your Sharepoint, download the XML atthe list items API endpoint. The API endpoint is defined in the Sharepoint documentation.
2. In a text editor like Notepad++, show all characters, and find the illegal character at the referenced in the error message. You will need to update your Sharepoint data to remove this character.

 

Additional Resources

 

• Sharepoint SOAP API documentation
• How to deal with invalid characters inSOAP responses from ASP.NET web services