Office 365 Sharepoint Connector

shannonmarshall — Wed, 15 Dec 2021 18:10:18 GMT

Greetings,

We are using the trial version of the Office 365/SharePoint web connector to see if this is something we want to purchase. While doing our testing we are having trouble locating certain sample lists we have put on our SharePoint site. Below is the code we are using to get Lists from our SharePoint site:

UBI_Lists:
LOAD
id as Lists_id,
title as Lists_title,
updated as Lists_updated,
FirstUniqueAncestorSecurableObject_Entry as Lists_FirstUniqueAncestorSecurableObject_Entry,
RoleAssignments_Feed as Lists_RoleAssignments_Feed,
ContentTypes_Feed as Lists_ContentTypes_Feed,
CreatablesInfo_Entry as Lists_CreatablesInfo_Entry,
DefaultView_Entry as Lists_DefaultView_Entry,
DescriptionResource_Entry as Lists_DescriptionResource_Entry,
EventReceivers_Feed as Lists_EventReceivers_Feed,
Fields_Feed as Lists_Fields_Feed,
Forms_Feed as Lists_Forms_Feed,
InformationRightsManagementSettings_Entry as Lists_InformationRightsManagementSettings_Entry,
Items_Feed as Lists_Items_Feed,
ParentWeb_Entry as Lists_ParentWeb_Entry,
RootFolder_Entry as Lists_RootFolder_Entry,
Subscriptions_Feed as Lists_Subscriptions_Feed,
TitleResource_Entry as Lists_TitleResource_Entry,
UserCustomActions_Feed as Lists_UserCustomActions_Feed,
Views_Feed as Lists_Views_Feed,
WorkflowAssociations_Feed as Lists_WorkflowAssociations_Feed,
AllowContentTypes as Lists_AllowContentTypes,
BaseTemplate as Lists_BaseTemplate,
BaseType as Lists_BaseType,
ContentTypesEnabled as Lists_ContentTypesEnabled,
CrawlNonDefaultViews as Lists_CrawlNonDefaultViews,
Created as Lists_Created,
CurrentChangeToken_StringValue as Lists_CurrentChangeToken_StringValue,
CustomActionElements_Items as Lists_CustomActionElements_Items,
DefaultContentApprovalWorkflowId as Lists_DefaultContentApprovalWorkflowId,
DefaultItemOpenUseListSetting as Lists_DefaultItemOpenUseListSetting,
Description as Lists_Description,
Direction as Lists_Direction,
DisableGridEditing as Lists_DisableGridEditing,
DocumentTemplateUrl as Lists_DocumentTemplateUrl,
DraftVersionVisibility as Lists_DraftVersionVisibility,
EnableAttachments as Lists_EnableAttachments,
EnableFolderCreation as Lists_EnableFolderCreation,
EnableMinorVersions as Lists_EnableMinorVersions,
EnableModeration as Lists_EnableModeration,
EnableRequestSignOff as Lists_EnableRequestSignOff,
EnableVersioning as Lists_EnableVersioning,
EntityTypeName as Lists_EntityTypeName,
ExemptFromBlockDownloadOfNonViewableFiles as Lists_ExemptFromBlockDownloadOfNonViewableFiles,
FileSavePostProcessingEnabled as Lists_FileSavePostProcessingEnabled,
ForceCheckout as Lists_ForceCheckout,
HasExternalDataSource as Lists_HasExternalDataSource,
Hidden as Lists_Hidden,
ImagePath_DecodedUrl as Lists_ImagePath_DecodedUrl,
ImageUrl as Lists_ImageUrl,
IrmEnabled as Lists_IrmEnabled,
IrmExpire as Lists_IrmExpire,
IrmReject as Lists_IrmReject,
IsApplicationList as Lists_IsApplicationList,
IsCatalog as Lists_IsCatalog,
IsPrivate as Lists_IsPrivate,
ItemCount as Lists_ItemCount,
LastItemDeletedDate as Lists_LastItemDeletedDate,
LastItemModifiedDate as Lists_LastItemModifiedDate,
LastItemUserModifiedDate as Lists_LastItemUserModifiedDate,
ListExperienceOptions as Lists_ListExperienceOptions,
ListItemEntityTypeFullName as Lists_ListItemEntityTypeFullName,
MajorVersionLimit as Lists_MajorVersionLimit,
MajorWithMinorVersionsLimit as Lists_MajorWithMinorVersionsLimit,
MultipleDataList as Lists_MultipleDataList,
NoCrawl as Lists_NoCrawl,
ParentWebPath_DecodedUrl as Lists_ParentWebPath_DecodedUrl,
ParentWebUrl as Lists_ParentWebUrl,
ParserDisabled as Lists_ParserDisabled,
ServerTemplateCanCreateFolders as Lists_ServerTemplateCanCreateFolders,
TemplateFeatureId as Lists_TemplateFeatureId
FROM [$(vQwcConnectionName)]
(URL IS [http://localhost:5555/data?connectorID=Office365Connector&table=Lists&subSite=%2fsites%2fuva-ubi&maxResults=5&appID=], qvx);

STORE [UBI_Lists] into 'lib://EDW_SharedQVDs-Folder/UBI Lists.csv'(txt);

From the csv file I can see the name of the list "SampleQlikList" that I am looking for, but I am not sure how I get to the data that lives in that list. We have created four csv files to test and none of them have that detail of data. Below are the lists we using:

http://localhost:5555/data?connectorID=Office365Connector&table=SubSites&subSite...

http://localhost:5555/data?connectorID=Office365Connector&table=Lists&subSite...

http://localhost:5555/data?connectorID=Office365Connector&table=ListFolders&subSite...

http://localhost:5555/data?connectorID=Office365Connector&table=ListFiles&subSite...

Thanks

topic Office 365 Sharepoint Connector in Connectivity & Data Prep

Office 365 Sharepoint Connector