---
title: "Calls"
description: "OQL field reference for calls. Logged phone calls with outcome tracking."
canonical_url: https://developer.onepagecrm.com/oql/entities/calls/
source: Markdown mirror of https://developer.onepagecrm.com/oql/entities/calls/
---

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_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](/oql/concepts/#lookups-related-fields).

## Example queries

My calls this week:

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

Call outcomes by user this quarter:

```json
{
  "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:

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