Skip to main content

Extract Data from SharePoint Lists

  • February 13, 2025
  • 4 replies
  • 151 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?

4 replies

  • Participant
  • 12 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


  • Starter
  • 4 replies
  • July 10, 2025

Hi ​@Christian Hauggaard 
I see now several lookupId fields in the data with corresponding column names like the columns of the sharepoint list. But how can I get the values these ID's correspond to? 


Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • 1100 replies
  • July 14, 2025

Hi ​@Mies 

I made my own setup.

The result came like so.

 

I could not control the names of the fields, only the order. So my fields used for table flattening was just that.

I then gave the fields proper names similar to what I have in my list once it came into a table.

I could also name it here, but the issue is that the Graph API doesn’t return proper names.


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