Element451Integrations Guide

el_tasks_raw

Updated Article

el_tasks_raw Columns#

JSON Keys for Tasks Object#

Sample JSON Object for Tasks#

Tasks

json
{
  "_id": "64ba9084f21bb2b7050a5dd5",
  "_subdom": "instance",
  "assigned_at": "2023-07-21T18:56:07.948000",
  "assigned_to": [
    "649c9c3e43f24d88e777"
  ],
  "created_at": "2023-07-21T14:04:52.953000",
  "created_by": "649b0e797faa5b0b3422",
  "description": "Duplicate",
  "done_at": "2023-07-21T18:56:07.946000",
  "due_datetime": "2023-07-21T14:02:00",
  "guid": "instance.todos.1650580",
  "name": "Initial Outreach Call",
  "notes": [
    {
      "author_id": "6480db58c5e69e0a0d74",
      "body": "<p>Reached out to student, had productive discussion. Student wanted to know about financial aid options. Should apply soon.</p>",
      "created_at": "2023-07-21T18:56:04",
      "item_id": "VBJKAW",
      "updated_at": "2023-07-21T18:56:04"
    }
  ],
  "parent_task_guid": null,
  "priority_guid": "instance.taxonomy.2774139",
  "queue_references": [
    "instance.taxonomy.2783258",
    "instance.taxonomy.2783261"
  ],
  "related_to": "64ac6bab5fbc10fd5fd",
  "status": "done",
  "status_guid": "instance.taxonomy.2774136",
  "subscribers": [
    "649b0e7953307fab3422"
  ],
  "type": "instance.taxonomy.2780584",
  "type_guid": "instance.taxonomy.2780584",
  "updated_at": "2023-07-21T18:56:07.951000"
}
el_tasks_raw
0 rows
ColumnData TypeDescription
el_tasks_raw Columns
7 rows
ColumnSQL Data TypeDescription
srcVARIANTJSON object of task properties.
_idVARCHARUnique task identifier
etl_loaded_atTIMESTAMP_NTZTask loaded to Snowflake timestamp
created_atTIMESTAMP_NTZTask created timestamp
subdomVARCHARPartner school instance identifier
deleted_atTIMESTAMP_NTZTask deleted timestamp
updated_atTIMESTAMP_NTZTask update timestamp
JSON Keys for Tasks Object
23 rows
DescriptionData TypeKey
Task status.STRINGstatus
Date the system lasted updated the task.STRING (TIMESTAMP)system_updated_at
Date the task was completed.STRING (TIMESTAMP)done_at
Indicates the subdomain related to the task's instance.STRING_subdom
Array of objects of notes related to the task.ARRAYnotes
Array of users that subscribe to the task.ARRAYsubscribers
Description of the task.STRINGdescription
Date the task was due.STRING (TIMESTAMP)due_datetime
Date the task was created.STRING (TIMESTAMP)created_at
Date the task was assigned to a user.STRING (TIMESTAMP)assigned_at
Unique identifier for the task.STRINGguid
Reference to the user or automation that created the task.STRINGcreated_by
Task type GUID.STRINGtype_guid
Reference to the task priority.STRINGpriority_guid
Array of references to queue's that the task belongs to.ARRAYqueue_references
Unique identifier for the task.STRING_id
Reference to the task status.STRINGstatus_guid
Reference to the task type.STRINGtype
Date the task was last updated.STRING (TIMESTAMP)updated_at
Reference to the student record that the task is related to.STRINGrelated_to
Unique identifier for the task's parent task.STRINGparent_task_guid
Name given to the task.STRINGname
Reference to the user or team who is assigned to the taskSTRINGassigned_to