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:




      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]





      But everytime it throws an error



      What should I do to fix this?