Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/1140
Table Type: Company
Table Name: OAuth 2.0 Setup
Database Table Name: CRONUS UK Ltd_$OAuth 2_0 Setup$437dbf0e-84ff-417a-965d-ed2bb9650972
Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how OAuth 2.0 Setup can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$OAuth 2_0 Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns by name
SELECT
[Code]
,[Description]
,[Service URL]
,[Redirect URL]
,[Client ID]
,[Client Secret]
,[Access Token]
,[Refresh Token]
,[Authorization URL Path]
,[Access Token URL Path]
,[Refresh Token URL Path]
,[Scope]
,[Authorization Response Type]
,[Status]
,[Token DataScope]
,[Activity Log ID]
,[Daily Limit]
,[Daily Count]
,[Latest Datetime]
,[Access Token Due DateTime]
,[Feature GUID]
,[User ID]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$OAuth 2_0 Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$OAuth 2_0 Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [OAuth 2.0 Setup]
LEFT JOIN
[User] AS [User]
ON
[OAuth 2.0 Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[OAuth 2.0 Setup].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in OAuth 2.0 Setup table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Code  | Code | Normal | Code | 20 | Code | nvarchar(40) |
| 2 | Description  | Description | Normal | Text | 250 | Description | nvarchar(500) |
| 3 | Service URL | Service URL | Normal | Text | 250 | Service URL | nvarchar(500) |
| 4 | Redirect URL | Redirect URL | Normal | Text | 250 | Redirect URL | nvarchar(500) |
| 5 | Client ID | Client ID | Normal | GUID | 16 | Client ID | uniqueidentifier |
| 6 | Client Secret | Client Secret | Normal | GUID | 16 | Client Secret | uniqueidentifier |
| 7 | Access Token | Access Token | Normal | GUID | 16 | Access Token | uniqueidentifier |
| 8 | Refresh Token | Refresh Token | Normal | GUID | 16 | Refresh Token | uniqueidentifier |
| 9 | Authorization URL Path | Authorization URL Path | Normal | Text | 250 | Authorization URL Path | nvarchar(500) |
| 10 | Access Token URL Path | Access Token URL Path | Normal | Text | 250 | Access Token URL Path | nvarchar(500) |
| 11 | Refresh Token URL Path | Refresh Token URL Path | Normal | Text | 250 | Refresh Token URL Path | nvarchar(500) |
| 12 | Scope | Scope | Normal | Text | 250 | Scope | nvarchar(500) |
| 13 | Authorization Response Type | Authorization Response Type | Normal | Text | 250 | Authorization Response Type | nvarchar(500) |
| 14 | Status | Status | Normal | Option | 4 | Status | int |
Available options are:
| |||||||
| 15 | Token DataScope | Token DataScope | Normal | Option | 4 | Token DataScope | int |
Available options are:
| |||||||
| 16 | Activity Log ID | Activity Log ID | Normal | Integer | 4 | Activity Log ID | int |
| 17 | Daily Limit | Daily Limit | Normal | Integer | 4 | Daily Limit | int |
| 18 | Daily Count | Daily Count | Normal | Integer | 4 | Daily Count | int |
| 19 | Latest Datetime | Latest Datetime | Normal | DateTime | 8 | Latest Datetime | datetime |
| 20 | Access Token Due DateTime | Access Token Due DateTime | Normal | DateTime | 8 | Access Token Due DateTime | datetime |
| 21 | Feature GUID | Feature GUID | Normal | GUID | 16 | Feature GUID | uniqueidentifier |
| 22 | User ID | User ID | Normal | Code | 50 | User ID | nvarchar(100) |
| 2000000000 | $systemId | System ID | Normal | GUID | 16 | $systemId | uniqueidentifier |
| 2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | $systemCreatedAt | datetime |
| 2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | $systemCreatedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT [OAuth 2.0 Setup].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$OAuth 2_0 Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [OAuth 2.0 Setup] LEFT JOIN [User] AS [User] ON [OAuth 2.0 Setup].[$systemCreatedBy] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |