Connecting to Perigon
Using API Key Authentication
To use the Perigon API, you need to obtain an API key from your Perigon account. Navigate to the Perigon dashboard and generate an API key from your account settings.
After setting the following connection properties, you are ready to connect:
- AuthScheme: Set this to APIKey.
- APIKey: Set this to your Perigon API key.
Example connection string:
Profile=C:\profiles\Perigon.apip;AuthScheme=APIKey;ProfileSettings="APIKey=your_api_key"
Available Tables
The Perigon profile provides access to the following tables:
- Articles - News articles retrieved from the Perigon news intelligence API
- Headlines - Story clusters grouping related headline articles
- Sources - News sources tracked by the Perigon news intelligence API
- Journalists - Journalist profiles tracked by the Perigon news intelligence API
Usage Examples
Articles:
SELECT * FROM Articles
Headlines:
SELECT * FROM Headlines
Journalists:
SELECT * FROM Journalists
Sources:
SELECT * FROM Sources
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 for your Perigon account. |
| AuthScheme | The scheme used for authentication. Accepted entries are APIKey or None. Allowed values are: BASIC, NONE, NTLM, OAUTH, APIKEY, OAUTH_CLIENT |