Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Extracting a Sharepoint List XML through Office 365

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-F1...) 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-F1...

---

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.

Tags (2)
4 Replies
mohamed_ahid
Contributor III

Re: Extracting a Sharepoint List XML through Office 365

Server or desktop  ?

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

Not applicable

Re: Extracting a Sharepoint List XML through Office 365

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.

1.png

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

2.png

Thanks. Glyn.

mohamed_ahid
Contributor III

Re: Extracting a Sharepoint List XML through Office 365

Hi

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

Not applicable

Re: Extracting a Sharepoint List XML through Office 365

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!!

Community Browser