Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 7.1   7.2   7.3   7.4   7.5   8.0   8.1   8.2   8.3   8.4    Statistic  

HealthKit.SampleQuery

Queries sample data from the database.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
HealthKit 8.2 No No No No Yes

MBS( "HealthKit.SampleQuery"; QuantityType; Unit; StartDate; EndDate { ; SortKey; ascending; limit } )

Parameters

Parameter Description Example value
QuantityType The quantity type to lookup. "StepCount"
Unit The unit to use.
Can be SI unit or for example count for counters.
See Apple documentation for details.
"count"
StartDate The start date for the search. Date ( 1 ; 1 ; 2018 )
EndDate The end date for the search. Date ( 2 ; 1 ; 2018 )
SortKey Optional
How to sort.
Can be StartDate or EndDate.
"StartDate"
ascending Optional
Whether to prefer ascending instead of descending.
Pass 1 for ascending or 0 for descending.
1
limit Optional
The limit for search.
Default 0 for no limit.
0

Result

Returns values as JSON or error.

Description

Queries sample data from the database.
Before calling this method, the application should request authorization to access objects with the desired quantity type.

Supported quantity types:

Body Measurements:
BodyFatPercentage, BodyMass, BodyMassIndex, Height, LeanBodyMass, WaistCircumference.

Fitness:
StepCount, DistanceWalkingRunning, DistanceCycling, DistanceWheelchair, BasalEnergyBurned, ActiveEnergyBurned, FlightsClimbed, NikeFuel, AppleExerciseTime, PushCount, DistanceSwimming, SwimmingStrokeCount, VO2Max.

Vitals:
HeartRate, BodyTemperature, BasalBodyTemperature, BloodPressureSystolic, BloodPressureDiastolic, RespiratoryRate.

Results:
OxygenSaturation, PeripheralPerfusionIndex, BloodGlucose, NumberOfTimesFallen, ElectrodermalActivity, InhalerUsage, InsulinDelivery, BloodAlcoholContent, ForcedVitalCapacity, ForcedExpiratoryVolume1, PeakExpiratoryFlowRate.

Nutrition:
DietaryFatTotal, DietaryFatPolyunsaturated, DietaryFatMonounsaturated, DietaryFatSaturated, DietaryCholesterol, DietarySodium, DietaryCarbohydrates, DietaryFiber, DietarySugar, DietaryEnergyConsumed, DietaryProtein,
DietaryVitaminA, DietaryVitaminB6, DietaryVitaminB12, DietaryVitaminC, DietaryVitaminD, DietaryVitaminE, DietaryVitaminK, DietaryCalcium, DietaryIron, DietaryThiamin, DietaryRiboflavin, DietaryNiacin, DietaryFolate, DietaryBiotin, DietaryPantothenicAcid, DietaryPhosphorus, DietaryIodine, DietaryMagnesium, DietaryZinc, DietarySelenium, DietaryCopper, DietaryManganese, DietaryChromium, DietaryMolybdenum, DietaryChloride, DietaryPotassium, DietaryCaffeine, DietaryWater.

UVExposure

Examples

Query step count:

Set Field [ PlaceHolder::Result ; MBS( "HealthKit.SampleQuery"; "StepCount"; "count"; Date ( 1 ; 1 ; 2018 ); Date ( 1 ; 1 ; 2019 ) ) ]

Created 25th April 2018, last changed 26th April 2018


HealthKit.RequestAuthorizationToShareTypes   -   HealthKit.WheelchairUse

Feedback: Report problem or ask question.




Links
MBS FileMaker tutorial videos