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"])

     

ImkeF's avatar
ImkeF
Community Champion
3 years ago

Hi Duftnich06 ,
I thought the previous error message was: "No searchID specified"?

Duftnich06's avatar
Duftnich06
Regular Visitor
3 years ago

Hi ImkeF 

 

Correct, that's the final error I landed on, but I mentioned in my original post that I tried 3 alternate solutions all resulting in 'Access Forbidden'.
As the below line resulted in the API calling back, I stuck with it as the closest solution. However, you're right it doesn't seem to think I'm passing a search id...

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

I get the feeling it is an issue with the API itself...what do you think?