API Webhook Notification

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/2000000096

Table Type: System

Table Name: API Webhook Notification
Database Table Name: API Webhook Notification

Table Number: 2000000096

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 API Webhook Notification can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [API Webhook Notification]

Show/hide an example select of all columns by name

SELECT
   [ID]
   ,[Subscription ID]
   ,[Created By User SID]
   ,[Entity Key Value]
   ,[Last Modified Date Time]
   ,[Change Type]
   ,[Entity ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [API Webhook Notification]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [API Webhook Notification] AS [API Webhook Notification]
LEFT JOIN
   [External Event Subscription] AS [External Event Subscription]
      ON
         [API Webhook Notification].[Subscription Id] = [External Event Subscription].[ID]
LEFT JOIN
   [User] AS [User]
      ON
         [API Webhook Notification].[Created By User SID] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [API Webhook Notification].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [API Webhook Notification].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in API Webhook Notification table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1ID Primary Key SearchIDNormalGUID16IDuniqueidentifier
2Subscription ID SearchSubscription IDNormalText150Subscription IDnvarchar(300)
Key to join to the External Event Subscription table.

Show/hide example query

SELECT
       [API Webhook Notification].[Subscription ID]
       ,[External Event Subscription].[ID]
FROM
       [API Webhook Notification] AS [API Webhook Notification]
LEFT JOIN
       [External Event Subscription] AS [External Event Subscription]
              ON
                     [API Webhook Notification].[Subscription ID] = [External Event Subscription].[ID]
3Created By User SID SearchCreated By User SIDNormalGUID16Created By User SIDuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [API Webhook Notification].[Created By User SID]
       ,[User].[User Security ID]
FROM
       [API Webhook Notification] AS [API Webhook Notification]
LEFT JOIN
       [User] AS [User]
              ON
                     [API Webhook Notification].[Created By User SID] = [User].[User Security ID]
4Entity Key Value SearchEntity Key ValueNormalText250Entity Key Valuenvarchar(500)
5Last Modified Date Time SearchLast Modified Date TimeNormalDateTime8Last Modified Date Timedatetime
6Change Type SearchChange TypeNormalOption4Change Typeint
Available options are:
  • “Created”
  • “Updated”
  • “Deleted”
  • “Collection”
9Entity ID SearchEntity IDNormalGUID16Entity IDuniqueidentifier
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
       [API Webhook Notification].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [API Webhook Notification] AS [API Webhook Notification]
LEFT JOIN
       [User] AS [User]
              ON
                     [API Webhook Notification].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [API Webhook Notification].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [API Webhook Notification] AS [API Webhook Notification]
LEFT JOIN
       [User] AS [User]
              ON
                     [API Webhook Notification].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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