JDBC Driver for SuiteCRM

Build 22.0.8462

OAuthTokens

Query currently active OAuth tokens

Table Specific Information

Select

You can query the OAuth Tokens table using any criteria in the WHERE clause. The driver will use the SuiteCRM API to filter the results.

SELECT * FROM [OAuth Tokens] WHERE [Callback Url] LIKE '%.net/consume' 

Insert

Create an OAuth Token by specifying any writable column.

INSERT INTO [Oauth Tokens] ([Consumer Name],Consumer,Secret) VALUES ('Testing app','code101','hushSecret3')

Update

You can update any OAuth Token column that is writable, by specifying the Id.

UPDATE [Oauth Tokens] SET TState='1' WHERE Id = 'Test123' 

Delete

Remove an OAuth Token by specifying the Id.

DELETE FROM [OAuth Tokens] WHERE Id = 10003

Columns

Name Type ReadOnly Description
ID [KEY] String False

The unique identifier of the token.

CallbackURL String False

Callback URL given for the token

Consumer String False

Consumer key associated with the token

ConsumerName String True

The consumer name given for the token

Deleted Bool False

The record deletion indicator.

LBL_ASSIGNED_TO_ID String True

The user name of the user the token has been assigned to.

AssignedUserId String False

The Id of the user the token has been assigned to.

Secret String False

Consumer secret associeated with the token

Token_TS String False

Timestamp recorded for the token

TState String False

Current state of the token

Verify String False

Verification status of the token

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Rows@Next String

Identifier for the next page of results. Do not set this value manually.

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