Create a WebFile connection in QlikView/ Qlik Sense with the URL in step (2). The returned XML file contains 3 tables, among which list data is contained in table xml/data/row
If the Web file connection cannot be created or fails to load, basic troubleshooting steps are as follows:
On the server where QlikView/ Qlik Sense is installed, open a web browser with the service user or the user running Desktop application. Put the URL in step (2) in the address bar. Make sure that the XML file can be shown/downloaded directly without any authentication or redirection.
Open Internet Options > Security > Local intranet > Custom level... > scroll to User Authentication > select option "Automatic logon with current username and password". Note that it's not always the Local Intranet zone. You can open the Sharepoint list in a browser, right click the page > Properties to understand which zone the page belongs to.
For Qlik Sense only: Open file Settings.ini (C:\ProgramData\Qlik\Sense\Engine for Qlik Sense Enterprise, C:\Users\<Username>\Documents\Qlik\Sense\Settings.ini for Qlik Sense Desktop), addthe following parameter: WebFileUnrestrictedAuth=1 and restart Qlik Sense Desktop/ Engine service. Make sure to backup the file before making any change.