API

[Brrent]

Can I use the Fitbit with ArcGIS Pro, Office, MyChart, and Facebook?

[LZeeW]

Hello @Brrent and welcome to the Community.  I moved your post to the Web API forum.  It seems like a better fit based on your title.  Can you please add more details?

[Brrent]

Esri has a location analysis, if there a health tech service with most primary care physicians? I need to connect with an SQL on both Excel and ArcGIS to export the complete exercise, diet, and weight loss history for an analysis. Is there a way to get my Physician's I.T. department and an Esri health representative to join the forum to assist? I wanting to want to share some results with other diet programs. 

[GordonFitbit]

Hi @Brrent 

As long as those applications can implement OAuth2 and call the Fitbit Web API, you should be able to pull the data directly into those apps.  The response from these endpoints will be in json format

If you need to use SQL in these applications, then you would need to tool that calls the endpoints and stores the data into a relational data store.  Then, call SQL on the data.  We have an example of querying the Fitbit data from Google Sheets into a spreadsheet.  See https://dev.fitbit.com/build/reference/web-api/developer-guide/libraries-and-sample-code/#Sample-Cod....  You could try to implement something similar with MS Office Excel.  Then use the Excel ODBC driver to query the data out of the spreadsheet.