Google Fit: FitnessData, Get Steps<\/div>
Gets the step count data in Google Fit. Gets the aggregated value for any period. It is also possible to acquire travel distance data (meters). For example, the number of steps taken during working hours for care workers and delivery staff is acquired.<\/div><\/div>\n\n\n
<\/span>Configs<\/div>
\n
- \n
- <\/i><\/span> U: Select HTTP_Authz Setting *<\/span><\/li>\n
- <\/i><\/span> A1: Set Start Datetime of Duration (eg “2021-12-31 09:00”) *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> A2: Set End Datetime of Duration (eg “2021-12-31 17:00”) *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> B1: Select NUMERIC DATA for Step Count (update) *<\/span><\/li>\n
- <\/i><\/span> B2: Select NUMERIC DATA for Distance (update)<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n
<\/span>Script (click to open)<\/div>\n\n\n\n\/\/ GraalJS Script (engine type: 2)\n\n\/\/\/\/\/\/\/\/ START "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strAuthzSetting = configs.get ( "AuthzConfU" ); \/\/\/ REQUIRED\n engine.log( " AutomatedTask Config: Authz Setting: " + strAuthzSetting );\nconst strDurationStart = configs.get ( "StrConfA1" ); \/\/\/ REQUIRED\n if( strDurationStart === "" ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {A1: DurationStart} is empty \\n" );\n }\nconst strDurationEnd = configs.get ( "StrConfA2" ); \/\/\/ REQUIRED\n if( strDurationEnd === "" ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {A2: DurationEnd} is empty \\n" );\n }\nconst numPocketStep = configs.getObject( "SelectConfB1" ); \/\/\/ REQUIRED\nconst numPocketDistance = configs.getObject( "SelectConfB2" ); \/\/ NotRequired\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ (Nothing. Retrieved via Expression Language in Config Retrieving)\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\/\/\/ Times in milliseconds since epoch\n\/\/\/ https:\/\/developer.mozilla.org\/en-US\/docs\/Web\/JavaScript\/Reference\/Global_Objects\/Date\/getTime\nlet dateDurationStart = toJsDate( strDurationStart );\nlet numDurationStart = dateDurationStart.getTime();\nlet dateDurationEnd = toJsDate( strDurationEnd );\nlet numDurationEnd = dateDurationEnd.getTime();\n\n\/\/\/ Get StepCounts (and Distance)\n\/\/\/ Google Fit API\n\/\/\/ https:\/\/developers.google.com\/fit\/rest\/v1\/reference\/users\/dataset\/aggregate\nlet request1Obj = {};\n request1Obj.aggregateBy = [];\n request1Obj.aggregateBy[0] = {};\n request1Obj.aggregateBy[0].dataTypeName = "com.google.step_count.delta";\n if( numPocketDistance !== null ){\n request1Obj.aggregateBy[1] = {};\n request1Obj.aggregateBy[1].dataTypeName = "com.google.distance.delta";\n }\n request1Obj.endTimeMillis = numDurationEnd;\n request1Obj.startTimeMillis = numDurationStart;\n request1Obj.bucketByTime = {};\n request1Obj.bucketByTime.durationMillis = numDurationEnd - numDurationStart;\nlet request1Uri = "https:\/\/www.googleapis.com\/fitness\/v1\/users\/me\/dataset:aggregate";\nlet request1 = httpClient.begin(); \/\/ HttpRequestWrapper\n request1 = request1.authSetting( strAuthzSetting ); \/\/ with "Authorization: Bearer XX"\n \/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574471-R2300#HttpRequestWrapper\n request1 = request1.body( JSON.stringify( request1Obj ), "application\/json" );\n\/\/ request1, try\nconst response1 = request1.post( request1Uri ); \/\/ HttpResponseWrapper\nengine.log( " AutomatedTask ApiRequest1 Start: " + request1Uri );\nconst response1Code = response1.getStatusCode() + "";\nconst response1Body = response1.getResponseAsString() + "";\nengine.log( " AutomatedTask ApiResponse Status: " + response1Code );\nif( response1Code !== "200"){\n throw new Error( "\\n AutomatedTask UnexpectedResponseError: " +\n response1Code + "\\n" + response1Body + "\\n" );\n}\n\/\/ response1, parse\n\/* \nengine.log( response1Body ); \/\/ debug\n{\n "bucket": [\n {\n "startTimeMillis": "1621436400000",\n "endTimeMillis": "1621522800000",\n "dataset": [\n {\n "dataSourceId": "derived:com.google.step_count.delta:com.google.android.gms:aggregated",\n "point": [\n {\n "startTimeNanos": "1621456113977325463",\n "endTimeNanos": "1621488145246312108",\n "dataTypeName": "com.google.step_count.delta",\n "originDataSourceId": "raw:com.google.step_count.cumulative:Sony:SO-41A:cdfccXXXXX8b674Y:pedometer Non-wakeup",\n "value": [\n {\n "intVal": 9987,\n "mapVal": []\n }\n ]\n }\n ]\n },\n {\n "dataSourceId": "derived:com.google.distance.delta:com.google.android.gms:aggregated",\n "point": [\n {\n "startTimeNanos": "1621456169872000000",\n "endTimeNanos": "1621488145246312108",\n "dataTypeName": "com.google.distance.delta",\n "originDataSourceId": "derived:com.google.distance.delta:com.google.android.gms:merge_distance_delta",\n "value": [\n {\n "fpVal": 8987.1162967085838,\n "mapVal": []\n }\n ]\n }\n ]\n }\n ]\n }\n ]\n}\n\n== if no record ==\n{\n "bucket": [\n {\n "startTimeMillis": "1621782000000",\n "endTimeMillis": "1621782010000",\n "dataset": [\n {\n "dataSourceId": "derived:com.google.step_count.delta:com.google.android.gms:aggregated",\n "point": []\n },\n {\n "dataSourceId": "derived:com.google.distance.delta:com.google.android.gms:aggregated",\n "point": []\n }\n ]\n }\n ]\n}\n*\/\nconst response1Obj = JSON.parse( response1Body );\nlet numStep = 0;\nif( response1Obj.bucket[0].dataset[0].point.length === 0 ){\n engine.log( " AutomatedTask RuntimeWarning:" +\n " No Record of StepCount (no point in dataset)" );\n}else{\n numStep = response1Obj.bucket[0].dataset[0].point[0].value[0].intVal;\n}\nlet numDistance = 0;\nif( numPocketDistance !== null ){\n if( response1Obj.bucket[0].dataset[1].point.length === 0 ){\n engine.log( " AutomatedTask RuntimeWarning:" +\n " No Record of Distance (no point in dataset)" );\n }else{\n numDistance = response1Obj.bucket[0].dataset[1].point[0].value[0].fpVal;\n }\n}\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nengine.setData( numPocketStep, new java.math.BigDecimal( numStep ) );\nif( numPocketDistance !== null ){\n engine.setData( numPocketDistance, new java.math.BigDecimal( numDistance ) );\n}\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\nfunction toJsDate( bpmsDateOrDatetimeStr ){\n \/\/ BPMS Date: "2020-04-01" (subtype "Y\/M" "M\/D" "Y", not supported)\n \/\/ BPMS Datetime: "2020-04-01 23:59"\n let year = 0;\n let monthIndex = 0;\n let day = 0;\n let hours = 0;\n let minutes = 0;\n\n \/\/ The ECMA\/JavaScript Date object has a large number of methods.\n \/\/ "Date.parse" is danger (strongly discouraged)\n \/\/ - new Date("2014-11-10") \/\/ Mon Nov 10 2014 09:00:00 GMT+0900 (JST)\n \/\/ - new Date(2014, 10, 10) \/\/ Mon Nov 10 2014 00:00:00 GMT+0900 (JST)\n let arrDatetime = bpmsDateOrDatetimeStr.split(" ");\n if( arrDatetime.length === 1 ){\n let arrDateParts = arrDatetime[0].split("-");\n year = parseInt(arrDateParts[0], 10);\n monthIndex = parseInt(arrDateParts[1], 10) - 1;\n day = parseInt(arrDateParts[2], 10);\n }\n if( arrDatetime.length === 2 ){\n let arrDateParts = arrDatetime[0].split("-");\n let arrTimeParts = arrDatetime[1].split(":");\n year = parseInt(arrDateParts[0], 10);\n monthIndex = parseInt(arrDateParts[1], 10) - 1;\n day = parseInt(arrDateParts[2], 10);\n hours = parseInt(arrTimeParts[0], 10);\n minutes = parseInt(arrTimeParts[1], 10);\n }\n return new Date( year, monthIndex, day, hours, minutes );\n}\n\n\n\/*\nNotes:\n- Used in the daily reporting process of caregiver, deliveryman, etc. GoogleFitSteps\n - It is possible to count periods that exceed 24 hours.\n - Long-term like over 2 months will result in an "aggregate duration too large" error.\n- Only the data of the person who permitted API communication (OAuth Authz) can be acquired.\n - That is, only one person's data can be acquired for each automated task.\n - As of 2021-05, data cannot be acquired with any user ID (userId). \n- The unit of travel distance data is meters.\n - Variable decimal numbers follow the numeric data definition of the workflow app.\n- If the datetime (DurationStart and DurationEnd) are set in date format, considered as "00:00".\n - eg: "2021-12-31" to "2021-12-31 00:00"\n\nNotes-ja:\n- \u4ecb\u8b77\u8077\u54e1\u3084\u914d\u9054\u54e1\u306a\u3069\u304c\u52e4\u52d9\u6642\u9593\u5185\u306e\u6b69\u6570\u3084\u8ddd\u96e2\u3092\u5831\u544a\u3059\u308b\u696d\u52d9\u30d7\u30ed\u30bb\u30b9\u7b49\u3067\u5229\u7528\u3057\u307e\u3059\u3002 GoogleFitSteps\n - 24\u6642\u9593\u3092\u8d85\u3048\u308b\u3088\u3046\u306a\u6642\u9593\u7bc4\u56f2\u3067\u306e\u96c6\u8a08\u3082\u53ef\u80fd\u3067\u3059\u3002\n - \u305f\u3060\u3057\u30012\u30ab\u6708\u3092\u8d85\u3048\u308b\u3088\u3046\u306a\u9577\u671f\u9593\u306e\u96c6\u8a08\u306f "aggregate duration too large" \u30a8\u30e9\u30fc\u3068\u306a\u308a\u307e\u3059\u3002\n- API\u901a\u4fe1\u3092\u8a31\u53ef\uff08OAuth\u8a8d\u53ef\uff09\u3057\u305f\u672c\u4eba\u306e\u30c7\u30fc\u30bf\u3057\u304b\u53d6\u5f97\u3067\u304d\u307e\u305b\u3093\u3002 "HTTP\u8a8d\u8a3c\u8a2d\u5b9a"\n - \u3059\u306a\u308f\u3061\u3001\u81ea\u52d5\u51e6\u7406\u5de5\u7a0b\uff11\u3064\u306b\u3064\u304d\u3001\uff11\u4eba\u306e\u30c7\u30fc\u30bf\u3057\u304b\u53d6\u5f97\u3067\u304d\u307e\u305b\u3093\u3002\n - 2021-05\u73fe\u5728\u3001\u4efb\u610f\u306e\u30e6\u30fc\u30b6ID\uff08userId\uff09\u3067\u306e\u30c7\u30fc\u30bf\u53d6\u5f97\u306f\u3067\u304d\u307e\u305b\u3093\u3002\n- \u79fb\u52d5\u8ddd\u96e2\u30c7\u30fc\u30bf\u306e\u5358\u4f4d\u306f\u30e1\u30fc\u30c8\u30eb\u3067\u3059\u3002\n - \u5c0f\u6570\u70b9\u4ee5\u4e0b\u6709\u52b9\u6570\u5b57\uff08\u5207\u308a\u6368\u3066\u4f4d\u7f6e\uff09\u306f\u3001\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30a2\u30d7\u30ea\u306e\u6570\u5024\u578b\u30c7\u30fc\u30bf\u5b9a\u7fa9\u306b\u5f93\u3044\u307e\u3059\u3002\n- \u65e5\u6642\uff08\u7bc4\u56f2\u958b\u59cb\u3068\u7bc4\u56f2\u7d42\u4e86\uff09\u304c\u65e5\u4ed8\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3067\u8a2d\u5b9a\u3055\u308c\u305f\u5834\u5408\u3001"00:00" \u3068\u307f\u306a\u3055\u308c\u307e\u3059\u3002\n - \u4f8b: "2021-12-31" \u2192 "2021-12-31 00:00"\n\nAPPENDIX-en\n- For usage of Google Fit itself, refer to the Google Fit documents.\n - Track your fitness activity\n - https:\/\/support.google.com\/fit\/answer\/6075066?hl=en\n - Find your activity\n - https:\/\/support.google.com\/fit\/answer\/6090183?hl=en\n - Fit isn't tracking activities correctly\n - https:\/\/support.google.com\/fit\/answer\/6075068?hl=en\n - Connect other apps with Google Fit\n - https:\/\/support.google.com\/accounts\/answer\/6098255?hl=en\n- Setting example of "HTTP Authentication" (OAuth2)\n - Authorization Endpoint URL:\n - https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&approval_prompt=force\n - Token Endpoint URL:\n - https:\/\/accounts.google.com\/o\/oauth2\/token\n - Scope:\n - https:\/\/www.googleapis.com\/auth\/fitness.activity.read https:\/\/www.googleapis.com\/auth\/fitness.location.read\n - Client ID, Consumer Secret:\n - ( from https:\/\/console.developers.google.com\/ )\n - Redirect URLs: https:\/\/s.questetra.net\/oauth2callback\nAPPENDIX-ja\n- Google Fit \u81ea\u4f53\u306e\u57fa\u672c\u7684\u306a\u5229\u7528\u65b9\u6cd5\u306f\u3001Google Fit \u306e\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u53c2\u7167\u3057\u3066\u304f\u3060\u3055\u3044\u3002\n - \u30d5\u30a3\u30c3\u30c8\u30cd\u30b9 \u30a2\u30af\u30c6\u30a3\u30d3\u30c6\u30a3\u3092\u8a18\u9332\u3059\u308b\n - https:\/\/support.google.com\/fit\/answer\/6075066?hl=ja\n - \u30a2\u30af\u30c6\u30a3\u30d3\u30c6\u30a3\u3092\u78ba\u8a8d\u3059\u308b\n - https:\/\/support.google.com\/fit\/answer\/6090183?hl=ja\n - Fit \u304c\u30a2\u30af\u30c6\u30a3\u30d3\u30c6\u30a3\u3092\u6b63\u3057\u304f\u30c8\u30e9\u30c3\u30ad\u30f3\u30b0\u3057\u3066\u3044\u306a\u3044\n - https:\/\/support.google.com\/fit\/answer\/6075068?hl=ja\n - \u4ed6\u306e\u30a2\u30d7\u30ea\u3068 Google Fit \u3092\u63a5\u7d9a\u3059\u308b\n - https:\/\/support.google.com\/accounts\/answer\/6098255?hl=ja\n- "HTTP\u8a8d\u8a3c"\uff08OAuth2\uff09\u306e\u8a2d\u5b9a\u4f8b\n - Authorization Endpoint URL:\n - https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&approval_prompt=force\n - Token Endpoint URL:\n - https:\/\/accounts.google.com\/o\/oauth2\/token\n - Scope:\n - https:\/\/www.googleapis.com\/auth\/fitness.activity.read https:\/\/www.googleapis.com\/auth\/fitness.location.read\n - Client ID, Consumer Secret:\n - ( from https:\/\/console.developers.google.com\/ )\n - Redirect URLs: https:\/\/s.questetra.net\/oauth2callback\n*\/\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<\/a><\/figure>\n\n\n\n
<\/i> Download<\/h3>\n\n\n\n
- \n
- Google-Fit-FitnessData-Get-Steps-2021.xml<\/a><\/li>\n\n\n\n
- Google-Fit-FitnessData-Get-Steps-2023.xml<\/a>\n
- \n
- 2023-08-17 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n
- for “GraalJS standard (engine-type 3)” on v15.0 or above<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Google-Fit-FitnessData-Get-Steps-2026.xml<\/a>\n
- \n
- 2026-04-27 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n
- Due to the deprecation of the methods
authSetting(String)<\/code> at v18.<\/li>\n\n\n\n- https:\/\/support.questetra.com\/ja\/versions\/version-180\/<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
2021-05-24 (C) Questetra, Inc. (MIT License)
https:\/\/support.questetra.com\/addons\/google-fit-fitnessdata-get-steps-2021\/<\/a>
<\/i> The Addon-import feature is available with Professional<\/strong><\/span> edition.<\/p>\n\n\n<\/div>\n\n\n\n<\/i> Notes<\/h3>\n\n\n\n
- \n
- Used in the daily reporting process of caregiver, deliveryman, etc. GoogleFitSteps\n
- \n
- It is possible to count periods that exceed 24 hours.<\/li>\n\n\n\n
- Long-term like over 2 months will result in an “aggregate duration too large” error.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Only the data of the person who permitted API communication (OAuth Authz) can be acquired.\n
- \n
- That is, only one person’s data can be acquired for each automated task.<\/li>\n\n\n\n
- As of 2021-05, data cannot be acquired with any user ID (userId).<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- The unit of travel distance data is meters.\n
- \n
- Variable decimal numbers follow the numeric data definition of the workflow app.<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- If the datetime (DurationStart and DurationEnd) are set in date format, considered as “00:00”.\n
- \n
- eg: “2021-12-31” to “2021-12-31 00:00”<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
<\/i> Capture<\/h3>\n\n\n\n
![\"Gets](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/google-fit-fitnessdata-get-steps-2021-execution-en.png?resize=1200%2C675&ssl=1\")
<\/a><\/figure>\n\n\n\n![\"google-fit-rest-api\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/google-fit-rest-api.png?resize=1200%2C675&ssl=1\")
<\/a><\/figure>\n\n\n\n![\"Gets](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/05\/google-fit-fitnessdata-get-steps-2021-config-en.png?resize=1157%2C728&ssl=1\")
<\/a><\/figure>\n\n\n\n<\/i> Appendix<\/h3>\n\n\n\n
- \n
- For usage of Google Fit itself, refer to the Google Fit documents.\n
- \n
- Track your fitness activity\n
- \n
- https:\/\/support.google.com\/fit\/answer\/6075066?hl=en<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Find your activity\n
- \n
- https:\/\/support.google.com\/fit\/answer\/6090183?hl=en<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Fit isn’t tracking activities correctly\n
- \n
- https:\/\/support.google.com\/fit\/answer\/6075068?hl=en<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Connect other apps with Google Fit\n
- \n
- https:\/\/support.google.com\/accounts\/answer\/6098255?hl=en<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Setting example of “HTTP Authentication” (OAuth2)\n
- \n
- Authorization Endpoint URL:\n
- \n
- https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&approval_prompt=force<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Token Endpoint URL:\n
- https:\/\/accounts.google.com\/o\/oauth2\/auth?access_type=offline&approval_prompt=force<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Setting example of “HTTP Authentication” (OAuth2)\n
- Connect other apps with Google Fit\n
- Fit isn’t tracking activities correctly\n
- Find your activity\n
- https:\/\/support.google.com\/fit\/answer\/6075066?hl=en<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n
- Track your fitness activity\n
- For usage of Google Fit itself, refer to the Google Fit documents.\n
- eg: “2021-12-31” to “2021-12-31 00:00”<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
- https:\/\/support.questetra.com\/ja\/versions\/version-180\/<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
- Google-Fit-FitnessData-Get-Steps-2023.xml<\/a>\n
- <\/i><\/span> A1: Set Start Datetime of Duration (eg “2021-12-31 09:00”) *<\/span>#{EL}<\/sup><\/span><\/li>\n