API Webhook Notification Aggr

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

Table Type: System

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

Table Number: 2000000098

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 Aggr can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [API Webhook Notification Aggr]

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]
   ,[Attempt No_]
   ,[Sending Scheduled Date Time]
   ,[Entity ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [API Webhook Notification Aggr]

Show/hide columns in API Webhook Notification Aggr 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
8Attempt No_ Searchint
9Sending Scheduled Date Time Searchdatetime
10Entity ID Searchuniqueidentifier
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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