Lyftron Pipedrive Provider
The Lyftron API Profile for Pipedrive allows you to query data from Pipedrive. The Pipedrive profile is a single file (i.e. pipedrive.apip) which is meant to be used with the Lyftron API Driver. The profile contains the table definitions and other Pipedrive specific metadata that the Lyftron API Driver uses to connect to Pipedrive.
To use the Pipedrive Profile set the Profile property of Lyftron API Driver to the path of the Pipedrive 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 Pipedrive Tables.
Connecting to Pipedrive
You need your API key to connect to Pipedrive. It can be obtained by navigating to Settings > Customize > Personal > Other > API. Set the profile setting APIKey to this value.