25:null 26:["$","title",null,{"children":"Fitbit | Nicolas Laurent | Observable"}] 2b:T804,md `# Setup ## Fitbit - Create a Fitbit dev account. - Go to https://dev.fitbit.com/apps and create a new app. - The type of application should be "client" - The callback URL should be the URL of your work of this notebook. - Read-only access is enough. - In your ObservableHQ settings, create a secret calling \`FITBIT_OAUTH_ID\` and fill it with the "OAuth 2.0 Client ID" for your app. ## Google Sheets - Go to https://console.developers.google.com/apis/ and enable the Google Sheets API. - Go to https://console.developers.google.com/apis/credentials and create new OAuth client ID credentials. - In your ObservableHQ settings, create a secret calling \`GCLIENT_ID\` and fill it with the client ID you just created. - On the Google developer console, create a new API key. You can set restrictions if you wish (HTTP referrers / Google Sheets API). - In your ObservableHQ settings, create a secret calling \`GAPI_KEY\` and fill it with the API key you just created. - In Google Sheets, create a new spreadsheet and copy its [Spreadsheet ID](https://developers.google.com/sheets/api/guides/concepts/#spreadsheet_id) (which appears in the URL) — copy it into the \`SPREADSHEET_ID\` variable of this notebook. ## Configure The Notebook & Export - Set the \`START_DATE\` and \`END_DATE\` variables of this notebook to the desired start/end dates for the data you wish to export to Google Sheets. Currently, these two dates must not be more than 31 days apart. A change to the \`weight_range\` function could fix this, by splitting a bigger range into at-most-31-days chunks, making multiple API request and stitching their results together. - Sign in to Google using the button in the "Trigger" section. - Sign in to Fitbit using the button in the "Trigger" section (this will reload the page and append an access token to the URL). - Press the "Write Sheet!" button to export data to your spreadsheet. - If successful, a popup will appear. - Note that currently, errors are only logged in the Javascript developer console. `2c:T89b,write_sheet = async () => { const first_column = `${SHEET_NAME}!A:F` const start_date = parse_date(START_DATE) const end_date = parse_date(END_DATE) if (!start_date.isBefore(end_date)) throw "Non sequential request date range." const calories_in = await calories_in_range(START_DATE, END_DATE) const calories_out = await calories_out_range(START_DATE, END_DATE) const weight = await weight_range(START_DATE, END_DATE) const value_map = {} for (const it of calories_in) value_map[it.dateTime] = { calories_in: it.value } for (const it of calories_out) value_map[it.dateTime].calories_out = it.value for (const it of weight) value_map[it.date].weight = it.weight const values = [] for (const date in value_map) { const data = value_map[date] values.push([date, data.calories_in, data.calories_out, data.weight]) } const style_requests = [] const BLACK = { red: 0, green: 0, blue: 0, alpha: 1 } for (let i = 0; i < values.length; ++i) { const row = values[i] row.push(`=B${i+1}-C${i+1}`) // diff = calories_in - calories_out const floor = Math.max(1, i-1) row.push(`=average(D${floor}:D${i+3})`) // rolling smoothed average over 5 cells // black medium borders below each sunday row // NOTE: these borders are never cleared when the sheet is updated! if (parse_date(row[0]).day() == 0) style_requests.push({ updateBorders: { range: { sheetId: 0, startRowIndex: i, endRowIndex: i+1 }, bottom: { style: "SOLID_MEDIUM", color: BLACK } } }) } const r1 = await awaitify_req(gapi.client.sheets.spreadsheets.values.update({ spreadsheetId: SPREADSHEET_ID, range: first_column, valueInputOption: "USER_ENTERED", resource: { majorDimension: "ROWS", values: values } })) // console.log(r1) const r2 = await awaitify_req(gapi.client.sheets.spreadsheets.batchUpdate({ spreadsheetId: SPREADSHEET_ID, resource: {requests: style_requests} })) // console.log(r2) }2d:T790,viewof gapi = { // https://developers.google.com/sheets/api/quickstart/js function google_signin() { gapi.auth2.getAuthInstance().signIn(); } function google_signout() { gapi.auth2.getAuthInstance().signOut(); } function update_signin_status (signed_in) { // https://talk.observablehq.com/t/d3-to-populate-buttons-w-onclick-function/1640 if (signed_in) { const button = html `` button.onclick = google_signout viewof google_signin_status.innerHTML = "Signed into Google" viewof google_signin_status.appendChild(html` `) viewof google_signin_status.appendChild(button) } else { const button = html `` button.onclick = google_signin viewof google_signin_status.innerHTML = '' viewof google_signin_status.appendChild(button) } } // https://talk.observablehq.com/t/importing-googleapis/2190 const gapi = await require("https://apis.google.com/js/api.js").catch(() => window.gapi) await new Promise((ok, err) => gapi.load("client:auth2", {callback: ok, onerror: err})) // must whitelist https://norswap.static.observableusercontent.com/ on google dev console await gapi.client.init({ apiKey: GAPI_KEY, clientId: GCLIENT_ID, discoveryDocs: ["https://sheets.googleapis.com/$discovery/rest?version=v4"], // https://developers.google.com/identity/protocols/googlescopes#sheetsv4 scope: "https://www.googleapis.com/auth/spreadsheets" }) .catch(e => console.log(`Error while initializing the Google Client: ${JSON.stringify(e, null, 2)}`)) // Listen for sign-in state changes. gapi.auth2.getAuthInstance().isSignedIn.listen(update_signin_status); // Handle the initial sign-in state. update_signin_status(gapi.auth2.getAuthInstance().isSignedIn.get()); const root = md `\`gapi\`` root.value = gapi return root }2e:T438,viewof fitbit_iden = { if (window.location.hash == "") { const button = html `` button.children[0].style.textDecoration = "none" button.children[0].style.color = "black" viewof fitbit_signin_status.innerHTML = '' viewof fitbit_signin_status.appendChild(button) const root = html `fitbit_iden = false` root.value = false return root } function fitbit_signout (e) { console.log("prout") window.location.hash = "" e.preventDefault() console.log(window.location.hash) location.reload(true) } // There is no easy way to "sign out" (remove hashes from URL (easy) + ensure the address bar is updated (hard)) viewof fitbit_signin_status.innerHTML = "Signed into Fitbit" const params = {} window.location.hash.substring(1).split('&').map(hk => { const pair = hk.split('='); params[pair[0]] = pair[1] }) const root = md `\`fitbit_iden\`` root.value = params return root }2f:[] 29:{"id":"fa5c67205bcdcc51","slug":"fitbit/2","title":"Fitbit","thumbnail":"0fc6bce88e90f55be052da4d7711d714fe167dceea20cd77c6aae0f577a80afc","access_level":"public","create_time":"$D2019-10-29T22:03:01.412Z","update_time":"$D2020-01-18T18:25:51.646Z","view_time":null,"first_public_time":"$D2019-11-03T23:56:29.132Z","fork":true,"stars":1,"starred":false,"owner":{"type":"team","id":"ff78e290821037cc","login":"norswap","name":"Nicolas Laurent","avatar_url":"https://avatars-next.observableusercontent.com/f5e6b366496219ec415f08d2aed822e6a6ef9c1d030e966edc7f193fee9a1be5","tier":"starter_2024"},"version":1086,"publish_version":1086,"role":null,"authored":false,"authors":[{"type":"individual","id":"b1970b1b17ae96e9","login":"norswap","name":"Nicolas Laurent","avatar_url":"https://avatars-next.observableusercontent.com/f5e6b366496219ec415f08d2aed822e6a6ef9c1d030e966edc7f193fee9a1be5","tier":null}],"members":[{"type":"individual","id":"b1970b1b17ae96e9","login":"norswap","name":"Nicolas Laurent","avatar_url":"https://avatars-next.observableusercontent.com/f5e6b366496219ec415f08d2aed822e6a6ef9c1d030e966edc7f193fee9a1be5","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":5,"collection":null,"type":"notebook","body":{"title":"Fitbit","cells":[{"id":168,"value":"md`# Fitbit`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1079,"value":"md`\nThis notebook contains some simple logic to export daily Fitbit data (namely, total calories in, total calories out, and weight) to an (empty) Google Sheet spreadsheet.\n\nSee the \"Setup\" section below for instructions.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":374,"value":"md `# Triggers`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":429,"value":"// updated from click, via `gapi` cell\nviewof google_signin_status = html `

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":582,"value":"// updated from click, via `fitbit_iden` cell\nviewof fitbit_signin_status = html `

`\n\n/*\n\nI wanted to implement this as a popup too, but it's not possible because of Javascript's single origin policy.\n\nIt looked like Window.postMessage() would help me, but it doesn't, because Window.opener does not survivre cross-domain redirects (https://bugs.chromium.org/p/chromium/issues/detail?id=630770).\n\nUsing an iframe would have worked... But observablehq has a security policy against being embedded in iframes.\n\nAdditionally, I could find to way to \"sign out\" properly (remove the hash part of the URL + update the title bar). Observable does not pass down those property to the script (to avoid pages redirecting on load and becoming uneditable).\n\n*/","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1040,"value":"viewof write_sheet_button = {\n const root = html ``\n root.onclick = () => {\n write_sheet()\n swal(\"Success\", \"Sheet written.\", \"success\");\n }\n return root\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":366,"value":"md `# Config`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":283,"value":"GAPI_KEY = Secret(\"GAPI_KEY\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":287,"value":"GCLIENT_ID = Secret(\"GCLIENT_ID\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":884,"value":"FITBIT_OAUTH_ID = Secret(\"FITBIT_OAUTH_ID\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":180,"value":"viewof OAUTH_URL = {\n const root = md `\\`OAUTH_URL\\``\n const this_page = encodeURIComponent(html``.href)\n root.value = `https://www.fitbit.com/oauth2/authorize?response_type=token&client_id=${FITBIT_OAUTH_ID}&redirect_uri=${this_page}&scope=activity%20heartrate%20location%20nutrition%20profile%20settings%20sleep%20social%20weight&expires_in=604800`\n return root \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":640,"value":"SPREADSHEET_ID = \"1fwz-pYvr_x543N_b27kdIKfXY0T7ACZgl7V3UgoqNBE\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":644,"value":"// Name of the first sheet in the spreadsheet. Change this if you changed its name.\nSHEET_NAME = \"Sheet1\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":705,"value":"START_DATE = \"2019-04-22\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":709,"value":"END_DATE = \"2019-05-22\" // format_date(moment())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":631,"value":"$2b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":370,"value":"md `# Implem`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":750,"value":"$2c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":864,"value":"md`## Signup Logic`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":267,"value":"$2d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":189,"value":"$2e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":869,"value":"md `## Helpers`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":711,"value":"moment = require(\"moment\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":714,"value":"format_date = date => date.format(\"YYYY-MM-DD\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":719,"value":"parse_date = string => moment(string, \"YYYY-MM-DD\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":678,"value":"promisify = thenable => new Promise((resolve, reject) => thenable.then(resolve, reject))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":689,"value":"awaitify_req = thenable => promisify(thenable).catch(error => { throw error.body })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1052,"value":"swal = require(\"sweetalert\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":874,"value":"md `## Fitbit API Calls`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":952,"value":"fitbit_range_call = async (endpoint, access_key) => {\n \n const response = await fetch(endpoint, { headers: {\n \"Authorization\": `${fitbit_iden.token_type} ${fitbit_iden.access_token}`\n }}).catch(err => { throw err })\n \n const json = await response.json()\n \n if (json.errors)\n throw json.errors[0].message\n \n return json[access_key]\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":926,"value":"calories_in_range = async (start, end) => fitbit_range_call(\n `https://api.fitbit.com/1/user/-/foods/log/caloriesIn/date/${start}/${end}.json`,\n \"foods-log-caloriesIn\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":939,"value":"calories_out_range = async (start, end) => fitbit_range_call(\n `https://api.fitbit.com/1/user/-/activities/calories/date/${start}/${end}.json`,\n \"activities-calories\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":946,"value":"weight_range = async (start, end) => fitbit_range_call(\n // NOTE1: data may miss days!\n // NOTE2: only works for range of at most 31 days\n `https://api.fitbit.com/1/user/-/body/log/weight/date/${start}/${end}.json`,\n \"weight\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"}],"files":"$W2f","stdlib":"1","titling":"auto"}} 2a:"$29:body"