Skip to main content
To homepage To homepage

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

 

 

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?

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

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? 

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


Terms and ConditionsCookie settings