API Webhook Subscription

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

Table Type: System

Table Name: API Webhook Subscription
Database Table Name: API Webhook Subscription

Table Number: 2000000095

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [API Webhook Subscription]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Subscription Id]
   ,[Entity Publisher]
   ,[Entity Group]
   ,[Entity Version]
   ,[Entity Set Name]
   ,[Company Name]
   ,[Notification Url Blob]
   ,[User Id]
   ,[Last Modified Date Time]
   ,[Client State]
   ,[Expiration Date Time]
   ,[Resource Url Blob]
   ,[Notification Url Prefix]
   ,[Source Table Id]
   ,[Subscription Type]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [API Webhook Subscription]

Show/hide columns in API Webhook Subscription table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Subscription Id Primary Key Searchnvarchar(300)
3Entity Publisher Searchnvarchar(80)
4Entity Group Searchnvarchar(80)
5Entity Version Searchnvarchar(20)
6Entity Set Name Searchnvarchar(500)
7Company Name Searchnvarchar(60)
8Notification Url Blob Searchimage
9User Id Searchuniqueidentifier
10Last Modified Date Time Searchdatetime
11Client State Searchnvarchar(4096)
12Expiration Date Time Searchdatetime
13Resource Url Blob Searchimage
14Notification Url Prefix Searchnvarchar(500)
15Source Table Id Searchint
16Subscription Type Searchint
17$systemId Searchuniqueidentifier
18$systemCreatedAt Searchdatetime
19$systemCreatedBy Searchuniqueidentifier
20$systemModifiedAt Searchdatetime
21$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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