Configure a Connection Profile

From the CData ribbon, click Get Data and select From Linear connection/s to launch the CData Query window. To setup a new connection, you will have to click the New Linear Connection button. Here you can set the connection settings, test the connection, and save the connection profile.

Connecting to Linear

You can authenticate to Linear with a personal API key or with OAuth 2.0.

• API Key: The simplest option. Use it to connect with your own Linear account.
• OAuth (authorization code): Authenticate an application on behalf of a Linear user. Set AuthScheme to OAuth.
• OAuth (client credentials): Authenticate the application itself, for app-owned (machine-to-machine) access with no user interaction. Set AuthScheme to OAuthClient.

Authenticate with an API Key

To connect with a personal API key, set the following:

• AuthScheme: APIKey.
• APIKey: A Linear personal API key.

To create a personal API key:

1. Log in to Linear and open Settings > Security & access > Personal API keys.
2. Select New API key, name it, and create it.
3. Copy the key immediately. Linear shows it only once.

Authenticate with OAuth

The add-in supports the OAuth 2.0 authorization code grant. All OAuth flows require a custom OAuth application registered in Linear.

See Creating a Custom OAuth Application for the steps to create one.

Client Credentials

Use the client credentials grant to authenticate the application itself, with no user sign-in. This is suited to backend or machine-to-machine integrations that act as the OAuth application rather than on behalf of a specific user.

Set the following and connect:

• AuthScheme: OAuthClient.
• OAuthClientId: The Client ID from your OAuth application.
• OAuthClientSecret: The Client Secret from your OAuth application.

Note: To request specific OAuth scopes, set Scope to a comma-separated list (for example, read,write). When omitted, the add-in requests read,write. Scope is optional and is not a standard connection property.

No browser interaction or callback URL is required. The add-in obtains an access token directly from the Linear token endpoint and refreshes it automatically.

Desktop Applications

After registering a custom OAuth application, set the following and connect:

• OAuthClientId: The Client ID from your OAuth application.
• OAuthClientSecret: The Client Secret from your OAuth application.
• CallbackURL: The Callback URL defined in your OAuth application (for example, http://localhost:33333).

Note: To request specific OAuth scopes, set Scope to a comma-separated list (for example, read,write). When omitted, the add-in requests read,write. Scope is optional and is not a standard connection property.

When you connect, the add-in opens Linear's OAuth endpoint in your default browser. Log in and grant access to the application.

Connection Properties

The Connection properties describe the various options that can be used to establish a connection.

Managing Connections

After successfully authenticating to Linear you will be able to customize the data you are importing. To learn more about this, see Managing Connections.

See Also

• Querying Data: Use the data selection wizard to pull data into a spreadsheet. You can also configure scheduled data refresh here.
• Using the Excel Add-In: Find other ways to interact with Linear data, such as using the available CData Excel Functions.