topic Re: Extracting a Sharepoint List XML through Office 365 in QlikView

Extracting a Sharepoint List XML through Office 365

Tue, 15 Mar 2016 16:31:17 GMT

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.

Re: Extracting a Sharepoint List XML through Office 365

mohamed_ahid — Tue, 15 Mar 2016 17:14:58 GMT

Server or desktop ?

have you tried on the same machine with the same windows session?

Re: Extracting a Sharepoint List XML through Office 365

Wed, 16 Mar 2016 08:59:53 GMT

Hi.

It's just the desktop at the moment.

We've tried it on a couple of different machines all with the same result.

I've attached a screenshot of the error within the Edit Script wizard to give people more idea.

The Delimited tab shows '403 FORBIDDEN' which is what leads us to believe it's to do with the Office 365 login page.

Thanks. Glyn.

Re: Extracting a Sharepoint List XML through Office 365

mohamed_ahid — Wed, 16 Mar 2016 10:59:26 GMT

try like here :

How to load data from sharepoint which needs authentication?

On Qlik file -->open URL --> past your sharepoint link .

when you are connected Qlik can access to the sharepoint from now on .

try this and tell me how it goes.

can you tel me which browser have tried ?IE ?

Thx

Re: Extracting a Sharepoint List XML through Office 365

Fri, 18 Mar 2016 13:28:18 GMT

Hi.

Thanks for this. I tried placing the URL into the 'Open URL' box, but i was met with an error within the QV browser saying;

We can't sign you in

Your browser is currently set to block cookies. You need to allow cookies to use this service.

However, just as we found this, we actually managed to extract the data within Sharepoint into a HTML data file, so we are now pulling the data directly from that instead. It is much easier. Thanks for all your help though! Much appreciated!!