4 Replies Latest reply: Mar 18, 2016 9:28 AM by Glyn Spencer RSS

    Extracting a Sharepoint List XML through Office 365

    Glyn Spencer

      Hi All,

       

      We're trying to pull an XML file from Sharepoint. We've managed to get the URL (https://xxx.sharepoint.com/sites/ICT/_vti_bin/owssvr.dll?Cmd=Display&List=69D82854-8622-421D-BE44-F1C2B7680748&XMLDATA=TRUE) and this works fine when used within a browser.

       

      However, when we try to add it into the Edit Script we keep getting an error which reads

       

      ---

      A name was started with an invalid character:

      On line number: 40. On column number: 10. System ID:

      https://xxx.sharepoint.com/sites/ICT/_vti_bin/owssvr.dll?Cmd=Display&List=69D82854-8622-421D-BE44-F1C2B7680748&XMLDATA=TRUE

      ---

       

      We are 99.9%  certain this error points to the Office 365 login page (the invalid charater being an & symbol within /login.srf)

       

      Does anybody have any ideas how to get around this. We have no idea how to pass our Office 365 login credentials through QlikView.

       

      Any help appreciated. Thanks in advance.