Lyftrondata Wrike Provider
The Lyftrondata API Profile for Wrike allows you to query data from Wrike. The Wrike profile is a single file (i.e. wrike.apip) which is meant to be used with the Lyftrondata API Driver. The profile contains the table definitions and other Wrike specific metadata that the Lyftrondata API Driver uses to connect to Wrike.
To use the Wrike Profile set the Profile property of Lyftrondata API Driver to the path of the Wrike 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 Wrike Tables.
Connecting to Wrike
To authenticate to Wrike, you can use either Permanent Token authentication or the OAuth standard. Use Permanent Token authentication to connect to your own data. Use OAuth to allow other users to connect to their data.
Using Permanent Token authentication
To use Permanent Token authentication, specify your Api-Key in the ProfileSettings connection property. Set this to your Wrike Permanent Token. To receive a permanent token you need to open your application on the App Console and click 'Obtain token'.
Using OAuth Authentication
First you will need to register and properly set up the Wrike API application. You can find the client credentials of your application and manage other options on App Console.
After setting the following in ProfileSettings connection property, you are ready to connect:
- OAuthClientId: Set this to the client id that you received upon app registration.
- OAuthClientSecret: Set this to the client secret that you received upon app registration.
- CallbackURL: Set this to the Redirect URI you specified in your app.
- InitiateOAuth: Set this to GETANDREFRESH. You can use InitiateOAuth to manage the process to obtain the OAuthAccessToken.