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.Contents("http://<tenant>.sharepoint.com/sites/<directory>/_api/web/lists/GetByTitle('<name>')/items?$skiptoken=Paged=TRUE%26p_ID=5&$top=10&$select=Id",[Headers=[Accept="application/json"]])),
    value = Source[value],
    #"Converted to Table" = Table.FromList(value, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"Id"},{"ID"})
in
    #"Expanded Column1"

 

When changing skiptoken=Paged=TRUE%26p_ID= between 0 and 5, nothing changes in the output; it still shows the first 10 rows of data. I found this code on various websites and am fairly certain I have copied it exactly so I am unsure why the skiptoken part is not working.

 

Thanks in advance

 

The solution in this page contains the video to the code I am using:

https://community.powerbi.com/t5/Desktop/SharePoint-list-query-alternative-or-optimization/m-p/1575109/highlight/true#M640656

 

 

 

Need Help

4 Replies

    • Jojo197's avatar
      Jojo197
      Helper I
      3 years ago

      Thank you, this did what I needed. Is there a reason why the skip token wasn't working with what I was doing?

      • 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).