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
Show/hide an example select of all columns by name
Show/hide an example select of all columns including those from all joined tables
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 query | |||||||
2000000003 | SystemModifiedAt ![]() | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
2000000004 | SystemModifiedBy ![]() | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |