Forum Discussion

JBBaxter's avatar
JBBaxter
Frequent Visitor
7 years ago

Call Google Search Console API with Power Query (M) - Web.Contents( POST Problem)

Hi Guys,

 

i managed to work with googles oath2 in including a refresh of the access_token in Power Query (M), (what a pain to get the first token and the refresh token) made also my first requests via GET. 

::is working

let
    AccessTokenList = List.Buffer(api_token),
    access_token = AccessTokenList{0},
    AccessTokenHeader = "bearer " & access_token,
    GetJsonQuery = Json.Document(Web.Contents("https://www.googleapis.com/webmasters/v3/sites?&access_token=" & access_token))

in 
    GetJsonQuery

 

 

 

so now i tried to call the /searchAnalytics/ query wich works with post :

 

let
    JsonRecords = Text.FromBinary(Json.FromValue(Source)),
    JsonRequest = "{
  ""startDate"": ""2019-01-01"",
  ""endDate"": ""2019-02-01"",
}", 
    JsonContent = Text.ToBinary(JsonRequest),
    AccessTokenList = List.Buffer(api_token),
    access_token = AccessTokenList{0},
    AuthKey = "Bearer " & access_token,

    Response = Web.Contents("https://www.googleapis.com/webmasters/v3/sites/https%3A%2F%2Fwww.xxxxxxx.xxx/searchAnalytics/query", [Headers=[Authorization=AuthKey, ContentType="application/json", Accept="application/json"], Content=JsonContent]),
    JsonResponse = Json.Document(Response)
in
    JsonResponse

getting a bad request (400) - [auth header is working fine] already tested it, so there must be something wrong with the Header request aka Content=(body) or formating. Request body needs to have "startDate": "YYYY-MM-DD" and "endDate": "YYYY-MM-DD", 

 

Google reference:

https://developers.google.com/webmaster-tools/search-console-api-original/v3/searchanalytics/query

 

Any Idea?

 

Thanks

 

 

Need Help

3 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    JBBaxter ,

     

    This issue should be caused by invalid format of the query in body. How about use format like YYYY/MM/DD?

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • JBBaxter's avatar
      JBBaxter
      Frequent Visitor
      7 years ago

      Thanks for your reply, v-yuta-msft 

       

      I tested it:

      let
    body = "{ ""startDate"": ""2019/01/01"", ""endDate"": ""2019/02/01"" }", 
    AccessTokenList = List.Buffer(api_token),
    access_token = AccessTokenList{0},
    AuthKey = "Bearer " & access_token,
    url = "https://www.googleapis.com/webmasters/v3/sites/https%3A%2F%2Fwww.xxxxxxx.xxx/searchAnalytics/query",

    Response = Web.Contents(url, [Headers=[Authorization=AuthKey, ContentType="application/json", Accept="application/json"], Content=Text.ToBinary(body)]),
    JsonResponse = Json.Document(Response)
in
    JsonResponse

      Still gives me a 400

       

      any other ideas? maybe (WebMethod.Post or WebAction.Request)?

       

      Thx 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    JBBaxter , Did you solve this problem? I have a question, when you've created the API Application in google API console, did you use OAuth authentication (with client ID) or API Token? Thans