POST Request with REST API

[shuhn1229]

Hi all,

I am working with a REST API that sends in POST. I am using the code below, and I am able to refresh in desktop client after about 20 minutes. However, when I perform schedule refresh I get the following error: "The underlying connection was closed: The connection was closed unexpectedly". It seems like the cloud client is "giving up too easily". I am using a datagateway.

let
    Source = let
    Source = let
 url = "https://url.com",
    body = "{""id"": ""XXX""               }",
    Source = Json.Document(Web.Contents(url, [Timeout= #duration(0, 1, 0, 0),
        Headers = [#"Authorization"="Basic XXXX", #"Content-Type"="application/json", #"Connection" = "keep-alive"],
        Content = Text.ToBinary(body)
    ]))

The API has a lag before data is sent back for large queries. I am wondering if there is a way to keep the connection open in my mQuery code. I already tried adjusting the timeout with no luck.

[amitchandak]

@shuhn1229 , refer if this can help

https://eriksvensen.wordpress.com/2014/09/15/specifying-json-query-in-power-query-example-statistics...

https://community.powerbi.com/t5/Power-Query/Getting-Data-From-POST-API-with-JSON-Body/td-p/1847021

https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-i...

[shuhn1229]

I resolved this by pre-caching the query. It has something to do with the fact that if the cloud refresh isn't recieving a response, it will kill the connection after about 6 minutes (time out does not solve this). Meanwhile, if the query is preloaded, even if its large, cloud refresh works. I took a look at those sources, I didn't see anything applicable but I do appreicate your help. I'm leaving this open in case anyone ever solves it.