Fields Metadata

Includes data on all fields across entities and their metadata. Includes things like field types, available dropdown options, and formula definitions. Name: v1_0.fields_metadata 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 field’s identifier
`name`	The field’s name
`list_id`	The ID of the list this field belongs to (null for non-list fields)
`field_type`	The field’s type (enriched, global, list, relationship-intelligence)
`value_type`	The underlying value type (text, number, date, etc.)
`enrichment_source`	The source of the data in this field (if it is enriched)
`dropdown_options`	Dropdown options for dropdown/status fields
`formula`	Formula definition for formula fields
`is_deleted`	Whether the field has been deleted
`last_updated_at`	Timestamp when this record was last updated

Getting Started

Example Queries

V1_0

Changelog

Columns

​Columns

Columns