PatrickHenry
New Member
- Joined
- Dec 12, 2017
- Messages
- 4
[FONT="]Hello All,[/FONT]
[FONT="] [/FONT]
[FONT="]I am trying to connect my Marketo data to Excel. I have a custom service, client secret, and client ID. I set an anonymous credential setting because I did not know what else to select. Other options (Windows, Basic, Web API, Org Account) but those all asked for things out side of the client id, secret, REST API Endpoint URL.[/FONT]
[FONT="] [/FONT]
[FONT="]I keep getting this ERROR -> Expression.Error: The field 'access_token' of the record wasn't found.
[/FONT]
[FONT="]Any help with this error will be Greatly Appreciated. [/FONT]
[FONT="] [/FONT]
[FONT="]Query[/FONT]
<tbody style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit; margin: 0px; outline: 0px; padding: 0px;">
</tbody>
[FONT="] [/FONT]
[FONT="]I am trying to connect my Marketo data to Excel. I have a custom service, client secret, and client ID. I set an anonymous credential setting because I did not know what else to select. Other options (Windows, Basic, Web API, Org Account) but those all asked for things out side of the client id, secret, REST API Endpoint URL.[/FONT]
[FONT="] [/FONT]
[FONT="]I keep getting this ERROR -> Expression.Error: The field 'access_token' of the record wasn't found.
[/FONT]
[FONT="]Any help with this error will be Greatly Appreciated. [/FONT]
[FONT="] [/FONT]
[FONT="]Query[/FONT]
4 5 6 7 8 9 10 11 12 13 14 15 | let // Get url and credentials from config worksheet - Table REST_API_Authentication 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], // Calling Marketo API Get Access Token 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", // Parsing access token accessTokenStr = TokenJson [access_token] in accessTokenStr |
<tbody style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit; margin: 0px; outline: 0px; padding: 0px;">
</tbody>