SharePoint
Import documents from chosen SharePoint and OneDrive folders into the Evidence Locker, and questionnaire spreadsheets from a SharePoint drive into Questionnaires.
At a glance
| Direction | Into Aegis. Aegis only reads; it never changes or deletes anything in SharePoint. |
|---|---|
| What it brings in |
The files in the folders you add as
Evidence sources (optionally with subfolders); with a
Questionnaires schedule, the .xlsx and
.csv questionnaire files in the drive and folder set
under Questionnaire import.
|
| Where it lands |
The Evidence Locker, as drafts awaiting
review, under the original file name with a SHA-256 and a link back
to the item. A source's Import mapping sets the
evidence type, validity, tags and linked controls. Questionnaire
files become questionnaires in the questionnaires overview.
|
| Credentials and permissions |
An app registration in your Microsoft Entra ID tenant (client ID,
client secret, tenant ID) with the delegated Microsoft Graph
permissions
Files.Read.All and Sites.Read.All and
admin consent. An administrator signs in once with
Authorize with Microsoft. Alternatively, evidence can
be read app-only: the app gets the application permission
Sites.Selected and read access to named sites only (see
below).
|
| Owner of imported records |
Whoever selected Sync Now or the source's
Sync. A scheduled sync gives the evidence to the person
who added the source or, if that account is disabled, the
longest-standing active Admin; with neither, the run fails instead
of importing unowned evidence.
|
| When it runs |
On demand (Sync Now, per source Sync, or
the API), or on a schedule under Sync Settings (see
Connectors). A schedule must name what
it imports: Evidence with one or more sources, or
Questionnaires.
|
| Set it up |
/connectors/sharepoint, on a plan that includes the
connector. The page is for
Admin and
Manager; a Contributor
or Viewer who opens it is redirected with an access-denied notice.
|
What's on this screen
No screenshot accompanies this chapter; the description below follows the page as it is built. The page grows as you set the connector up: some panels appear only once it is connected.
-
Header: A breadcrumb back to
Connectors, the titleSharePoint Connectorand a one-line description. Once the configuration has been saved, a linkMap the statuses and fields of synced tickets →opens the mapping editor; its note says it applies only to the tickets this connector feeds into security processes, not to evidence imports. -
Configuration:
Client ID,Client Secret(leave it blank to keep the saved one) andTenant ID(defaultcommon). Below them,Evidence accesschoosesDelegated (as the signed-in Microsoft user)orApp-only, granted sites only (Sites.Selected). Then theQuestionnaire importfields,Questionnaire drive IDandQuestionnaire folder ID, andSave Configuration. -
Connection status: Before the Microsoft sign-in it says OAuth authorisation
is required and offers
Authorize with Microsoft. When connected it readsConnected to SharePoint, with the drive name and type or the number of accessible sites, and offersTest ConnectionandRe-authorize. -
Evidence sources (connected only): The folders Aegis imports, each with its
site, library and path, whether subfolders are included, a mapping summary
(how many controls and file-name rules, or
No import mapping), and the buttonsSync,Import mapping,EnableorDisable, andRemove.Add sourceopens the folder picker. -
Sync Status (connected only):
Sync Nowand theRecent Syncshistory. With no enabled source,Sync Nowis disabled and the panel says it imports configured evidence sources only. - Setup Instructions: The six setup steps, including the exact redirect URI for your Aegis address.
Set up and run a first sync
The full walkthrough, with the Microsoft sign-in error codes, is in Connectors. In short:
-
Fill in
Client ID,Client SecretandTenant ID, keepEvidence accessonDelegated, and selectSave Configuration. The connection panel now asks for authorisation. -
Select
Authorize with Microsoft, sign in and accept the consent screen. Back in Aegis the panel readsConnected to SharePoint, and theEvidence sourcesandSync Statuspanels appear. -
Select
Add source, choose aSite, aLibrary(when the site has more than one) and aFolder, and tickInclude subfoldersif you want the whole tree. -
Select
Preview files. Aegis lists the files with their count and total size, marks any the Evidence Locker would refuse, and shows which mapping rule each file falls under. A long folder shows only its first files. Set anImport mappingif you want one, give the source a name, and selectSave source. -
Select
Sync Now. The run is added toRecent Syncswith its result.
App-only evidence access
With App-only, granted sites only (Sites.Selected), Aegis reads
evidence under the app's own identity and only from the sites an administrator
granted it, so nobody's personal access is used. Only evidence sources use this
mode: policy and questionnaire imports, and SharePoint list ticket sources, stay
delegated.
-
A
Granted site URLsbox appears: one SharePoint site URL per line, required. Aegis uses the first 20 URLs and ignores any beyond that.Tenant IDmust then be your own tenant ID;common,organizationsorconsumerskeepSave Configurationdisabled. -
The
Admin steps for app-only accessbox lists what to do in Microsoft Entra: give the app the application permissionSites.Selectedwith admin consent, grant it read access to each evidence site, then save and useTest Connection, which checks read access to every listed site. No Microsoft sign-in is needed. -
In the folder picker only the granted sites are listed, and
My OneDrive (personal)is not offered.
Import mapping
Import mapping on a source (or in the picker, after the preview)
decides what every file from that folder becomes:
Evidence type (default Document), Valid for (days),
Tags and Controls (search with at least two
characters). File-name rules are tried in order and the first match
wins: * matches any characters, ? one character, and a
pattern with / matches the path below the folder. A matching rule
replaces the type and validity and adds its controls and tags. Linked controls
count only after the evidence is approved, and controls of frameworks you cannot
see are skipped.
Reading the sync history
Each entry under Recent Syncs shows Sync Complete or
Sync Failed, how it started (Sync Now,
API or Schedule), who ran it, when, which folders it
read, and the counts, such as 13 files synced,
2 skipped and 1 error, plus how many files the
Evidence Locker rules refused. A run that broke off says
The sync stopped before it finished. Every run is recorded,
successful or not.
Good to know
- A file already in the locker is skipped. A file that changed after its evidence was approved comes in as a new version awaiting review. While that version (or a first import that was never approved) is still in review, a further change counts as an error and is imported by a later sync.
- A file the Evidence Locker refuses (type, size or content signature) counts as an error and as refused; retrying cannot fix it, so a schedule does not fail on refusals alone. Neither leaves an evidence record behind.
- Deleting or moving a file in SharePoint leaves its evidence in the locker: the stored copy, not the link, is the evidence.
- Imported files count as uploaded by the connector, so the admin who synced them may approve them.
- A personal OneDrive folder is saved as a source only after you confirm its files may be imported as evidence.
-
Sync Nowand the API import configured sources only; an arbitrary drive or folder is refused.Disablekeeps a source but leaves it out of every sync;Removeasks forConfirm removalfirst. -
Questionnaire import reads only
.xlsxand.csvfiles and runs through aQuestionnairesschedule. LeavingQuestionnaire drive IDempty turns it off;Questionnaire folder IDdefaults toroot. A questionnaire that changes in SharePoint after import is not re-imported, because the copy in Aegis may already hold answers.
Where this connects
Step-by-step setup, including the Microsoft sign-in error codes and the sync schedules, is in Connectors. Imported files are reviewed in Evidence.