Qlikview Sharepoint Connectivity

[yuvraj_33]

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

[swapnil_kumbhar]

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

using this authentication issue will also resolve.

[adriansalas]

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.

[Anonymous]

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]

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