Lyftron Pipeliner Provider
The Lyftron API Profile for Pipeliner allows you to query data from Pipeliner. The Pipeliner profile is a single file (i.e. pipeliner.apip) which is meant to be used with the Lyftron API Driver. The profile contains the table definitions and other Pipeliner specific metadata that the Lyftron API Driver uses to connect to Pipeliner.
To use the Pipeliner Profile set the Profile property of Lyftron API Driver to the path of the Pipeliner 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 Pipeliner Tables.
Connecting to Pipeliner
To connect to Pipeliner, you need an API Token, API Password, Space ID, and Service URL. These values can be otained from your Pipeliner CRM Admin Portal. Open your space then click on the Shop API Access Details to see your keys. Set User to your API Token, Password to your API Password, and the SpaceId and ServiceURL properties in ProfileSettings. For the ServiceUrl, copy the portion after the https://.