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.
| Field | Type | F | S | A | G | Description |
|---|---|---|---|---|---|---|
id | ID | Y | β | β | β | Call ID |
text | string | β | β | β | β | Call notes (select only) |
contact_id | ID | Y | β | β | Y | Associated contact ID |
author | string | β | β | β | β | Author display name (select only) |
author_id | ID | Y | β | β | Y | User who logged the call |
phone_number | string | Y | β | β | β | Phone number called |
call_result | string (output only) | β | β | β | β | Call result display name |
call_result_id | string | Y | Y | β | Y | Call result system_id |
call_time | time | Y | Y | β | Y | When the call occurred |
recording_link | string | β | β | β | β | URL to the call recording (select only) |
created_at | time | Y | Y | β | Y | Record creation timestamp |
modified_at | time | Y | Y | β | Y | Last modification timestamp |
Notes
call_result_idvalues are account-configurable. Common ones includeinterested,not_interested,left_message, andno_answer, but the exact list depends on the accountβs call result configuration.call_resultis the display label resolved fromcall_result_id. Output only; filter and sort bycall_result_id.- Lookups:
contact(viacontact_id). Reference the contactβs fields inline ascontact.<field>inselect,where, andorder_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] } }
}
}