Lyftron CampaignMonitor Provider
The Lyftron API Profile for CampaignMonitor allows you to query data from CampaignMonitor. The CampaignMonitor profile is a single file (i.e. campaignmonitor.apip) which is meant to be used with the Lyftron API Driver. The profile contains the table definitions and other CampaignMonitor specific metadata that the Lyftron API Driver uses to connect to CampaignMonitor.
To use the CampaignMonitor Profile set the Profile property of Lyftron API Driver to the path of the CampaignMonitor profile, as well as the other connection properties specified in the documentation below. Once the Lyftron API Driver has been configured, you can issue SQL queries to access data from any of the CampaignMonitor Tables.
Connecting to CampaignMonitor
To authenticate to CampaignMonitor, you can use either Basic authentication or the OAuth standard. Use Basic to connect to your own data. Use OAuth to allow other users to connect to their data.
Using Basic Authentication
To use Basic Authentication, set User connection property to your API Key and Password can be blank or a dummy value.
Using OAuth Authentication
First you need to register an OAuth app with CampaignMonitor. To do this, log into your Campaign Monitor account, click App store in the top navigation (you may need to select a client first to see the option), then select OAuth Registration in the right sidebar. From there you will be asked for a few details to register your OAuth app.
After setting the following in ProfileSettings connection property, you are ready to connect:
- OAuthClientId: Set this to the Client Id of your app.
- OAuthClientSecret: Set this to the Client Secret of your app.
- CallbackURL: Set this to the Redirect URI you specified when applied for an app with CampaignMonitor.
- InitiateOAuth: Set this to GETANDREFRESH. You can use InitiateOAuth to manage the process to obtain the OAuthAccessToken.