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
   [timestamp]
   ,[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 columns in API Webhook Notification table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2ID Primary Key Searchuniqueidentifier
3Subscription ID Searchnvarchar(300)
4Created By User SID Searchuniqueidentifier
5Entity Key Value Searchnvarchar(500)
6Last Modified Date Time Searchdatetime
7Change Type Searchint
8Entity ID Searchuniqueidentifier
9$systemId Searchuniqueidentifier
10$systemCreatedAt Searchdatetime
11$systemCreatedBy Searchuniqueidentifier
12$systemModifiedAt Searchdatetime
13$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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