Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Google My Business API

Hey,

 

is there anyone who successfully connected Power BI with Google My Business API?

 

Any help is appreciated.

Thanks.

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hey,

       

      thanks for reply. According to the post you provided, i tried this query:

      let
       authKey = "Basic " & Binary.ToText(Text.ToBinary("<client_id>:<client_secret>"),0),
       url = "https://oauth2.googleapis.com/token",
       GetJson = Web.Contents(url,
           [
               Headers = [#"Authorization"=authKey,
                          #"Content-Type"="application/x-www-form-urlencoded;charset=UTF-8"],
               Content = Text.ToBinary("grant_type=client_credentials") 
           ]
       ),
       FormatAsJson = Json.Document(GetJson),
       AccessToken = FormatAsJson[access_token],
       AccessTokenHeader = "bearer " & AccessToken,
       GetJsonQuery = Web.Contents("https://mybusiness.googleapis.com/v4/XXXXXXXXXXXXX",
           [
               Headers = [#"Authorization"=AccessTokenHeader]
           ]
       ),
       FormatAsJsonQuery = Json.Document(GetJsonQuery),
       NavigateToStatuses = FormatAsJsonQuery[statuses],
       TableFromList = Table.FromList(NavigateToStatuses, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
       ExpandColumn = Table.ExpandRecordColumn(TableFromList, "Column1", {"metadata", "created_at", "id", "id_str", "text", "source", "truncated", "in_reply_to_status_id", "in_reply_to_status_id_str", "in_reply_to_user_id", "in_reply_to_user_id_str", "in_reply_to_screen_name", "user", "geo", "coordinates", "place", "contributors", "is_quote_status", "retweet_count", "favorite_count", "entities", "favorited", "retweeted", "lang", "possibly_sensitive", "quoted_status_id", "quoted_status_id_str", "quoted_status"}, {"Column1.metadata", "Column1.created_at", "Column1.id", "Column1.id_str", "Column1.text", "Column1.source", "Column1.truncated", "Column1.in_reply_to_status_id", "Column1.in_reply_to_status_id_str", "Column1.in_reply_to_user_id", "Column1.in_reply_to_user_id_str", "Column1.in_reply_to_screen_name", "Column1.user", "Column1.geo", "Column1.coordinates", "Column1.place", "Column1.contributors", "Column1.is_quote_status", "Column1.retweet_count", "Column1.favorite_count", "Column1.entities", "Column1.favorited", "Column1.retweeted", "Column1.lang", "Column1.possibly_sensitive", "Column1.quoted_status_id", "Column1.quoted_status_id_str", "Column1.quoted_status"})
      in
       ExpandColumn

       

      I keep getting this error: 

       

      DataSource.Error: Web.Contents failed to get contents from 'https://oauth2.googleapis.com/token' (400): Bad Request
      Details:
      DataSourceKind=Web
      DataSourcePath=https://oauth2.googleapis.com/token
      Url=https://oauth2.googleapis.com/token

       

      Connect to GMB API with OAuth 2.0. Playground and Postman works correctly, but i couldn't manage to connect with Power Bi.

       

      Is there something missing in the query?

       

      Thanks.