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

SomeDataDude's avatar
SomeDataDude
Advocate I
3 years ago

Hi lbendlin ,

 

Thanks for your reply. Which options do I have to modify te query privacy settings? Inline the token is not an option, because it is a refresh token. I don’t want to replace the token every time I refresh the data.

lbendlin's avatar
lbendlin
Super User
3 years ago

 

 

  • SomeDataDude's avatar
    SomeDataDude
    Advocate 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

     

  • SomeDataDude's avatar
    SomeDataDude
    Advocate I
    3 years ago

    Okay, thanks.

    That clears the error on Privacy Levels. Now I run into the error: We couldn’t authenticate with the credentials provided. Please try again.

     

    But if I run the token Inline, it runs fine. So, I think the M code is not good enough to passes the authentication. But I have no clue, what’s wrong.

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

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

  • SomeDataDude's avatar
    SomeDataDude
    Advocate I
    3 years ago

    Yes I did. In my current M code is it just one.