SSIS Components for TSheets

Build 23.0.8839


Gets an authentication token from TSheets.


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.

使用できる値は次のとおりです。APP, WEB


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.


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) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839