Forum Discussion

vrossouw's avatar
vrossouw
Icon for Helper III rankHelper III
7 years ago
Solved

FITBIT - direct connection

Hi, any idea if it is possible to connect directly with your FITBIT charge 3 data through Power BI? I can see there is a download data option, but I want to connect directly to the data? Thanks
Need Help
  • jeffshieldsdev's avatar
    jeffshieldsdev
    7 years ago

    Not possible OOTB, but Fitbit does have an API you can connect to: https://dev.fitbit.com/build/reference/web-api/

     

    You have to create a new app and authroize it to get a Bearer token you can use in Power Query:

     

    let
    URL = "https://api.fitbit.com/1/user/-/activities/date/2018-12-31.json", 
    Options = [
        Headers = [
            Authorization = "Bearer token"
        ]
    ],
    Source = Json.Document(Web.Contents(URL, Options))
in
    Source
jeffshieldsdev's avatar
jeffshieldsdev
Icon for Solution Sage rankSolution Sage
7 years ago

Not possible OOTB, but Fitbit does have an API you can connect to: https://dev.fitbit.com/build/reference/web-api/

 

You have to create a new app and authroize it to get a Bearer token you can use in Power Query:

 

let
    URL = "https://api.fitbit.com/1/user/-/activities/date/2018-12-31.json", 
    Options = [
        Headers = [
            Authorization = "Bearer token"
        ]
    ],
    Source = Json.Document(Web.Contents(URL, Options))
in
    Source
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello jeffshieldsdev 

     

    I'm trying to create a custom conector to fitbit right now and totally missing the boat on understanding, can you help me?

     

    So, I want to create a custom connector, I go into the custom connector wizard and start from blank, it asks for a client key/secret so I go to the fitbit api site to register for access.  In their app registration system they ask you for a Callback URL, you need this in order to gain access to the key/secret.  However, my understanding is that this Callback URL is the same thing as a the "Redirect Url" provided in the OAuth2.0 wizard page of the custom connector creater, for powerapps to generate this URL is requires the key/secret.  This means that I will never be able to apply to gain access to the API because I don't have a Callback URL.

     

    What am I missing here?

     

    Cheers,

    A Cold Canadian