SharePoint Connector - Metadata — Unique AI Documentation
SharePoint Connector - Metadata
Ingested Metadata
The connector retrieves documents and their metadata via the Microsoft Graph API. For each document, it calls the Graph drive items endpoint with an expanded listItem and fields, which returns all SharePoint list columns. During ingestion, the connector passes these column values as metadata to the Unique platform.
Regular Documents (Document Libraries)
For regular documents in document libraries, the connector passes through all SharePoint column values as-is (the full fields bag from Graph), plus the following derived fields:
| Field | Source | Description |
|---|---|---|
Url |
webUrl property on the list item |
The document's web URL |
Link |
Same as Url |
Alias for the document's web URL |
Path |
Parent reference path | The folder path within the drive |
DriveId |
Drive identifier | The Microsoft Graph drive ID |
ItemInternalId |
id property from Graph API response |
The Microsoft Graph drive item ID (a longer unique identifier) |
Filename |
FileLeafRef SharePoint field |
The file's leaf name |
Author |
createdBy property |
Structured object with email, displayName, and id |
Native SharePoint columns that come through include (among others): FileLeafRef, Modified, Created, ContentType, AuthorLookupId, EditorLookupId, FileSizeDisplay, Title, plus any custom columns defined on the library.
Graph API Call
GET /drives/{driveId}/items/{itemId}/children
?$select=id,name,webUrl,size,createdDateTime,lastModifiedDateTime,createdBy,folder,file,listItem,parentReference
&$expand=listItem($expand=fields)
SitePages
SitePages (pages created directly in SharePoint such as news posts or wiki pages) are handled differently from regular documents:
| Field | Source | Description |
|---|---|---|
Url |
webUrl property on the list item |
The page's web URL |
Link |
Same as Url |
Alias for the page's web URL |
Path |
webUrl property |
The page's web URL (used as folder path) |
DriveId |
SitePages list ID | The SitePages list identifier (not a document library drive ID) |
ItemInternalId |
id property from Graph API response |
Sequential list item ID (e.g. 1, 2, 3), unique only within that SitePages list |
Filename |
FileLeafRef SharePoint field |
The page's file name |
Author |
createdBy property |
Structured object with email, displayName, and id |
ModerationStatus |
_ModerationStatus SharePoint field |
Content approval status (only present for SitePages) |
SitePages carry a reduced set of SharePoint column values: FileLeafRef, FileSizeDisplay, Title, AuthorLookupId, EditorLookupId, _ModerationStatus, and the sync flag column.
Graph API Call
GET /sites/{siteId}/lists/{listId}/items
?$select=id,createdDateTime,lastModifiedDateTime,webUrl,createdBy,lastModifiedBy
&$expand=fields($select=FileLeafRef,FileSizeDisplay,_ModerationStatus,Title,AuthorLookupId,EditorLookupId)
Key Differences Between Regular Documents and SitePages
| Aspect | Regular Documents | SitePages |
|---|---|---|
| Metadata fields | Full set of all SharePoint column values | Reduced set (FileLeafRef, FileSizeDisplay, Title, AuthorLookupId, EditorLookupId, _ModerationStatus, sync column) |
| ItemInternalId | Graph API drive item ID (long unique identifier) | Sequential list item ID (e.g. 1, 2, 3), unique only within that SitePages list |
| DriveId | Document library drive ID | SitePages list ID |
| ModerationStatus | Not present | Content approval status from _ModerationStatus field |