5 Replies Latest reply on Feb 2, 2019 11:01 PM by Sanford Whiteman

    How to connect excel with API?

    Ankit D

      I am trying to get the authentication token in excel and have used the following query:

       

      let

       

      mktoUrlStr = Excel.CurrentWorkbook(){[Name="REST_API_Authentication"]}[Content]{0}[URL],

      clientIdStr = Excel.CurrentWorkbook(){[Name="REST_API_Authentication"]}[Content]{0}[Client ID],

      clientSecretStr = Excel.CurrentWorkbook(){[Name="REST_API_Authentication"]}[Content]{0}[Client Secret],

       

      getAccessTokenUrl = mktoUrlStr & "/identity/oauth/token?grant_type=client_credentials&client_id=" & clientIdStr & "&client_secret=" & clientSecretStr,

      TokenJson = try Json.Document(Web.Contents(getAccessTokenUrl)) otherwise "Marketo REST API Authentication failed, please check your credentials",

       

       

      accessTokenStr = TokenJson [access_token]

       

      in

      accessTokenStr

       

      But everytime it throws an error

       

       

      What should I do to fix this?