Forum Discussion

TrysHisBest's avatar
TrysHisBest
New Member
4 years ago
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...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    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_token

     

    Jing

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Did you notice there are two spaces after "Bearer"  ?

SomeDataDude's avatar
SomeDataDude
Icon for Advocate I rankAdvocate I
3 years ago

Thanks for the trigger around Bearer. I put the Bearer &function in the other query. Now it is working.

 

Function:

() =>
let
content = "{
            ""mode"" : ""raw"",
            ""client_id"": ""************",
            ""client_secret"": ""*********""
}",

Source = Json.Document(Web.Contents("url_refreshtoken",
                       [Headers=[#"Authorization"="******", 
                                 #"accept" = "text/plain", 
                                 #"Content-Type"="application/json"], 
                                  
                        ManualStatusHandling = {404, 400},

Content=Text.ToBinary(content)])),
access_token ="Bearer " &Source[access_token]

in
access_token

 

Query:

let
    Source = Json.Document(Web.Contents("search_url",
                       [Headers=[#"Authorization"= GetAccessToken(), 
                                 #"accept" = "text/plain", 
                                 #"Content-Type"="application/json"], 
                                  
                        ManualStatusHandling = {404, 400}]))

in
    Source