Connecting to Demio

Using API Key Authentication

Demio uses API Key and API Secret authentication. To obtain your credentials:

Log into your Demio account.
Navigate to Account Settings > API. This section requires Owner-level access.
Copy the API Key and API Secret shown on the page.

After obtaining your credentials, set the following connection properties:

AuthScheme: Set this to APIKey.
APIKey: Set this to your Demio API Key (passed via ProfileSettings).
APISecret: Set this to your Demio API Secret (passed via ProfileSettings).

Example Connection String

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

Connecting to Demio

Once authentication is configured, you can connect to Demio and read and write data through the available tables. Most tables (Events, Event, EventDate) support SELECT. EventDateParticipants additionally supports INSERT to register participants.

Available Tables

The Demio API Profile provides access to the following tables:

Events: Retrieve a list of all webinar events; optionally filter by Type (upcoming, past, automated)
Event: Retrieve detailed information for a single event, including all scheduled sessions (requires Id)
EventDate: Retrieve date and time details for a specific event session (requires EventId and DateId)
EventDateParticipants: Retrieve participants for a specific event session (SELECT requires DateId); register a new participant (INSERT requires Email, Name, and EventId; DateId is optional)

Important Notes

The Event table requires Id to be specified in the WHERE clause.
The EventDate table requires both EventId and DateId to be specified in the WHERE clause.
The EventDateParticipants table requires DateId in the WHERE clause for SELECT. To register a participant (INSERT), Email, Name, and EventId are required.
API credentials require Owner-level access in your Demio account.

API Documentation

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

Usage Examples

Events:

SELECT * FROM Events

Events (filtered by type):

SELECT * FROM Events WHERE Type = 'upcoming'

Event:

SELECT * FROM Event WHERE Id = '953018'

EventDate:

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

EventDateParticipants:

SELECT * FROM EventDateParticipants WHERE DateId = '5989889'

INSERT INTO EventDateParticipants (Email, Name, EventId) VALUES ('[email protected]', 'John Doe', '953018')

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, OAUTH_PASSWORD