Webhook Subscription – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables System Tables WWebhook Subscription

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

Table Number: 2000000199

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 query SELECT [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 query SELECT [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 query SELECT [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)
	Key to join to the Installed Application table. Show/hide example query SELECT [Webhook Subscription].[Application ID] ,[Installed Application].[Package ID] FROM [Webhook Subscription] AS [Webhook Subscription] LEFT JOIN [] AS [Installed Application] ON [Webhook Subscription].[Application ID] = [Installed Application].[Package ID]
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 SELECT [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

Dynamics 365 BC Table Reference Tables System Tables WWebhook Subscription

Leave a Reply Cancel reply