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 connector 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. |