Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/2000000199
Table Type: System
Table Name: Webhook Subscription
Database Table Name: Webhook Subscription
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 Webhook Subscription can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[Webhook Subscription]Show/hide an example select of all columns by name
SELECT
[Subscription ID]
,[Endpoint]
,[Client State]
,[Created By]
,[Run Notification As]
,[Company Name]
,[Application ID]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[Webhook Subscription]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[Webhook Subscription] AS [Webhook Subscription]
LEFT JOIN
[External Event Subscription] AS [External Event Subscription]
ON
[Webhook Subscription].[Subscription Id] = [External Event Subscription].[ID]
LEFT JOIN
[User] AS [User]
ON
[Webhook Subscription].[Created By] = [User].[User Name]
LEFT JOIN
[Company] AS [Company]
ON
[Webhook Subscription].[Company Name] = [Company].[Name]
LEFT JOIN
[User] AS [User]
ON
[Webhook Subscription].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[Webhook Subscription].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in Webhook Subscription table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Subscription ID   | Subscription ID | Normal | Text | 150 | Subscription ID | nvarchar(300) |
Key to join to the External Event Subscription table.Show/hide example querySELECT
[Webhook Subscription].[Subscription ID]
,[External Event Subscription].[ID]
FROM
[Webhook Subscription] AS [Webhook Subscription]
LEFT JOIN
[External Event Subscription] AS [External Event Subscription]
ON
[Webhook Subscription].[Subscription ID] = [External Event Subscription].[ID] | |||||||
| 2 | Endpoint | Endpoint | Normal | Text | 250 | Endpoint | nvarchar(500) |
| 3 | Client State | Client State | Normal | Text | 50 | Client State | nvarchar(100) |
| 4 | Created By | Created By | Normal | Code | 50 | Created By | nvarchar(100) |
Key to join to the User table.Show/hide example querySELECT
[Webhook Subscription].[Created By]
,[User].[User Name]
FROM
[Webhook Subscription] AS [Webhook Subscription]
LEFT JOIN
[User] AS [User]
ON
[Webhook Subscription].[Created By] = [User].[User Name] | |||||||
| 5 | Run Notification As | Run Notification As | Normal | GUID | 16 | Run Notification As | uniqueidentifier |
| 6 | Company Name | Company Name | Normal | Text | 30 | Company Name | nvarchar(60) |
Key to join to the Company table.Show/hide example querySELECT
[Webhook Subscription].[Company Name]
,[Company].[Name]
FROM
[Webhook Subscription] AS [Webhook Subscription]
LEFT JOIN
[Company] AS [Company]
ON
[Webhook Subscription].[Company Name] = [Company].[Name] | |||||||
| 7 | Application ID | Application ID | Normal | Text | 20 | Application ID | nvarchar(40) |
| 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
[Webhook Subscription].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[Webhook Subscription] AS [Webhook Subscription]
LEFT JOIN
[User] AS [User]
ON
[Webhook Subscription].[$systemCreatedBy] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[Webhook Subscription].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[Webhook Subscription] AS [Webhook Subscription]
LEFT JOIN
[User] AS [User]
ON
[Webhook Subscription].[$systemModifiedBy] = [User].[User Security ID] | |||||||