Export Data to Sql.

[Hrc-]

Hello,

How do i combine and export data collected from multiple fitbit sources(Users) into a sql database using an API. Any leads will be highly appreciated.

Thanks.

[Gordon-C]

Hi @Hrc- 

My apologies for the delay.   I'd recommend using the Web APIs to retrieve the user data.   See Web API Documentation.  Each endpoint is going to provide you data for a single user.   You will not be able to combine user data through the endpoint execution.   The response is going to be presented in JSON format.   I believe some databases can read and parse JSON.   If you want a generic solution, build a service that reads the JSON string and parses out the data values.   I know there are lots of examples in Java and I've seen some for other languages.   I'd probably reference the user id (or a mapping of the user id to a unique value ) as the key value in your table.

Gordon

[SunsetRunner]

I think I found something what you may find useful: https://github.com/DataScienceUNIVR/fitbit_api_database The app pulls data from API and saves it to the database.