Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
JBBaxter
Frequent Visitor

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

 

 

3 REPLIES 3
Anonymous
Not applicable

@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

v-yuta-msft
Community Support
Community Support

@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.

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 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.