topic Web Connector connection for share point in server area. in Connectivity & Data Prep

Web Connector connection for share point in server area.

BalaBhaskar_Qlik — Fri, 02 Apr 2021 07:48:01 GMT

Web Connector connection for share point in server area.

I've used web connector Office 365 Sharepoint connector to fetch data from share point into Qlik Sense Desktop June 2018, The Same i want to use in Server area, but not able to get data.

When using web connector i got the Script for the link like below:

Office365Connector_ListItemsFromID:

LOAD

id as ListItemsFromID_id,

title as ListItemsFromID_title,

updated as ListItemsFromID_updated,

FirstUniqueAncestorSecurableObject_Entry as ListItemsFromID_FirstUniqueAncestorSecurableObject_Entry,

RoleAssignments_Feed as ListItemsFromID_RoleAssignments_Feed,

AttachmentFiles_Feed as ListItemsFromID_AttachmentFiles_Feed,

ContentType_Entry as ListItemsFromID_ContentType_Entry,

GetDlpPolicyTip_Entry as ListItemsFromID_GetDlpPolicyTip_Entry,

FieldValuesAsHtml_Entry as ListItemsFromID_FieldValuesAsHtml_Entry,

FieldValuesAsText_Entry as ListItemsFromID_FieldValuesAsText_Entry,

FieldValuesForEdit_Entry as ListItemsFromID_FieldValuesForEdit_Entry,

....

.....

FROM [lib://ISnT_Reporting_Cockpit/]

(URL is [https://localhost:5555/data?connectorID=Office365Connector&table=ListItemsFromID&subSite=%2fsites%2fISTRun%2f&listId=5022f934-76e1-4090-a7f7-7c9781b99354&appID=])(qvx);

// IMPORTANT: If, when loading the above script, you receive a 'Script Error' Dialog box with a 'Field Not Found'

// (or other) error, the first thing you should do is copy and paste the full request URL (i.e. the URL between the square [...]

// brackets IN THE QLIKVIEW / QLIK SENSE SCRIPT ERROR DIALOG) into a browser address bar and check the response.

Re: Web Connector connection for share point in server area.

BalaBhaskar_Qlik — Wed, 26 Sep 2018 01:07:36 GMT

In the above area, the actual query is this:

Office365Connector_ListItemsFromID:

LOAD

id as ListItemsFromID_id,

title as ListItemsFromID_title,

updated as ListItemsFromID_updated,

FirstUniqueAncestorSecurableObject_Entry as ListItemsFromID_FirstUniqueAncestorSecurableObject_Entry,

RoleAssignments_Feed as ListItemsFromID_RoleAssignments_Feed,

AttachmentFiles_Feed as ListItemsFromID_AttachmentFiles_Feed,

ContentType_Entry as ListItemsFromID_ContentType_Entry,

GetDlpPolicyTip_Entry as ListItemsFromID_GetDlpPolicyTip_Entry,

FieldValuesAsHtml_Entry as ListItemsFromID_FieldValuesAsHtml_Entry,

FieldValuesAsText_Entry as ListItemsFromID_FieldValuesAsText_Entry,

FieldValuesForEdit_Entry as ListItemsFromID_FieldValuesForEdit_Entry,

....

.....

FROM

[https://localhost:5555/data?connectorID=Office365Connector&table=ListItemsFromID&subSite=%2fsites%2fISTRun%2f&listId=5022f934-76e1-4090-a7f7-7c9781b99354&appID=](qvx);

I've added the lib path and URL is options.....

Re: Web Connector connection for share point in server area.

Darren_Ball — Wed, 26 Sep 2018 11:40:15 GMT

Hi,

Thanks for posting this information, however, you've not described any errors or issues, so I'm not sure how i can help.

Have you installed and licensed the Qlik Web Connectors on the server?

Do you get any error messages?

Darren Ball

Lead Product Designer - Qlik Web Connectors