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.

Set up and run a first sync

The full walkthrough, with the Microsoft sign-in error codes, is in Connectors. In short:

  1. Fill in Client ID, Client Secret and Tenant ID, keep Evidence access on Delegated, and select Save Configuration. The connection panel now asks for authorisation.
  2. Select Authorize with Microsoft, sign in and accept the consent screen. Back in Aegis the panel reads Connected to SharePoint, and the Evidence sources and Sync Status panels appear.
  3. Select Add source, choose a Site, a Library (when the site has more than one) and a Folder, and tick Include subfolders if you want the whole tree.
  4. 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 an Import mapping if you want one, give the source a name, and select Save source.
  5. Select Sync Now. The run is added to Recent Syncs with 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.

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

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.