Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
vengadeshpalani
Creator
Creator

what is the best way to give permission for SharePoint access in qlikview desktop

EMpName:

LOAD

    [content/properties/Title] as EMpName,

    [content/properties/x4ji] as Home1,

    [content/properties/OData__x0064_e31] as Org1

   

FROM [https://avacorp4.sharepoint.com/CP/_api/web/lists/getbytitle('B18')/items] (XmlSimple, Table is [feed/entry]);

row:

LOAD ows_LinkTitle as name,

    ows_x4ji as home,

    ows__x0064_e31 as org

 

FROM [https://avacorp4.sharepoint.com/CP/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={00bf6c0e-f8aa-4a1a-8a3a-62be9d0a5ccb}] (XmlSimple, Table is [xml/data/row]);

when i run this i have error like

error.png

so i follow this step

file --> open URL and past my SharePoint list site it open SharePoint in QlikView and i give Password

this time it Load correctly and fetch the data from SharePoint but when i close and reopen QlikView i need to enter Password

My Question is what is the best way to give permission for SharePoint access 

0 Replies