Lists
Query the available lists on your sharepoint site.
Table Specific Information
Lists can be used to list the tables in SharePoint. This will only return actual lists in SharePoint and not any special tables associated with the 本製品.
The following columns can be used in the WHERE clause: Title and BaseTemplate.
Columns
| Name | Type | References | Description |
| HasUniqueRoleAssignments [KEY] | Bool | ||
| LinkedFirstUniqueAncestorSecurableObject | String | ||
| LinkedRoleAssignments | String | ||
| ServerRelativeUrl | String | The relative URL of the file based on the URL for the server. This column is available when the URL is a subsite. | |
| Id [KEY] | String | ||
| AllowContentTypes | Bool | ||
| AllowDeletion | Bool | ||
| BaseTemplate | Int | ||
| BaseType | Int | ||
| BrowserFileHandling | Int | ||
| ContentTypesEnabled | Bool | ||
| CrawlNonDefaultViews | Bool | ||
| Created | Datetime | ||
| CurrentChangeToken_StringValue | String | ||
| CustomActionElements_Items | String | ||
| DataSource_Properties | String | ||
| DefaultContentApprovalWorkflowId | String | ||
| DefaultDisplayFormUrl | String | ||
| DefaultEditFormUrl | String | ||
| DefaultItemOpenUseListSetting | Bool | ||
| DefaultNewFormUrl | String | ||
| DefaultViewPath_DecodedUrl | String | ||
| DefaultViewUrl | String | ||
| Description | String | ||
| Direction | String | ||
| DisableGridEditing | Bool | ||
| DocumentTemplateUrl | String | ||
| DraftVersionVisibility | Int | ||
| EffectiveBasePermissions_High | Long | ||
| EffectiveBasePermissions_Low | Long | ||
| EffectiveBasePermissionsForUI_High | Long | ||
| EffectiveBasePermissionsForUI_Low | Long | ||
| EnableAssignToEmail | Bool | ||
| EnableAttachments | Bool | ||
| EnableFolderCreation | Bool | ||
| EnableMinorVersions | Bool | ||
| EnableModeration | Bool | ||
| EnableRequestSignOff | Bool | ||
| EnableVersioning | Bool | ||
| EntityTypeName | String | ||
| ExcludeFromOfflineClient | Bool | ||
| ExemptFromBlockDownloadOfNonViewableFiles | Bool | ||
| FileSavePostProcessingEnabled | Bool | ||
| ForceCheckout | Bool | ||
| HasExternalDataSource | Bool | ||
| Hidden | Bool | ||
| ImagePath_DecodedUrl | String | ||
| ImageUrl | String | ||
| IrmEnabled | Bool | ||
| IrmExpire | Bool | ||
| IrmReject | Bool | ||
| IsApplicationList | Bool | ||
| IsCatalog | Bool | ||
| IsEnterpriseGalleryLibrary | Bool | ||
| IsPrivate | Bool | ||
| IsSiteAssetsLibrary | Bool | ||
| IsSystemList | Bool | ||
| ItemCount | Int | ||
| LastItemDeletedDate | Datetime | ||
| LastItemModifiedDate | Datetime | ||
| LastItemUserModifiedDate | Datetime | ||
| ListExperienceOptions | Int | ||
| ListItemEntityTypeFullName | String | ||
| MajorVersionLimit | Int | ||
| MajorWithMinorVersionsLimit | Int | ||
| MultipleDataList | Bool | ||
| NoCrawl | Bool | ||
| OnQuickLaunch | Bool | ||
| PageRenderType | Int | ||
| ParentWebPath_DecodedUrl | String | ||
| ParentWebUrl | String | ||
| ParserDisabled | Bool | ||
| ReadSecurity | Int | ||
| SchemaXml | String | ||
| ServerTemplateCanCreateFolders | Bool | ||
| TemplateFeatureId | String | ||
| Title | String | ||
| ValidationFormula | String | ||
| ValidationMessage | String | ||
| WriteSecurity | Int | ||
| LinkedContentTypes | String | ||
| LinkedCreatablesInfo | String | ||
| LinkedDefaultView | String | ||
| LinkedDescriptionResource | String | ||
| LinkedEventReceivers | String | ||
| LinkedFields | String | ||
| LinkedForms | String | ||
| LinkedInformationRightsManagementSettings | String | ||
| LinkedItems | String | ||
| LinkedParentWeb | String | ||
| LinkedRootFolder | String | ||
| LinkedSubscriptions | String | ||
| LinkedTitleResource | String | ||
| LinkedUserCustomActions | String | ||
| LinkedViews | String | ||
| LinkedWorkflowAssociations | String |