OQL Β· Entities

Calls

OQL field reference for calls. Logged phone calls with outcome tracking.

Last updated Jul 16, 2026

Calls are logged phone calls with outcome tracking, attached to a contact.

Fields

Legend: F filterable, S sortable, A aggregatable, G groupable.

FieldTypeFSAGDescription
idIDYβ€”β€”β€”Call ID
textstringβ€”β€”β€”β€”Call notes (select only)
contact_idIDYβ€”β€”YAssociated contact ID
authorstringβ€”β€”β€”β€”Author display name (select only)
author_idIDYβ€”β€”YUser who logged the call
phone_numberstringYβ€”β€”β€”Phone number called
call_resultstring (output only)β€”β€”β€”β€”Call result display name
call_result_idstringYYβ€”YCall result system_id
call_timetimeYYβ€”YWhen the call occurred
recording_linkstringβ€”β€”β€”β€”URL to the call recording (select only)
created_attimeYYβ€”YRecord creation timestamp
modified_attimeYYβ€”YLast modification timestamp

Notes

  • call_result_id values are account-configurable. Common ones include interested, not_interested, left_message, and no_answer, but the exact list depends on the account’s call result configuration.
  • call_result is the display label resolved from call_result_id. Output only; filter and sort by call_result_id.
  • Lookups: contact (via contact_id). Reference the contact’s fields inline as contact.<field> in select, where, and order_by. See Concepts β€Ί Lookups.

Example queries

My calls this week:

{
  "from": "calls",
  "where": {
    "author_id": "ME()",
    "call_time": { ">=": "THIS_WEEK()" }
  },
  "order_by": [{ "call_time": "desc" }]
}

Call outcomes by user this quarter:

{
  "from": "calls",
  "select": ["author_id", "call_result_id", "count()"],
  "where": { "call_time": { ">=": "THIS_QUARTER()" } },
  "group_by": ["author_id", "call_result_id"]
}

Calls to Irish numbers in the last 30 days:

{
  "from": "calls",
  "where": {
    "phone_number": { "like": "+353%" },
    "call_time": { ">=": { "DAYS_AGO": [30] } }
  }
}