Forum Discussion

jitpbi's avatar
jitpbi
Icon for Post Patron rankPost Patron
5 years ago
Solved

add timeout in advanced editor

Hi,   I am trying to add timeout ([Timeout=#duration(0,2,0,0)]) to the API to get data from a web source but somehow i am not able to do it succesfully.  Please suggest how to add [Timeout=#durati...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi jitpbi,

    As official document mention, the 'timeout' property should be an optional parameter that host in the same level as 'relativepath' and 'header'.

    Web.Contents 
    I think you can try to add a comma after the 'query' and append it with the 'timeout' property.

    let
    rooturl = "https:/xxxx.xxxx.com/",
    authKey = "xxxxx",
    Source =
        Web.Contents(
            rooturl,
            [
                Headers = [
                    #"Authorization" = authKey,
                    #"Content-Type" = "application/json"
                ],
                RelativePath = "xxx/xxx/xxx",
                Query = [
                    startdate = xxxx,
                    enddate = xxxx
                ],
                Timeout = #duration(0, 0, 35, 0)
            ]
        )
in
    Source

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi jitpbi 

For my SQL database below is the M

Source = Sql.Databases("Server123", [CommandTimeout=#duration(0, 0, 35, 0)])

code which is used.

 

  • jitpbi's avatar
    jitpbi
    Icon for Post Patron rankPost Patron
    5 years ago

    Thanks Anonymous  for the comment. I can add the timeout in single line URL and it works. Actually long single url doesn't work in refresh so i need to break the url in small parts, like in my first post, where i am not able to add timeout properly.

    thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi jitpbi,

      As official document mention, the 'timeout' property should be an optional parameter that host in the same level as 'relativepath' and 'header'.

      Web.Contents 
      I think you can try to add a comma after the 'query' and append it with the 'timeout' property.

      let
    rooturl = "https:/xxxx.xxxx.com/",
    authKey = "xxxxx",
    Source =
        Web.Contents(
            rooturl,
            [
                Headers = [
                    #"Authorization" = authKey,
                    #"Content-Type" = "application/json"
                ],
                RelativePath = "xxx/xxx/xxx",
                Query = [
                    startdate = xxxx,
                    enddate = xxxx
                ],
                Timeout = #duration(0, 0, 35, 0)
            ]
        )
in
    Source

      Regards,

      Xiaoxin Sheng