Timout on Credentials

Hi Jannat,

My solution in the end was to build pagination into my calls.

Depending on the call weight the external server might be timing you out.

This can be done by converting your get data request into a function and then calling the results of this function into another query.

For example:

Our function would be something like:

(page as number) as table =>
let
Source = Json.Document(Web.Contents("https://DOMAIN/",[RelativePath="[API CALL PATH]?_page=" & Number.ToText(page) & ""]))

My initial step is to call a single page model the data how I want it (expand/rename and create any custom columns etc) then update the above.

Add a new custom query with the following:

let
    AddFunctionCall=List.Generate(()=>[Page Number=0,Func=null], each (try _[Func])[HasError]=false, each [Page Number=_[Page Number]+1, Func=YOURFUNCTIONNAMEHERE([Page Number]+1)], each _[Func]),
    ConvertToTable = Table.FromList(AddFunctionCall, Splitter.SplitByNothing(), null, null),
    RemoveDemiRow = Table.Skip(ConvertToTable,1),

What this will do is call the function for each page in the output avoiding the timeout.