Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
yuvraj_33
New Contributor II

Qlikview Sharepoint Connectivity

Hi All,

Facing issue while trying to extract data from sharepoint lists.

Tried using below methods:

1. RPC procedures:

     The created link works on browser & generates xml but doesn't work when used through Qlikview

             https://***.sharepoint.com/***/***/***/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={xx...}

Please find below error screenshot:

2. Rest Interface:

Following link doesn't work through Qlikview and seems it is giving authentication error.

https://***.sharepoint.com/***/***/***/_api/web/lists/getbytitle('Test')/Items

Please find below error screenshot.

We have tested using QV version 11.20 SR12 and 12.20 SR1 and SharePoint Online version which is a part of MS Office 365 package.

Kindly assist as the exact cause of error cannot be concluded.

Thanks in advance.

Regards,

Yuvraj Killedar

4 Replies
swapnil_kumbhar
New Contributor III

Re: Qlikview Sharepoint Connectivity

‌Use Rest Connectors to connect to XML data of web page.

using this authentication issue will also resolve.

adriansalas
New Contributor III

Re: Qlikview Sharepoint Connectivity

This is an autentication issue, i am actually working with this, i am thinking create a workarround for download the xml or connect with Microsoft Access.

roharoha
Valued Contributor III

Re: Qlikview Sharepoint Connectivity

first step:

try to open the link

      https://***.sharepoint.com/***/***/***/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={xx...}

in Internet Explorer.

As soon as this works, QlikView will also work. I had similar problems gettings the correct List ID.

You can fetch it for example with sharepoint designer.

adriansalas
New Contributor III

Re: Qlikview Sharepoint Connectivity

My link works perfectly in Internet explorer but can´t work in qlikview, i have the same error

Community Browser