Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 9.2   9.3   9.4   9.5   10.0   10.1   10.2   10.3   10.4   10.5    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 } )   More

Parameters

Parameter Description Example Flags
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 How to sort.
Can be StartDate or EndDate.
"StartDate" Optional
ascending Whether to prefer ascending instead of descending.
Pass 1 for ascending or 0 for descending.
1 Optional
limit The limit for search.
Default 0 for no limit.
0 Optional

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 ) ) ]

Blog Entries

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


HealthKit.RequestAuthorizationToShareTypes   -   HealthKit.WheelchairUse

Feedback: Report problem or ask question.




Links
MBS FileMaker tutorial videos