Skip to main content

Extract Data from SharePoint Lists

  • February 13, 2025
  • 2 replies
  • 108 views

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Prerequisites

Create an Azure App Registration

The App Registration should use the Microsoft Graph API with the following permissions:

Finding the List ID

Use Postman to find the Site ID. Use the Site ID to find the List ID. You can find these by using Postman and by looking at the Graph API collection Graph Fork. You can use the app to connect to this and locate the SharePoint folder under Application. In there you have two requests, https://graph.microsoft.com/v1.0/sites and https://graph.microsoft.com/v1.0/sites/{{SiteID}}/lists. Use sites to find the site ID and use the SiteID to find the List ID. You can also find the ListID by navigating to the SharePoint  list and then clicking List settings and then copying the ListID from the URL

 

Use the TimeXtender REST data source connection

Connection Settings

Use the following Base URL (where {{SiteID}} is the Site ID found in Postman):

https://graph.microsoft.com/v1.0/sites/{{SiteID}}/lists

Endpoints

Create the endpoint using the following path (where {{ListID}} is the List ID found in Postman). If you have more than one SharePoint List, then create an Endpoint for each one.

/{{ListID}}/items?expand=fields

Use the TimeXtender OData source connection

Connection Settings

Use the following Base URL (where {{SiteID}} is the Site ID found in Postman):

https://graph.microsoft.com/v1.0/sites/{{SiteID}}/lists

Endpoints

Create the endpoint using the following path (where {{ListID}} is the List ID found in Postman). If you have more than one SharePoint List then create an Endpoint for each one.

/{{ListID}}/items?expand=fields

 

 

Did this topic help you find an answer to your question?

2 replies

  • Participant
  • 11 replies
  • April 30, 2025

Hi ​@Christian Hauggaard 

Thank you for this manual. Unfortunately this just doesn't seem to work.
It gives me several 401 errors like: “Response status code does not indicate success: 401 (). System.Net.Http.HttpRequestException: Response status code does not indicate success: 401 (). at”

We've tried several authentication steps, but all without succes. 

Any thoughts on how to fix this error?


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

@r.miltenburg please submit a support ticket by emailing support@timextender.com. Please include description and screenshots of your settings and current configuration


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings