Marketo Connection Power Query Expression.Error: The field 'access_token' of the record wasn't found

[PatrickHenry]

[FONT=&quot]Hello All,[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]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=&quot] [/FONT]
[FONT=&quot]I keep getting this ERROR -> Expression.Error: The field 'access_token' of the record wasn't found.

[/FONT]
[FONT=&quot]Any help with this error will be Greatly Appreciated. [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Query[/FONT]
[TABLE="width: 924"]
<tbody style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit; margin: 0px; outline: 0px; padding: 0px;">[TR]
[TD]4
5
6
7
8
9
10
11
12
13
14
15

[/TD]
[TD]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

[/TD]
[/TR]
</tbody>[/TABLE]

 

[PatrickHenry]

Never Mind Solved