Connecting to Demio

The Demio API uses API Key and API Secret authentication.

Using API Key Authentication

Your Demio API Key and API Secret are required to create a connection to Demio. API credentials can be obtained from Account Settings > API section in your Demio account (requires Owner status). Once you have obtained those properties, set them in the ProfileSettings connection property.

Example Connection string

Profile=C:\profiles\Demio.apip;ProfileSettings='APIKey=my_api_key;APISecret=my_api_secret;'AuthScheme=APIKey;

Usage Examples

Event:

SELECT * FROM Event WHERE Id = '953018'

EventDate:

SELECT * FROM EventDate WHERE EventId = '953023' AND DateId = '5989889'

EventDateParticipants:

SELECT * FROM EventDateParticipants WHERE DateId = '5989889'

Events:

SELECT * FROM Events

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