forumsple.blogg.se

it has no syntax errors however it doesn't work and I get the following error: Table = Table.FromList(Entities, Splitter.SplitByNothing(), null, null, ExtraValues.Error) Pages = List.Transform(PageIndices, each GetPage(_)), PageCount = Number.RoundUp(Entit圜ount / EntitiesPerPage), Top = "$top=" & Text.From(EntitiesPerPage),Įntit圜ount = List.Max(),

Let Skip = "$skip=" & Text.From(Index * EntitiesPerPage), Let Url = BaseUrl & "$count=true&$top=0", This led me to this article where I'd borrowed, ammended and tested the code: Some reading tells me I need to paginate my results by first indexing how many pages of results there are and combine them one at a time? however this only returns the first 100 results of approximately 6500 expected rows.

#"Converted to Table" = Table.FromList(Result, Splitter.SplitByNothing(), null, null, ExtraValues.Error) ,RelativePath = "servicedesk/tickets/"])), Source = Json.Document(Web.Contents(url,[ I've successfully connected to a REST API using the below code:

Hoping you can help as I'm well and truly stuck.