The external accounts data export provides a snapshot of all external accounts linked to participants (e.g. healthcare providers, Fitbit, Garmin, etc.) and their status at the time of the export.
Table of Contents
Data Fields
| Field | Description |
|---|---|
ExternalAccountID |
Integer identifier specific to the account. |
ParticipantID |
The stable, automatically generated, internal system identifier for this participant. Universally unique identifier (UUID). |
ParticipantIdentifier |
The identifier of the participant the notification or survey was delivered to. Can be used to cross reference with Participants. |
Status |
The status field can contain the following values: Unauthorized: The connection credentials are incorrect (and the participant should reconnect). Error: There was an error with the most recent data fetch. FetchComplete: The most recent data fetch was successful. |
LastRefreshDate |
The timestamp for the most recent fetch of data from the account connection, in UTC. |
ProviderID |
Integer identifier specific to the provider. |
ProviderName |
Name of the provider. |
ProviderCategory |
Category such as Provider, Device Manufacturer, and Health Plan. |
Sample CSV Export
ExternalAccountID,ParticipantID,ParticipantIdentifier,Status,LastRefreshDate,ProviderID,ProviderName,ProviderCategory,ProviderLogoUrl 1,28596c6c-03c8-4b32-9234-231a53556936,MDH-1234,FetchComplete,2023-01-02T03:04:05,2,CareEvolutionTest,Health Plan,https://designer.mydatahelps.org/api/fhirproviderslogo/2 2,2dd6143c-0db4-4145-ae04-079e45ba34a5,MDH-5678,Unauthorized,2023-01-02T03:04:05,4,Hospital,Provider,https://designer.mydatahelps.org/api/fhirproviderslogo/4
Sample JSON Export
{
"ExternalAccountID": 1,
"ParticipantID": "28596c6c-03c8-4b32-9234-231a53556936",
"ParticipantIdentifier": "MDH-1234",
"Status": "FetchComplete",
"LastRefreshDate": "2023-01-02T03:04:05",
"Provider":
{
"ID": 2,
"Name": "CareEvolutionTest",
"Category": "Health Plan",
"LogoUrl": "https://designer.mydatahelps.org/api/fhirproviderslogo/2"
}
}