how to run POST request

[preetisb15]

Dear community,

I am trying to run a POST request to translate it to a GET request using M query

my POST call would look like this:

https://xxx.zz/report/export?filterType=jqlfilter&jqlFilterID=123456&columnsby=statusduration&fields...

How can I translate this to a GET request using MQuery?

[lbendlin]

Your example is not a POST, it is already a GET.  For POST you need to specify a payload in the header, not in the URL.

What do you need the POST for? Authentication?

[preetisb15]

Hi @lbendlin 

I am trying to run an asynchronous file export API.

[lbendlin]

Power Query has no built in event handling. Asynchronous is not possible.

[preetisb15]

Basically, I want to call a REST endpoint to start the export, call another REST endpoint to track its progress and (when completed) call yet another REST endpoint to download the file.

I am able to do this using POSTMAN 

[lbendlin · Accepted solution]

That's not asynchronous. That's just looping (waiting for something to complete rendering)

While you may be able to do this in Power BI  you should really look into Power Automate instead.