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 
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 your help on this, this is the solution to my missing search id.

I believe my next issue is how to encode the HMAC-SHA256 signature for each refresh of the query, i.e. pass a dynamic unix timestamp, dynamic nonce and then encode it with keys etc to generate a valid signature, hence the 'access is forbidden' response. I can do the timestamp and nonce in M code, but the encoding of the signature I can't figure out, so my theory is I need to use Power Automate...question for another board.

Many thanks!