API request returns blank while trying postman returns data

[freidav1984]

Hi All!

I have the following API request issue in Power Query. The endpoint expects post method. 

let
    url = "https:/link/link/link",
    content = "{
        ""fromDate"" : ""2023-09-01"",
        ""toDate"" : ""2023-11-30"",
        ""accountantStatus"" : ""1"",
        ""dateType"" : ""payment_deadline""
        }",
    headers = [#"x-api-key"="xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx"],
    
    response = Web.Contents(url, [Headers = headers, Content=Text.ToBinary(content)])
    
in
    response

 This request returns a json content. But when I am trying to extract the json formatted data, I get a blank list.

I also tried in postman the same request, it works, and I am getting the proper dataset. In Postman, the result content-type is application/json;charset utf-8, and the result is a valid json format. Does anyone has an idea what could go wrong here?

Other API request with the same method and content data returns data without any problem. But there the content-type is only application/json. Could this content-type difference be a problem? 

Any workarounds?

I appreciate any help!

David

[lbendlin]

try specifying application/json in the Accept  header section