Forum Discussion
REST API POST Request works in Postman, Fails in Power Query
Hi Duftnich06
without the curly bracket like so:
Json.FromValue([searchID="customsearch_active_customers"])
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!
Hi Duftnich06 ,
great to hear 🙂
Did you realize that this was also my first answer 😉
The encoding is well above my head unfortunately.
I did, yes. Althought at that point, I wasn't aware of my encoding issue and so I was distracted by my original error!
Thanks again 😃