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.

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.
`is_deleted`	Whether the opportunity has been deleted
`last_updated_at`	Timestamp when this record was last updated

Getting Started

Example Queries

V1_0

Changelog

Columns

​Columns

Columns