Connecting to Pushbullet

Using API Key Authentication

Pushbullet uses token-based authentication (Access Token). To obtain an Access Token:

1. Log in to your Pushbullet account at https://www.pushbullet.com
2. Navigate to Settings > Account
3. Click "Create Access Token"
4. Copy the generated token

After obtaining your Access Token, set the following connection properties:

• AuthScheme: Set this to APIKey.

Set the following in the ProfileSettings connection property:

• APIKey: Set this to your Pushbullet Access Token.

Example Connection String

Profile=C:\profiles\Pushbullet.apip;ProfileSettings='APIKey=your_access_token;';AuthScheme=APIKey;

Connecting to Pushbullet

Once the authentication is configured, you can connect to Pushbullet and query data from any of the available tables such as Users, Pushes, Devices, Chats, Subscriptions, and Channels.

Available Tables

The Pushbullet API Profile provides access to the following tables:

• Users: Returns profile information for the authenticated Pushbullet user
• Pushes: Returns push notifications sent to and from the authenticated user. Optionally filter by Id to retrieve a specific push
• Devices: Returns devices registered to the authenticated Pushbullet user
• Chats: Returns direct message chat threads for the authenticated user
• Subscriptions: Returns channel subscriptions for the authenticated user
• Channels: Returns metadata for a Pushbullet channel (requires ChannelTag)

Important Notes

• The Pushbullet API uses cursor-based pagination via the cursor response field for list endpoints.
• The Channels table requires a ChannelTag filter to retrieve channel metadata.
• Timestamp fields (CreatedAt, ModifiedAt) are stored as Unix timestamps and converted to datetime format.
• The Pushes table supports filtering by ModifiedAt using the modified_after parameter.
• Rate limiting applies - refer to the Pushbullet API documentation for current limits.

API Documentation

For more information about the Pushbullet API, see the official Pushbullet API documentation.

Usage Examples

Users:

SELECT * FROM Users

Pushes:

SELECT * FROM Pushes

Pushes (by Id):

SELECT * FROM Pushes WHERE Id = 'push-iden'

Devices:

SELECT * FROM Devices

Chats:

SELECT * FROM Chats

Subscriptions:

SELECT * FROM Subscriptions

Channels:

SELECT * FROM Channels WHERE ChannelTag = 'pushbullet'

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	The API key used for authentication with the Pushbullet API.
AuthScheme	The scheme used for authentication. Accepted entries are APIKey or None. Allowed values are: BASIC, NONE, NTLM, OAUTH, APIKEY, OAUTH_CLIENT