Lyftron Insightly Provider
The Lyftron API Profile for Insightly allows you to query data from Insightly. The Insightly profile is a single file (i.e. insightly.apip) which is meant to be used with the Lyftron API Driver. The profile contains the table definitions and other Insightly specific metadata that the Lyftron API Driver uses to connect to Insightly.
To use the Insightly Profile set the Profile property of Lyftron API Driver to the path of the Insightly 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 Insightly Tables.
Connecting to Insightly
The Insightly API uses an API Key based authentication. To get your API token, click the profile icon in Insightly and select User Settings. Scroll to the bottom of the page to find the key.