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 ,
Have you tried the first answer from: https://stackoverflow.com/questions/62758873/power-bi-query-connecting-to-api-that-uses-hmac-authentication
?
IMO it opens an AWSOME door to use javascript libraries from PowerQuery - didn't really have many problems for this great solution so far.
Postman has builtin the crypto-js javascript lib - this is why postman works.
Please tell us if it worked 😊 and upvote it on stackoverflow also.