Use XML data exported from Health app
I am trying to write some code to import xml export from Excel health application to Excel so that I can drill down on various metrics over a longer period. For blood glucose readings, the "startDate" and "endDate" attributes are not dates associated with the time the data was acquired using the iPhone app.
Does anyone have an idea on how to interpret these dates? Is this the middle type? I cannot find any documentation on xml elements.
One thing to note - for "weight" xml entries, the time in the XML export is the exact time the entry was added to the iPhone app.
The timestamps use ISO 8601, so the time of the first recording is 6: 43-7: 43am (PDT) and the second recording is 5: 43-6: 43pm (PDT). It looks like the Health app is exporting values aggregated at the hour level rather than individual measurements, although it seems odd that the time doesn't start in full.
Does the Health app have any export options? Couldn't find any documentation and I'd love to get a sample file (I don't have an iOS device at the moment)!
source to share