Connecting to Attio

To authenticate to Attio, and connect to your own data or to allow other users to connect to their data, you can use API Key authentication.

Authentication

To authenticate to Attio, and connect to your own data or to allow other users to connect to their data, you can use API Key authentication.

Using API Key Authentication

To authenticate using an API Key, you need to obtain your API Key from your Attio account settings.

You can then connect by setting the AuthScheme to APIKey and providing your API key:

AuthScheme: Set this to APIKey.
APIKey: Set this to your API key from Attio.

Available Tables

The Attio API Profile provides access to comprehensive customer relationship management and business data across 25 specialized tables:

People - Access individual contact records with personal information, communication history, and relationship data.
Companies - Query organization records including company details, social profiles, and business relationships.
Deals - Retrieve deal pipeline data with stages, values, and associated contact information.
Tasks - Access task management data with completion status, deadlines, and linked records.
Meetings - Query meeting records with participants, scheduling, and timezone information.
Notes - Retrieve notes and comments associated with records and meetings.
Users - Access workspace user information and permissions.
Workspaces - Query workspace configuration and member data.
Objects - Access object definitions and metadata for custom data structures.
Records - Generic record container for accessing data across all object types.
Lists - Query list definitions and configuration data.
Entries - Access list entry data with hierarchical relationships.
Threads - Retrieve conversation thread data and communication history.
Comments - Query comments and responses within threads and records.
CallRecordings - Access meeting call recordings and media files.
Transcripts - Query transcription data from call recordings.
UserInfo - Access current user authentication and token information.
WorkspaceMembers - Query workspace membership and access levels.
Attributes - Access attribute definitions and field configurations.
AttributeOptions - Query select field options and dropdown values.
AttributeStatuses - Access status field configurations and workflow states.
RecordAttributeValues - Query historical attribute value changes for records.
EntryAttributeValues - Access historical attribute value changes for list entries.
RecordEntries - Query relationships between records and list entries.

Usage Examples

Query all people records:

SELECT * FROM People

Query all company records:

SELECT * FROM Companies

Query all deal records:

SELECT * FROM Deals

Query all user records:

SELECT * FROM Users

Get completed tasks:

SELECT * FROM Tasks WHERE IsCompleted = 'true'

Get tasks linked to people:

SELECT * FROM Tasks WHERE LinkedObjectId = 'obj_123456' AND LinkedRecordId = 'rec_01234567890'

Query notes for people records:

SELECT * FROM Notes WHERE ParentObject = 'people' AND ParentRecordId = 'rec_01234567890'

Query notes for specific record:

SELECT * FROM Notes WHERE ParentObject = 'people' AND ParentRecordId = 'rec_01234567890'

Query meetings by specific participant:

SELECT * FROM Meetings WHERE IncludeParticipants = '[email protected]'

Query meetings linked to people:

SELECT * FROM Meetings WHERE LinkedObjectId = 'people' AND LinkedRecordId = 'rec_01234567890'

Query all call recordings:

SELECT * FROM CallRecordings

Query all transcripts:

SELECT * FROM Transcripts

Query all threads:

SELECT * FROM Threads

Query all comments:

SELECT * FROM Comments

Query all workspaces:

SELECT * FROM Workspaces

Query all workspace members:

SELECT * FROM WorkspaceMembers

Query current user information:

SELECT * FROM UserInfo

Query all object definitions:

SELECT * FROM Objects

Query all generic records:

SELECT * FROM Records

Query all lists:

SELECT * FROM Lists

Query all list entries:

SELECT * FROM Entries

Query record-entry relationships:

SELECT * FROM RecordEntries WHERE ObjectId = 'obj_0123456' AND RecordId = 'rec_01234567890'

Query all attributes:

SELECT * FROM Attributes WHERE Target = 'objects' AND ObjectId = 'obj_0123456'

Query active attribute options:

SELECT * FROM AttributeOptions WHERE Target = 'objects' AND ObjectId = 'obj_0123456' AND AttributeId = 'attr_123456' AND ShowArchived = 'false'

Query all attribute statuses:

SELECT * FROM AttributeStatuses WHERE Target = 'objects' AND ObjectId = 'obj_0123456' AND AttributeId = 'attr_123456'

Query record attribute value history:

SELECT * FROM RecordAttributeValues WHERE ObjectId = 'obj_0123456789' AND RecordId = 'rec_01234567890' AND AttributeId = 'attr_123456'

Query entry attribute value history:

SELECT * FROM EntryAttributeValues WHERE ListId = 'list_123456' AND EntryId = 'entry_01234567890' AND AttributeId = 'attr_123456'

Query tasks by assignee:

SELECT * FROM Tasks WHERE Assignee = '[email protected]'

Query historical attribute values:

SELECT * FROM RecordAttributeValues WHERE ObjectId = 'obj_1234567890' AND RecordId = 'rec_01234567890' AND AttributeId = 'attr_123456' AND ShowHistoric = 'true'

Connection Properties

The connection string properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection string for this provider.

Property	Description
APIKey	Your Attio API token from the Attio Console.