Lyftrondata Jumpseller Provider
The Lyftrondata API Profile for Jumpseller allows you to query data from Jumpseller. The Jumpseller profile is a single file (i.e. jumpseller.apip) which is meant to be used with the Lyftrondata API Driver. The profile contains the table definitions and other Jumpseller specific metadata that the Lyftrondata API Driver uses to connect to Jumpseller.
To use the Jumpseller Profile set the Profile property of Lyftrondata API Driver to the path of the Jumpseller profile, as well as the other connection properties specified in the documentation below. Once the Lyftrondata API Driver has been configured, you can issue SQL queries to access data from any of the Jumpseller Tables.
Connecting to Jumpseller
Jumpseller utilizes the OAuth 2.0 protocol for authentication. The API Profile supports automatically retrieving and refreshing tokens by setting the connection property InitiateOAuth to GETANDREFRESH.
You will first need to register an OAuth application for your account. Once registered, you will receive a client ID and a client secret for your app. Set the connection properties "OAuthClientId" to your client ID, "OAuthClientSecret" to your client secret, and "RedirectURL" to the callback URL that you set for your app. To have the driver automatically retrieve and refresh tokens for you, set "InitiateOAuth" to _GETANDREFRESH_. See below for instructions on registering your application.
Register an OAuth Application
You will first need to register an OAuth application for your account. To do so, navigate to the Apps section from within the administrative section of your online store. Click Developers, then Add Application, and fill out the form. For desktop-based authentication, set Callback URL to http://localhost:33333. Your app will be assigned a Client ID and a Client Secret. Set these in your connection string via the OAuthClientId and OAuthClientSecret properties. More information on setting up an OAuth application can be found at https://jumpseller.com/support/apps/.