Forum Discussion

Jojo197's avatar
Jojo197
Helper I
3 years ago
Solved

Sharepoint Link api skipToken not working

I have the following Query to get data from a sharepoint list. Currently all the values are manual and I am only viewing and skipping a small number of rows.    let Source = Json.Document(Web....
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Web.Contents does not have easy mechanism to capture the User Credentials to generate a token. You would need to develop a custom connector or a function to call for the token. 

 

Instead, you could have switched to using the OData.Feed function instead of web contents.  This will prompt for user credentials. 

 

But I would not recommend because the new SharePoint.Tables approach is optimised for better performance and would require less additional transformations (e.g. renaming and data type conversions).

john_colvin's avatar
john_colvin
Frequent Visitor
3 years ago

Anonymous 

 

I tried the Web.Contents approach because the 2.0 implementation of the SharePoint connector is giving me a 500 internal server error. I have a list where the 2.0 implementation broke when the list went over 5000 items. I have other SP lists over 20000 items, and the 2.0 implementation is working fine. Any ideas? Hair is falling out over here.