Lyftron Drip Provider
The Lyftron API Profile for Drip allows you to query data from Drip. The Drip profile is a single file (i.e. drip.apip) which is meant to be used with the Lyftron API Driver. The profile contains the table definitions and other Drip specific metadata that the Lyftron API Driver uses to connect to Drip.
To use the Drip Profile set the Profile property of Lyftron API Driver to the path of the Drip 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 Drip Tables.
Connecting to Drip
To authenticate to Drip, 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, specify your Api-Key within the ProfileSettings connection property. Api-Key should be set to your Drip personal API Token.
Using OAuth Authentication
First register an OAuth2 application with Drip. Drip will then supply you with a client id and client secret. Please be aware that you must also enter a valid callback url before you will be able to activate your application.
After setting the following connection properties, you are ready to connect:
- OAuthClientId: Set this to the client id that you got in your app settings.
- OAuthClientSecret: Set this to the client secret that you got in your app settings.
- CallbackURL: Set this to the Redirect URI you specified in your app settings.
- InitiateOAuth: Set this to GETANDREFRESH. You can use InitiateOAuth to manage the process to obtain the OAuthAccessToken.