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

[LeonLiang]

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

[V-lianl-msft]

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.

[LeonLiang]

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

[V-lianl-msft]

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.

[LeonLiang]

Any updates?

[LeonLiang]

Hi Liang,

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

Cheers