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
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