Forum Discussion

preetisb15's avatar
preetisb15
Frequent Visitor
6 years ago
Solved

how to run POST request

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=issuetype&fields=summary&fields=assignee&fields=customfield_10101&fields=customfield_11865&fields=customfield_11866&fields=customfield_10600&fields=customfield_11300&fields=customfield_11802&&fields=customfield_11000&fields=customfield_11885&fields=customfield_10211&fields=status&fields=created&fields=duedate&fields=resolutiondate&fields=customfield_10602&fields=customfield_11861&fields=customfield_11916&fields=customfield_11925&fields=customfield_11862&fields=customfield_11863&fields=customfield_11841&fields=customfield_11929&fields=customfield_11842&fields=customfield_11894&fields=customfield_11891&fields=customfield_11893&fields=customfield_11892&fields=customfield_11842&fields=customfield_11844&calendar=normalhours&outputtype=csv 

 

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

 

 

 

 

Need Help
  • lbendlin's avatar
    lbendlin
    6 years ago

    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.

5 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

    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?

      • lbendlin's avatar
        lbendlin
        Super User
        6 years ago

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