OAuth 2_0 Setup

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

Table Number: 1140

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
   [timestamp]
   ,[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 columns in OAuth 2_0 Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(40)
3Description Searchnvarchar(500)
4Service URL Searchnvarchar(500)
5Redirect URL Searchnvarchar(500)
6Client ID Searchuniqueidentifier
7Client Secret Searchuniqueidentifier
8Access Token Searchuniqueidentifier
9Refresh Token Searchuniqueidentifier
10Authorization URL Path Searchnvarchar(500)
11Access Token URL Path Searchnvarchar(500)
12Refresh Token URL Path Searchnvarchar(500)
13Scope Searchnvarchar(500)
14Authorization Response Type Searchnvarchar(500)
15Status Searchint
16Token DataScope Searchint
17Activity Log ID Searchint
18Daily Limit Searchint
19Daily Count Searchint
20Latest Datetime Searchdatetime
21Access Token Due DateTime Searchdatetime
22Feature GUID Searchuniqueidentifier
23User ID Searchnvarchar(100)
24$systemId Searchuniqueidentifier
25$systemCreatedAt Searchdatetime
26$systemCreatedBy Searchuniqueidentifier
27$systemModifiedAt Searchdatetime
28$systemModifiedBy Searchuniqueidentifier

Leave a Reply

Your email address will not be published. Required fields are marked *