Forum Discussion

Duftnich06's avatar
Duftnich06
Regular Visitor
3 years ago
Solved

REST API POST Request works in Postman, Fails in Power Query

I have an REST API that when I send a POST request via Postman, it works successfully, but refuses to work when sending via Power Query, M Code below (sensitive details omitted):       let u...
Need Help
  • ImkeF's avatar
    ImkeF
    3 years ago

    Hi Duftnich06 
    without the curly bracket like so:


    Json.FromValue([searchID="customsearch_active_customers"])

     

Duftnich06's avatar
Duftnich06
Regular Visitor
3 years ago

Hi ImkeF 
Thanks for coming back to me, sadly I get the below response:

This is the same message I recieved when I tried my other 3 solutions.

Is this an Azure/Power BI issue or does it reside with my API, it's not a very helpful error message ðŸ˜‚

 

Edit:
When I force the 'Close and Load' option, this message is returned: