SSIS Components for Microsoft SharePoint

Build 25.0.9434

Sites

Retrieves a list of all available sites within the SharePoint server, including metadata and site details. Useful for managing and navigating large SharePoint deployments.

Columns

Name Type References Description
SiteURL [KEY] String The full URL of the SharePoint site. Useful for navigating and referencing the site in automation or APIs.
SiteCollectionId String A unique identifier for the site collection. Helps distinguish site collections within a SharePoint environment.
WebId String A unique identifier for the specific site within the site collection. Useful for referencing individual subsites.
Title String The display title of the site. Helps users easily identify sites within the collection.
SiteCollectionURL String The URL of the site collection that contains the site. Useful for identifying parent site collections.
Description String A brief description of the site, outlining its purpose or content. Helps provide context to users.
Created Datetime The date and time when the site was created. Useful for tracking site lifespan and historical records.
LastModified Datetime The date and time when the site was last updated. Helps monitor recent site activity.
SPWebUrl String The URL used to display the site in a browser. Useful for UI navigation and direct linking.
Author String The user who created the site. Helps track site ownership and administrative responsibility.
DocumentSignature String A unique identifier related to the site's document signature. Useful for security and verification purposes.
FileExtension String The file extension type associated with the site’s primary document. Helps in identifying site-related files.
SecondaryFileExtension String An alternative file extension associated with the site’s files. Useful for additional document classification.
FileType String The type of file associated with the site. Helps in organizing and filtering site-related documents.
DocId Long A unique identifier for the site within a specific geographic location. Useful for multi-region SharePoint environments.
GeoLocationSource String The geographical location of the site. Helps in categorizing sites based on region or physical location.
HitHighlightedSummary String A highlighted summary of the site's content. Useful for search indexing and quick content previews.
Importance Long An assigned importance score for the site. Helps in prioritizing sites within search results or organizational hierarchy.
IsContainer Bool Indicates whether the site is structured as a folder. Helps distinguish folder-based sites from document-based sites.
IsDocument Bool Indicates whether the site is treated as a document. Useful for categorizing site types.
Path String The full site path within SharePoint. Useful for constructing file references and folder navigation.
Rank Double The rank assigned to the site based on various parameters. Helps determine search relevance.
RenderTemplateId String The control render template used for displaying the site. Helps in UI customization and theming.
SiteLogo String The URI of the site's logo. Useful for branding and visual identification.
ViewsLifeTime Long The total number of views the site has received since creation. Helps measure long-term engagement.
ViewsRecent Long The total number of views the site has received in the last 14 days. Useful for tracking recent user interest.
WebTemplate String The web template used to create the site. Helps identify the site's structure and purpose.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434