Copy this code and after you create a blank query goto advance editor and replace the default code with this one.Remember to replace the host name.
Then close and apply. It would work
let
Pagination = List.Skip(List.Generate( () => [WebCall=[result = {0}], Page = 0, Counter=0], // Start Value
each List.Count([WebCall][result])>0 or [Counter] =0, // Condition under which the next execution will happen
each [ WebCall = Json.Document(Web.Contents(" https://<host>.com/api/now/table/problem?&sysparm_limit=1000&sysparm_offset=1",
[Query=[sysparm_offset =Text.From([Counter])]])),
Page = [Page]+1,
Counter = [Counter]+1000// internal counter
]
) ,1),
#"Converted to Table" = Table.FromList(Pagination, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"WebCall", "Page", "Counter"}, {"WebCall", "Page", "Counter"}),
#"Expanded WebCall" = Table.ExpandRecordColumn(#"Expanded Column1", "WebCall", {"result"}, {"result"}),
#"Expanded result" = Table.ExpandListColumn(#"Expanded WebCall", "result")
in
#"Expanded result"
