Skip to main content

Participant Data Export Format

  • Updated

The AllParticipants export contains all participants on the project.

Table of Contents

Data Fields

Field Description
ParticipantIdentifier A unique identifier for the participant in this project. This can be set up via the invitation sent to the user, or will be auto-generated if the identifier was not specified in the invitation.
EmailAddress The email address of the participant.
FirstName The first name of the participant.
MiddleName The middle name of the participant.
LastName The last name of the participant.
Gender The gender of the participant.
DateOfBirth The date of birth of the participant.
SecondaryIdentifier Deprecated; a custom field can be used if you require a fully custom participant identifier.
PostalCode The zip/postal code of the participant.
EnrollmentDate The date/time the participant enrolled in this project, in ISO 8601 format.
EventDates Deprecated; participant events are now included in CustomFields.
CustomFields

Lists any custom fields associated with the patient, formatted as a JSON string. For example:

{ "Medication1": "Warfarin","SurgeryDate": "2018-11-01" }
UtcOffset The UTC offset of the participant.
TimeZone The timezone of the participant.
PreferredLanguage The preferred language of the participant.
ParticipantID

The stable, automatically generated, internal system identifier for this participant. Universally unique identifier (UUID).
MobilePhone The mobile phone number of the participant.
UnsubscribedFromEmails Whether the participant has unsubscribed from email communications related to this study.
UnsubscribedFromSms Whether the participant has unsubscribed from SMS communications related to this study.
InsertedDate The date the participant was first created in your project, in ISO 8601 format.
WithdrawDate The date the participant was withdrawn from the project, in ISO 8601 format.

Sample CSV Export

ParticipantIdentifier,EmailAddress,FirstName,MiddleName,LastName,Gender,DateOfBirth,SecondaryIdentifier,PostalCode,EnrollmentDate,EventDates,CustomFields,UtcOffset,TimeZone,PreferredLanguage,ParticipantID,MobilePhone,UnsubscribedFromEmails,UnsubscribedFromSMS,InsertedDate,WithdrawDate
MDH-5826-3273,abc@example.com,John,Jacob,Smith,,8/14/87,,15101,2017-12-05T18:25:59Z,{},"{""Medication1"":""Wafarin""}",-04:00:00,America/New_York,,ba9c19c4-9938-420f-aba6-d6d6c88c6417,(555) 387-9020,,true,2017-12-05T18:15:20Z,
MDH-6392-8549,def@example.com,Allen,Jack,Smith,,1/12/98,,,2018-01-29T15:58:19Z,{},{},-05:00:00,America/Chicago,en,820c2f2d-43fc-47d2-a6a9-08886f5818ba,,false,,2018-01-24T19:12:04Z,2020-09-13T11:48:33Z
MDH-3043-1966,ghi@example.com,Jim,Bob,Smith,M,8/14/87,,,2018-03-22T21:41:28Z,{},"{""DischargeDate"":""2018-11-03""",5:30:00,Asia/Kolkata,es,d30c9752-2da3-45a6-878a-757ea36252b4,(555) 424-1234,,false,2018-03-22T09:35:47Z,

Sample JSON Export

{
 "ParticipantIdentifier": "MDH-5826-3273",
 "EmailAddress": "abc@example.com",
 "FirstName": "John",
 "MiddleName": "Jacob",
 "LastName": "Smith",
 "DateOfBirth": "1987-08-14",
 "PostalCode": "15101",
 "EnrollmentDate": "2017-12-05T18:25:59Z",
 "EventDates": {},
 "CustomFields": {
   "Medication1": "Wafarin"
   },
 "UtcOffset": "-04:00:00",
 "TimeZone": "America/New_York",
 "ParticipantID": "ba9c19c4-9938-420f-aba6-d6d6c88c6417",
 "MobilePhone": "(555) 387-9020",
 "UnsubscribedFromSMS": "true",
 "InstertedDate": "2017-12-05T18:15:20Z"
}
{
 "ParticipantIdentifier": "MDH-6392-8549",
 "EmailAddress": "def@example.com",
 "FirstName": "Allen",
 "MiddleName": "Jack",
 "LastName": "Smith",
 "DateOfBirth": "1998-01-12",
 "EnrollmentDate": "2018-01-29T15:58:19Z",
 "EventDates": {},
 "CustomFields": {},
 "UtcOffset": "-05:00:00",
 "TimeZone": "America/Chicago",
 "PreferredLanguage": "en",
 "ParticipantID": "820c2f2d-43fc-47d2-a6a9-08886f5818ba",
 "UnsubscribedFromEmails": "false",
 "InsertedDate": "2018-01-24T19:12:04Z",
 "WithdrawDate": "2020-09-13T11:48:33Z"
}
{
 "ParticipantIdentifier": "MDH-3043-1966",
 "EmailAddress": "ghi@example.com",
 "FirstName": "Jim",
 "MiddleName": "Bob",
 "LastName": "Smith",
 "Gender": "M",
 "DateOfBirth": "1987-08-14",
 "EnrollmentDate": "2018-03-22T21:41:28Z",
 "EventDates": {},
 "CustomFields": {
   "DischargeDate":"2018-11-03",
   "SurgeryDate":"2018-11-01"
   },
 "UtcOffset": "05:30:00",
 "TimeZone": "Asia/Kolkata",
 "PreferredLanguage": "es",
 "ParticipantID": "d30c9752-2da3-45a6-878a-757ea36252b4",
 "MobilePhone": "(555) 424-1234",
 "UnsubscribedFromSMS": "false",
 "InsertedDate": "2018-03-22T09:35:47Z"
}

 

Was this article helpful?