ODBC Driver for TSheets

Build 22.0.8462

GetOAuthAccessToken

Gets an authentication token from TSheets.

Input

Name Type Required Description
AuthMode String False The type of authentication mode to use. Select App for getting authentication tokens via a desktop app. Select Web for getting authentication tokens via a Web app.

The allowed values are APP, WEB.

The default value is APP.

CallbackUrl String False The URL the user will be redirected to after authorizing your application. Set this to the HTTPS url that you submitted as the 'OAuth Redirect URI' when you set up your app in the TSheets API Add-On.
Verifier String False The verifier returned from Azure AD after the user has authorized your app to have access to their data. This value will be returned as a parameter to the callback URL.
State String False An arbitrary string of your choosing that is returned to your app; a successful roundtrip of this string helps ensure that your app initiated the request.

The default value is test.

Result Set Columns

Name Type Description
OAuthAccessToken String The access token used for communication with TSheets.
ExpiresIn String The remaining lifetime on the access token. A -1 denotes that it will not expire.
OAuthRefreshToken String Refresh token to renew the access token.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462