1 Reply Latest reply: Jan 22, 2018 8:36 PM by Swapnil Kumbhar RSS

    Qlikview Sharepoint Connectivity

    Yuvraj Killedar

      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