Forum Discussion

mschoenhub's avatar
mschoenhub
Frequent Visitor
3 years ago
Solved

Cannot apply operator & to types Text and Function

Dear all,  I am trying to use a bearer token which I get from a function in a query. Function:    () => let // Get the API Token api_url = "https://api.xxxxxxx.com", token_path = "/o...
Need Help
  • ImkeF's avatar
    ImkeF
    3 years ago

    Ha mschoenhub ,
    that was a tricky one 🙂
    In the function for the token, you are not returning the last step.
    Please change it to this:

    () =>
let
    // Get the API Token
    api_url = "https://api.xxxxxxx.com",
    token_path = "/oauth2/access_token",
    ClientID = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx", 
    Secret = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx", 

    EncodedCredentials = "Basic " & Binary.ToText(Text.ToBinary(ClientID & ":" & Secret), BinaryEncoding.Base64),

    Token_Response = Json.Document(Web.Contents(api_url,
    [
        RelativePath = token_path,
        Headers = [#"Content-Type"="application/x-www-form-urlencoded",#"Authorization"=EncodedCredentials],
        Content=Text.ToBinary("grant_type=client_credentials")
    ]
    )
    ),

    // Get the token from the API response
    token = Token_Response[access_token]

in
   token
ImkeF's avatar
ImkeF
Community Champion
3 years ago

Hi mschoenhub ,
you have to call the function (although it doesn't have any arguments) like so:

let api_url = "https://api.xxxxxx.com",

path = "/data/v2/libraryEntries",

fields = "all",

Data = Json.Document(Web.Contents(api_url,

[ RelativePath = path,

Headers = [#"Authorization"="Bearer " & #"GET Access Token"(),

#"Content-Type"="application/json"] ] )),

#"Converted to Table" = Record.ToTable(Data), Value = #"Converted to Table"{2}[Value],

#"Converted to Table1" = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error),

#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table1", "Column1", {"id", "questions", "answer", "languageCode", "creator", "lastUpdatedBy", "createdDate", "lastUpdatedDate", "lastReviewedDate", "lastReviewedBy", "libraryEntryOwner", "inlineImages", "status", "tags", "scores", "location", "attachmentCount"}, {"id", "questions", "answer", "languageCode", "creator", "lastUpdatedBy", "createdDate", "lastUpdatedDate", "lastReviewedDate", "lastReviewedBy", "libraryEntryOwner", "inlineImages", "status", "tags", "scores", "location", "attachmentCount"}), #"Expanded lastReviewedBy" = Table.ExpandRecordColumn(#"Expanded Column1", "lastReviewedBy", {"id", "name"}, {"id.1", "name"})

in

#"Expanded lastReviewedBy"

 

mschoenhub's avatar
mschoenhub
Frequent Visitor
3 years ago

Thank you ImkeF, 

it looks like I am getting back the values from the function now but formatting still is an issue: 

 

 

 

 

 

 

 

I got that from this video and it looked so easy there.  https://youtu.be/2RZkc_qrV1g?t=782

Kind regards, Max