Webhook Subscription

Dynamics 365 BC Table ReferenceTablesSystem TablesWWebhook 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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Subscription ID SearchSubscription IDNormalText150Subscription IDnvarchar(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]
2Endpoint Primary Key SearchEndpointNormalText250Endpointnvarchar(500)
3Client State Primary Key SearchClient StateNormalText50Client Statenvarchar(100)
4Created By SearchCreated ByNormalCode50Created Bynvarchar(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]
5Run Notification As SearchRun Notification AsNormalGUID16Run Notification Asuniqueidentifier
6Company Name SearchCompany NameNormalText30Company Namenvarchar(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]
7Application ID SearchApplication IDNormalText20Application IDnvarchar(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 SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesSystem TablesWWebhook Subscription

Leave a Reply

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