Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register 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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
83 | |
75 | |
64 | |
39 | |
34 |
User | Count |
---|---|
107 | |
56 | |
52 | |
48 | |
40 |