Skip to main content
The SharePoint Source Connector ingests data from a SharePoint Online site — site lists and their contents — into Popsink pipelines via the SharePoint REST API. It authenticates through a Microsoft Entra ID (Azure AD) application and runs on a configurable schedule, making collaborative and operational data from SharePoint available for analytics and integration.

Key Features

  • Site lists by default: ingests the site’s lists out of the box; the resource list can be customized.
  • Entra ID authentication: secure app-only access using the OAuth2 client credentials flow — no user account required.
  • Scheduled ingestion: flexible scheduling by minutes, hours, or days, with an immediate first run on creation.

Prerequisites

  • A SharePoint Online site you want to ingest from.
  • A Microsoft Entra ID app registration with:
    • A client secret.
    • The Sites.Read.All application permission granted and admin-consented.
  • The app must be authorized to access SharePoint site content in your tenant.

Configuration

FieldRequiredDescription
Site URLYesSharePoint site URL (e.g. https://contoso.sharepoint.com/sites/mysite)
Tenant IDYesMicrosoft Entra ID tenant ID
Client IDYesApplication (client) ID of the app registration
Client SecretYesClient secret generated for the app registration
ScheduleYesSync frequency — see Scheduling

Scheduling

API source connectors run on a schedule rather than streaming continuously. A first run is always triggered immediately after the connector is created; subsequent runs depend on the selected mode:
ModeBehaviorExample
daysRuns every N days at 00:00 UTC + offset (in minutes)Offset 30 → every day at 00:30 UTC
hoursRuns every N hours at :00 + offset (in minutes)Offset 15 → 00:15, 01:15, 02:15, …
minutesRuns every N minutes, anchored on the connector creation timeCreated 10:03, interval 10 → 10:13, 10:23, …