Configuring External Sources: SharePoint
This guide explains how to configure SharePoint as an External Source in the Netpresenter Content Hub. It assumes that the SharePoint Connection has already been created in Netpresenter.
Step 1 — Configure the SharePoint External Source
In Netpresenter Content Hub Admin, go to:
Settings → External Sources → Sources
Click Add new External Source and select SharePoint
Choose the existing SharePoint connection
Step 2 — Build the SharePoint API URL
To retrieve SharePoint pages, Content Hub requires a REST API URL pointing to the correct library.
2.1 Retrieve the Site Pages Library GUID
Netpresenter requires the GUID of the SharePoint list/library containing the pages.
In most cases, this is the Site Pages library.
Option A — Retrieve GUID via SharePoint UI (Recommended)
Open your SharePoint site
Go to: Site Contents → Site Pages
Click:⚙️ → Library settings
Check the browser URL. It contains:
...listedit.aspx?List=%7BGUID%7D
Example GUID:
3F2504E0-4F89-11D3-9A0C-0305E82C3301
Copy your GUID for the next step.
Option B — Retrieve GUID via PowerShell 7+ PnPModule (Optional)
Run:
Connect-PnPOnline -Url https://tenant.sharepoint.com/sites/yoursite -Interactive
Get-PnPList | Select Title, Id
Locate Site Pages and copy its ID.
2.2 Build the SharePoint REST API URL
Insert your Site Pages GUID into the URL below:
https://<tenant>.sharepoint.com/_api/Web/Lists(guid'<GUID>')/items?
$orderby=Created desc&
$top=5&
$filter=(PromotedState eq 2)&
$select=Title,CanvasContent1,Description,FirstPublishedDate,
EncodedAbsUrl,BannerImageUrl,ID
Example:
https://contoso.sharepoint.com/_api/Web/Lists(guid'3F2504E0-4F89-11D3-9A0C-0305E82C3301')/items?$orderby=Created desc&$top=5&$filter=(PromotedState eq 2)&$select=Title,CanvasContent1,Description,FirstPublishedDate,EncodedAbsUrl,BannerImageUrl,ID
Step 3 — Finalize the Configuration
3.1 Test the API URL
Before saving the External Source:
-
Paste the URL into your browser
-
Ensure you are logged in to SharePoint
A JSON response containing news pages confirms the URL is correct.
3.2 Save the External Source in Netpresenter
-
Return to Content Hub
-
Paste the REST API URL into the External Source URL field
-
View source to confirm the same JSON coming through
3.3 Update Interval
Set the update interval to 30 minutes
This ensures Content Hub checks regularly for new SharePoint pages.
3.4 Field Mapping (Automatic)
SharePoint External Sources use JSON Paths.
By default, Netpresenter loads the standard mappings automatically:
| Field | JSON Path |
|---|---|
| Title | $.value.*.Title |
| Description | $.value.*.Description |
| Body | $.value.*.CanvasContent1 |
| URL | $.value.*.EncodedAbsUrl |
| Banner Image | $.value.*.BannerImageUrl.Url |
| Publish Date | $.value.*.FirstPublishedDate |
No manual mapping is required unless custom fields are used.
3.5 Save External Source
The final step is to click Add New SharePoint
Optional — Expire Date Field
An Expire Date field is optional and must be created manually in SharePoint.
If not configured, Netpresenter applies the default expiry behavior from the Automation.
Step 4 — Create a Slide Automation in Netpresenter
To configure the SharePoint Automation, follow the instructions in the Automations Guide.
Troubleshooting — No Pages Visible
Incorrect Library GUID
If the GUID is wrong, SharePoint returns no results.
Fix: Re-check the Site Pages library settings URL.
Missing Permissions
If Sites.Read.All consent was not granted, SharePoint content cannot be retrieved.
Fix: Grant Admin Consent in Azure App permissions.
URL Returns Access Denied
The Azure App may not have access to the SharePoint site.
Fix: Verify the SharePoint connection and tenant permissions.
No News Pages Returned
Only published news pages are returned:
PromotedState eq 2
Fix: Ensure the site contains published News posts.
✅ Completed
SharePoint External Sources are now available in Netpresenter Content Hub.
Content Hub can retrieve and preview SharePoint News pages and use them in automations.