Forum Discussion
Solved
Channel Advisor API Connection with auth key creation
Afternoon All! Gonna be honest i'm racking my **bleep** brains out with this one but i'm getting no where. I tested a rest function in Postman and all works brilliant returning the data i nee...
Great! Cheers!
The response is in Json format, so you just need to add a step at the end of the custom function to extract access_token value. Don't forget to add a comma at the end of previous response step.
..................... response = Json.Document(Web.Contents(.......................)), access_token = response[access_token] in access_tokenJing
Were you able to accomplish the first part in Power Query (ie getting the refresh key) ?
Unfortuntely not I've been trying a couple variations of Jing's code above, but unfortunately not getting far. i'm sure its me but unfamilar with post requests so sharp learning curve at the moment 😄