Connecting to ProductBoard

Authentication

To authenticate to ProductBoard, 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 ProductBoard workspace 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 ProductBoard.

Available Tables

The ProductBoard API Profile provides access to comprehensive product management data across 31 specialized tables:

Features - Query product features and functionality management with status, priority, and component relationships.
Notes - Retrieve user notes and feedback including opportunities, conversations, and content variations.
Companies - Access company data and information management with user counts and custom fields.
Users - Query user management system with roles, activity tracking, and company associations.
Initiatives - Access strategic initiative management and tracking with timeframes and status information.
Objectives - Query strategic objectives and goal management with hierarchy levels and progress tracking.
KeyResults - Retrieve key result tracking and progress measurement with start, target, and current values.
Releases - Access release management and scheduling system with timeframes and state tracking.
Products - Query product catalog and management system with owner and HTML links.
Components - Access product components and organizational structure with feature relationships.
CustomFields - Query custom field definitions and metadata for hierarchy entities.
CustomFieldValues - Access custom field value assignments for hierarchy entities.
ReleaseGroups - Query release group organization and management system.
Tags - Query entity tagging system for notes and features with aggregated tag values.
Links - Access entity linking system for notes and features with type filtering.
CompanyFields - Query company custom field definitions and configuration.
CompanyFieldValues - Query company-specific custom field values and assignments.
FeatureStatus - Access feature status definitions and completion indicators.
FeatureReleaseAssignment - Query feature to release assignment mapping and relationships.
SpecificInitiativeFeature - Access features associated with specific initiatives.
SpecificInitiativeObjective - Query objectives associated with specific initiatives.
SpecificObjectiveFeature - Access features associated with specific objectives.
FeedbackFormConfigurations - Query feedback form configuration settings including custom fields and options.
PluginIntegrations - Access plugin integration management and configuration settings.
PluginIntegrationConnections - Query plugin integration connections between features and external systems.
JiraIntegrations - Access Jira integration management and configuration settings.
JiraIntegrationConnections - Query Jira integration connections between features and Jira issues.

Usage Examples

Query active features:

SELECT * FROM Features WHERE IsArchived = false

Query companies by search term:

SELECT * FROM Companies WHERE Term = 'acme'

Query notes by company:

SELECT * FROM Notes WHERE CompanyId = 'comp_123'

Query all products:

SELECT * FROM Products

Query all users:

SELECT * FROM Users

Query all initiatives:

SELECT * FROM Initiatives

Query all objectives:

SELECT * FROM Objectives

Query all key results:

SELECT * FROM KeyResults

Query all releases:

SELECT * FROM Releases

Query features for specific initiative:

SELECT * FROM SpecificInitiativeFeature WHERE InitiativeId = 'init_123'

Query company field values:

SELECT * FROM CompanyFieldValues WHERE CompanyId = 'comp_123' AND FieldId = 'field_1234'

Query all feedback form configurations:

SELECT * FROM FeedbackFormConfigurations

Query all plugin integrations:

SELECT * FROM PluginIntegrations

Query plugin integration connections:

SELECT * FROM PluginIntegrationConnections WHERE IntegrationId = 'int_123'

Query all Jira integrations:

SELECT * FROM JiraIntegrations

Query Jira integration connections by issue key:

SELECT * FROM JiraIntegrationConnections WHERE IntegrationId = 'int_123' AND ConnectionIssueKey = 'PROJ-123'

Query all components:

SELECT * FROM Components

Query custom fields by type:

SELECT * FROM CustomFields WHERE Type = 'text'

Query custom field values by field and entity:

SELECT * FROM CustomFieldValues WHERE CustomFieldId = 'field_123' AND HierarchyEntityId = 'entity_123'

Query all release groups:

SELECT * FROM ReleaseGroups

Query tags for specific note:

SELECT * FROM Tags WHERE NoteId = 'note_123'

Query links for specific note:

SELECT * FROM Links WHERE NoteId = 'note_123'

Query all company fields:

SELECT * FROM CompanyFields

Query all feature statuses:

SELECT * FROM FeatureStatus

Query feature release assignments by release state:

SELECT * FROM FeatureReleaseAssignment WHERE ReleaseState = 'current'

Query objectives for specific initiative:

SELECT * FROM SpecificInitiativeObjective WHERE InitiativeId = 'init_123'

Query features for specific objective:

SELECT * FROM SpecificObjectiveFeature WHERE ObjectiveId = 'obj_123'

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