Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
try specifying application/json in the Accept header section