Element451Integrations Guide

el_people_events

Updated Article

Events are a log of Registrations submitted by a Person.

Event Registrations are stored as an array on the Person record. This model unwinds the array items into rows.

el_people_events Columns#

JSON Keys for People Events Object#

KeyData typeDescription
addressesObjectObject of properties related to the address provided by the person during event registration.
contactObjectObject of properties related to the person, such as first and last name, that they provided during registration.
created_atString (Timestamp)Timestamp when the event registration occured.
customObjectObject of custom field questions provided by the person during event registration.
date_of_birthStringTimestamp of person's date of birth provided during event registration.
educationObjectObject of properties related to the person's education, like intended major and school data.
event_dateString (Timestamp)Timestamp when the event will occur.
event_elements_guidStringGUID of event elements. Foreign key for event elements metadata.
event_guidStringGUID of the event name, like "College Fair".
event_typeStringDatabase friendly code denoting the type of event the person has registered for, like "virtual-event" or "seminar".
familyObjectObject containing properties about family members of the person registering for the event.
genderStringDatabase code for person's gender provided during event registration.
guests_numberIntegerInteger of the number of guests that the person will bring to the event.
index_weightIntegerInteger representing the event registration's position in it's parent array.
paymentObjectObject containing properties about the payment submitted to register for the event.
phoneObjectObject of properties of the phone the person provided during event registraton.
signup_guidStringGUID of event signup.
sourceObjectObject with properties related to the marketing data captured in the URL where event registration took place.
statusObjectObject with properties related to the person's registration status.
updated_atString (Timestamp)Timestamp when the event registration was last updated.
user_idStringGUID of the person who registered for the event. Should match the _id of the person.
zoomObjectObject with properties related to the zoom meeting.

Example People Event JSON#

People Event

json
{
  "contact": [
    {
      "name": "first_name",
      "slug": "user-first-name",
      "value": "Jessica"
    },
    {
      "name": "last_name",
      "slug": "user-last-name",
      "value": "Lastname"
    },
    {
      "name": "email",
      "slug": "user-email-address",
      "value": "email@example.com"
    },
    {
      "name": "user-phone",
      "slug": "user-phone-cell",
      "subfields": [
        {
          "name": "user-phone-type",
          "value": "cell"
        },
        {
          "name": "user-phone-country_alpha_2",
          "value": "CA"
        },
        {
          "name": "user-phone-country_code",
          "value": "1"
        },
        {
          "name": "user-phone-number",
          "value": "8675309"
        }
      ]
    }
  ],
  "created_at": "2025-01-07T21:24:22",
  "event_date": "2025-01-15T00:00:00",
  "event_elements_guid": "instance.event_elements.484086",
  "event_guid": "instance.events.484018",
  "event_type": "info-session",
  "guests_number": 1,
  "index_weight": 1,
  "payment": {
    "action": "succeeded",
    "amount": 20,
    "app_guid": null,
    "condition_guid": "default",
    "currency": "USD",
    "description": "Info Session",
    "descriptor": "Info Session",
    "details": {
      "source": "payments_api"
    },
    "event_guid": "instance.events.291832",
    "gateway": "stripe_connect",
    "idempotencyKey": "event_payment62ab94fad992bc27ainstance.events.2918326NLgJd",
    "integration_id": "62fa68ed82b4d1248b6",
    "isRedirect": true,
    "message": "",
    "nature": "event_payment",
    "paymentTime": "2025-01-07T21:24:22",
    "payment_id": null,
    "payment_log_id": "6441f86caf7e60eb572",
    "registration_id": null,
    "signup_guid": "6dBNLgd",
    "subdom": "instance",
    "successful": true,
    "time": "2025-01-07T21:24:22",
    "transactionReference": "pi_3Mz9GW4HVZ809GMH01i",
    "type": "credit_card",
    "user_id": "62ab94fa4e992bc27a",
    "valid": true
  },
  "signup_guid": "wdLYqge",
  "status": {
    "attended": true,
    "canceled": false,
    "changed_at": "2025-01-07T21:24:22",
    "created_at": "2025-01-07T21:24:22",
    "no_show": false,
    "payment_pending": false,
    "registered": true,
    "slot_expired": false,
    "waitlisted": false
  },
  "updated_at": "2025-01-07T21:24:22",
  "zoom": {
    "id": 91704351,
    "join_url": "https://zoom.us/w/",
    "joined": true,
    "occurrences": [
      {
        "duration": 60,
        "occurrence_id": "1736899200000",
        "start_time": "2025-01-15T00:00:00Z",
        "status": "available"
      }
    ],
    "owner": {
      "account_id": "cHpXWYT60MVM1JxH6w",
      "email": "infosessions@instance.edu",
      "id": "WEJSI3mAQ3-sw",
      "installation_id": "65aea01e71dbca02cc05"
    },
    "registrant_id": "Jv096BSbSe",
    "start_time": "2025-12-10T00:00:00Z",
    "topic": "Info Session"
  }
}
el_people_events
19 rows
ColumnDescriptionData Type
deleted_atDate and time when the signup was deletedTIMESTAMP_NTZ
event_typeType of event (e.g., open_house)VARCHAR
deletedIndicates whether the signup was deletedBOOLEAN
not_attendedIndicates whether the attendee did not attend the event (true/false)BOOLEAN
srcJSON object of all Event registraion propertiesVARIANT
payment_timeDate and time when the payment was madeTIMESTAMP_NTZ
subdomPartner institution instance identifierVARCHAR
attendedIndicates whether the attendee attended the eventBOOLEAN
registered_atDate and time when the signup was registeredTIMESTAMP_NTZ
joined_zoomIndicates whether the attendee joined the Zoom meetingBOOLEAN
guests_numberNumber of guests associated with the registrationNUMBER
status_updated_atDate and time when the status was last updatedTIMESTAMP_NTZ
canceledIndicates whether the event was canceledBOOLEAN
event_dateDate and time when the event took placeTIMESTAMP_NTZ
signup_idIdentifier for a Event RegistrationVARCHAR
element_idUnique student record identifier associated with the EventVARCHAR
event_guidGlobally unique identifier for an eventVARCHAR
event_elements_guidGlobally unique identifier for event elementsVARCHAR
payment_amountAmount of payment associated with the signupNUMBER