Connecting to Missive

Using API Key Authentication

Missive uses API Key authentication via Bearer tokens. To obtain your API key:

1. Log in to your Missive account
2. Navigate to Settings > API > Tokens
3. Generate or copy your API token

After obtaining the API token, you are ready to connect:

• AuthScheme: Set this to APIKey.
• APIKey: Set this to your Missive API token obtained from Settings > API > Tokens.

Rate Limiting

Missive enforces the following rate limits:

• 300 requests per minute
• 900 requests per 15 minutes
• Maximum 5 concurrent requests

Available Tables

The Missive profile provides access to the following tables:

• Organizations - Organization data
• Users - User information
• Teams - Team structures
• Conversations - Conversation threads
• Messages - Individual messages
• Contacts - Contact information
• ContactBooks - Contact book management
• ContactGroups - Contact group organization
• SharedLabels - Shared label definitions
• Responses - Canned responses
• ConversationMessages - Messages within conversations
• ConversationDrafts - Draft messages
• ConversationComments - Comments on conversations
• ConversationPosts - Posts within conversations

Usage Examples

ContactBooks:

SELECT * FROM ContactBooks

ContactGroups:

SELECT * FROM ContactGroups WHERE ContactBookId = 'book123' AND Kind = 'group'

Contacts:

SELECT * FROM Contacts WHERE ContactBook = 'book123'

ConversationComments:

SELECT * FROM ConversationComments WHERE ConversationId = 'conv123'

ConversationDrafts:

SELECT * FROM ConversationDrafts WHERE ConversationId = 'conv123'

ConversationMessages:

SELECT * FROM ConversationMessages WHERE ConversationId = 'conv123'

ConversationPosts:

SELECT * FROM ConversationPosts WHERE ConversationId = 'conv123'

Conversations(At least one mailbox filter is required):

SELECT * FROM Conversations

Messages:

SELECT * FROM Messages WHERE EmailMessageId = 'msg123'

Organizations:

SELECT * FROM Organizations

Responses:

SELECT * FROM Responses

SharedLabels:

SELECT * FROM SharedLabels

Teams:

SELECT * FROM Teams

Users:

SELECT * FROM Users

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 Missive API token from Settings > API > Tokens.
AuthScheme	The scheme used for authentication. Accepted entries are APIKey or None. Allowed values are: BASIC, NONE, NTLM, OAUTH, APIKEY, OAUTH_CLIENT