ADO.NET Provider for Twitter

Build 21.0.7930


When to Use a Custom OAuth App

Creating a custom OAuth app is required in the web flow. Creating a custom OAuth app is optional for desktop and headless applications; the 本製品 is already registered with Twitter and you can connect with its embedded credentials.

You might want to create a custom OAuth app to change the information displayed when users log into Twitter to grant permissions to the 本製品.

Desktop Authentication with a Custom OAuth App

Follow the steps below to authenticate with the credentials for a custom OAuth app. See カスタムOAuth アプリの作成 for more information.

Get and Refresh the OAuth Access Token

After setting the following connection properties, you are ready to connect:

  • OAuthClientId: Set this to the client Id in your app settings.
  • OAuthClientSecret: Set this to the secret in your app settings.
  • CallbackURL: Set this to the OAuth Redirect URL that you specified to use your own OAuth app.
  • InitiateOAuth: Set this to GETANDREFRESH. You can use InitiateOAuth to avoid repeating the OAuth exchange and manually setting the OAuthAccessToken connection property.
When you connect the 本製品 opens the OAuth endpoint in your default browser. Log in and grant permissions to the application. The 本製品 then completes the OAuth process:
  1. Extracts the access token from the callback URL and authenticates requests.
  2. Refreshes the access token when it expires.
  3. Saves OAuth values in OAuthSettingsLocation to be persisted across connections.

Authenticate to Twitter from a Web Application

When connecting via a Web application, or if the 本製品 is not authorized to open a browser window, use stored procedures and set InitiateOAuth to manage the temporary OAuth tokens.

Get an Access Token

To obtain the access token, set the following connection properties:
  • OAuthClientId: Set this to the ClientId that you received.
  • OAuthClientSecret: Set this to the ClientSecret that you received.

With these properties set, follow the steps below to call stored procedures to obtain the OAuthAccessToken:

  1. Call GetOAuthAuthorizationURL. The stored procedure returns the URL to the OAuth endpoint, along with the request token and secret.
  2. Go to that URL and log in to authorize the application. Afterwards, you are redirected back to the callback URL.

    When you are redirected, the callback URL contains the code query string parameter.

  3. Set the following parameters and call GetOAuthAccessToken:

    VerifierSet this to the verifier code.

Connect to Data

Set the following to authenticate your requests for data:

  • OAuthAccessToken: Set this to the OAuthAccessToken returned by the GetOAuthAccessToken stored procedure.

Refresh the Token

You can set InitiateOAuth to REFRESH to automatically refresh the OAuth access token when it expires.

To connect to data and automatically refresh the OAuthAccessToken, set the following on the first data connection:

  • InitiateOAuth
  • OAuthSettingsLocation
  • OAuthClientId
  • OAuthClientSecret
  • OAuthAccessToken
  • OAuthRefreshToken

On subsequent data connections, set the following:

  • InitiateOAuth
  • OAuthSettingsLocation

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930