topic Re: How can I call api with post method in Power BI? in Developer

How can I call api with post method in Power BI?

LeonLiang — Wed, 11 Aug 2021 10:20:12 GMT

Hi Folks,

Suppose I have an api, https://testurl.com/api/getOrderList, how can I use it with post method and my basic auth information in Power BI to get my order list data?

Thanks in advance!

Leon

Re: How can I call api with post method in Power BI?

V-lianl-msft — Fri, 13 Aug 2021 02:13:57 GMT

Hi LeonLiang ,

If you want to make a POST request to a web service through Power Query, you have to add the relevant data in the “Content”-parameter of the query . Please refer to:

web-services-and-post-requests-in-power-query

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: How can I call api with post method in Power BI?

LeonLiang — Wed, 18 Aug 2021 11:33:39 GMT

Hi Liang,

I didn't vote this as a solution. How come it became a solution?

I tried to format my request as following:

let
start_date = Number.From(Date.From("01-01-2021")),

// or start_date = "01-01-2021"

// or start_date = "2021-01-01"
PostContents = start_date,
Source = Json.Document(Web.Contents("https://testurl.com/api/getOrderList"), [Content=Text.ToBinary(PostContents)])
in
Source

It tells me the following error

Not sure how to solve this problem?

Leon

Re: How can I call api with post method in Power BI?

V-lianl-msft — Thu, 19 Aug 2021 05:01:36 GMT

Hi LeonLiang ,

In your code, start_date is a number. You need to convert it into text to see if it works

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: How can I call api with post method in Power BI?

LeonLiang — Wed, 01 Sep 2021 08:36:21 GMT

Hi Liang,

I already tried bunch of convert methods whereas they all failed. Do you have a straight forward solution?

Cheers

Re: How can I call api with post method in Power BI?

LeonLiang — Wed, 22 Sep 2021 10:45:51 GMT

Any updates?