> ## Documentation Index
> Fetch the complete documentation index at: https://developer.affinity.co/llms.txt
> Use this file to discover all available pages before exploring further.

# Opportunities

Includes data on all opportunities in your Affinity instance with basic metadata and a json object that includes your custom opportunity list fields

**Name:** `v1_0.opportunities`

Deleted and merged records are covered in [Deletes & Merges](https://developer.affinity.co/pages/data-share/deletes.md).

> [!WARNING]
>
> Grant access to the share only to users who are authorized to view all
> organization data. There are no per-user or per-role visibility filters applied at the
> share level.

## Columns

| Column | Description |
| - | - |
| `id` | The opportunity's unique identifier |
| `name` | The name of the opportunity |
| `is_restricted` | Whether the opportunity is restricted. `false` for customers without the Restricted Opportunities feature enabled. |
| `first_email_date` | When the first email with anyone on this opportunity was sent or received (First Email) |
| `last_email_date` | When the most recent email with anyone on this opportunity was sent or received (Last Email) |
| `first_event_date` | When the first meeting or call with anyone on this opportunity took place (First Event) |
| `last_event_date` | When the most recent past meeting or call with anyone on this opportunity took place (Last Event) |
| `next_event_date` | When the next upcoming meeting or call with anyone on this opportunity takes place (Next Event) |
| `first_chat_message_date` | When the first chat message with anyone on this opportunity was sent or received |
| `last_chat_message_date` | When the most recent chat message with anyone on this opportunity was sent or received |
| `last_contact_date` | The most recent contact of any kind — the latest of last\_email\_date, last\_event\_date and last\_chat\_message\_date (Last Contact) |
| `is_deleted` | Whether the opportunity has been deleted |
| `last_updated_at` | Timestamp when this record was last updated |


## Related topics

- [Delete an Opportunity](https://developer.affinity.co/api-reference/2026-09-17/opportunities/delete-an-opportunity.md)
- [Update an Opportunity](https://developer.affinity.co/api-reference/2026-09-17/opportunities/update-an-opportunity.md)
- [Notes Opportunities](https://developer.affinity.co/pages/data-share/notes_opportunities_v1_0.md)
- [Opportunities Companies](https://developer.affinity.co/pages/data-share/opportunities_companies_v1_0.md)
- [Opportunities Persons](https://developer.affinity.co/pages/data-share/opportunities_persons_v1_0.md)


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.