Connecting to Beeminder

Using API Key Authentication

Beeminder uses API Key authentication. To obtain your API key, log in to your Beeminder account and navigate to Settings > Account > Personal Auth Token. Copy the auth_token value for use in the connection string.

After setting the following connection properties, you are ready to connect:

AuthScheme: Set this to APIKey.
AuthToken: Set this to your personal auth token obtained from Beeminder account settings.

Available Tables

The Beeminder API Profile provides access to the following tables:

Users: Access user account information and settings
Goals: Query active goals with progress tracking and commitment details
ArchivedGoals: Access archived (completed or failed) goals
Datapoints: Query datapoints for specific goals with timestamp and value tracking

Usage Examples

ArchivedGoals:

SELECT * FROM ArchivedGoals WHERE Username = 'your_username'

Datapoints:

SELECT * FROM Datapoints WHERE Username = 'your_username' AND GoalSlug = 'goal_slug'

Goals:

SELECT * FROM Goals WHERE Username = 'your_username'

Users:

SELECT * FROM Users

Required Input Parameters

Some tables require input parameters in the WHERE clause:

Goals: Requires Username parameter
ArchivedGoals: Requires Username parameter
Datapoints: Requires Username and GoalSlug parameters

API Documentation

For more information about the Beeminder API, visit: https://api.beeminder.com

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