topic Re: Qlikview Sharepoint Connectivity in QlikView

Qlikview Sharepoint Connectivity

yuvraj_33 — Thu, 18 Jan 2018 09:38:15 GMT

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={xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}

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

Re: Qlikview Sharepoint Connectivity

swapnil_kumbhar — Tue, 23 Jan 2018 01:36:58 GMT

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

using this authentication issue will also resolve.

Re: Qlikview Sharepoint Connectivity

adriansalas — Wed, 08 Aug 2018 18:17:20 GMT

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.

Re: Qlikview Sharepoint Connectivity

Anonymous — Wed, 08 Aug 2018 18:57:04 GMT

first step:

try to open the link

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

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.

Re: Qlikview Sharepoint Connectivity

adriansalas — Wed, 08 Aug 2018 20:58:05 GMT

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