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
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
@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
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
109 | |
108 | |
93 | |
61 |
User | Count |
---|---|
171 | |
139 | |
133 | |
102 | |
86 |