Environment

ControlPoint 5.x

Situation

How do you use ControlPoint to ingest from Sharepoint Online?

Resolution

The Sharepoint Remote Connector does not work if "Apps that don't use modern authentication" is blocked.
To confirm:
Login to Office 365 as the account you wish to use with Sharepoint connector.
https://www.office.com
Access Sharepoint Admin - Policies - Access Control
Apps that don't use modern authentication - The default is normally Allow access but sometimes this can be set to blocked. If it is blocked you will need to set to Allow.

You do not need to configure OAuth if you don't need mapped security enabled in the task section of the connector.cfg.

Add a Sharepoint repository via the CP UI.

The default entries added to the Sharepoint Remote Connector.cfg will not be correct for Sharepoint Online.

Here is an example of the correct values to use for reference when editing the connector.cfg:

[FetchTasks]
Number=0
Username=username@mydomain.onmicrosoft.com
Password=xxxxxxxxx
Domain=mydomain

NOTE: Sometimes proxy entries are also required in [FetchTasks].

[Groups_TaskSPSOnline1]
IncludeEmptyFields=True
ExtractSubfiles=True
MappedSecurity=False
IngesterType=CFS
SharepointUrlType=SiteCollection
IngestActions=META:CPREPOSITORYTYPEID=9,META:AUTN_NO_EXTRACT=true,META:AUTN_CATEGORIZE=false,META:AUTN_EDUCTION=false
EncryptACLEntries=False
SharepointUrl=https://mydomain.sharepoint.com/sites/TeamSite1
MaxMatches=
ScheduleStartTime=now
ScheduleCycles=1
ScheduleRepeatSecs=3600
IndexDatabase=SPSOnline1

[TaskSPSOnline1]
SharepointOnline=True
IncludeEmptyFields=True
ExtractSubfiles=True
MappedSecurity=False
IngesterType=CFS
SharepointUrlType=SiteCollection
IngestActions=META:CPREPOSITORYTYPEID=9,META:AUTN_NO_EXTRACT=true,META:AUTN_CATEGORIZE=false,META:AUTN_EDUCTION=false,META:CPREPOSITORYSCANID=14
EncryptACLEntries=False
SharepointUrl=https://mydomain.sharepoint.com/sites/TeamSite1
MaxMatches=
ScheduleStartTime=now
ScheduleCycles=1
ScheduleRepeatSecs=3600
IndexDatabase=SPSOnline1

Delete these folders:
actions
logs

Deleted the connector_TASK*.*_datastore.db file associated with the repository if one already exists.

Restart the Sharepoint Remote connector
Used CP UI to commence a re-scan.
Review the synchronise.log and confirm ingestion is successfully progressing.

Access support article here