Calls — OQL | OnePageCRM Developers

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	Y	—	—	Call ID
`text`	string	—	—	—	—	Call notes. Select only, plus `contains` search.
`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	Y	—	—	Y	Call result name (`Interested`, `No answer`, …). The same column as `call_result_id`, read and written by name.
`call_result_id`	string	Y	Y	—	Y	Call result system_id
`call_time`	time	Y	Y	—	Y	When the call occurred. Defaults to now on create.
`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_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 and call_result_id are one field, the name and the id: {"call_result": "No answer"} and {"call_result_id": "no_answer"} are the same filter. See Concepts › Names and ids for the rules.
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] } }
  }
}