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
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
[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 an example select of all columns including those from all joined tables
SELECT
*
FROM
[API Webhook Subscription] AS [API Webhook Subscription]
LEFT JOIN
[External Event Subscription] AS [External Event Subscription]
ON
[API Webhook Subscription].[Subscription Id] = [External Event Subscription].[ID]
LEFT JOIN
[Company] AS [Company]
ON
[API Webhook Subscription].[Company Name] = [Company].[Name]
LEFT JOIN
[User] AS [User]
ON
[API Webhook Subscription].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[API Webhook Subscription].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in API Webhook Subscription table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Subscription Id   | Subscription Id | Normal | Text | 150 | Subscription Id | nvarchar(300) |
Key to join to the External Event Subscription table.Show/hide example querySELECT
[API Webhook Subscription].[Subscription Id]
,[External Event Subscription].[ID]
FROM
[API Webhook Subscription] AS [API Webhook Subscription]
LEFT JOIN
[External Event Subscription] AS [External Event Subscription]
ON
[API Webhook Subscription].[Subscription Id] = [External Event Subscription].[ID] | |||||||
| 2 | Entity Publisher | Entity Publisher | Normal | Text | 40 | Entity Publisher | nvarchar(80) |
| 3 | Entity Group | Entity Group | Normal | Text | 40 | Entity Group | nvarchar(80) |
| 4 | Entity Version | Entity Version | Normal | Text | 10 | Entity Version | nvarchar(20) |
| 5 | Entity Set Name | Entity Set Name | Normal | Text | 250 | Entity Set Name | nvarchar(500) |
| 6 | Company Name | Company Name | Normal | Text | 30 | Company Name | nvarchar(60) |
Key to join to the Company table.Show/hide example querySELECT
[API Webhook Subscription].[Company Name]
,[Company].[Name]
FROM
[API Webhook Subscription] AS [API Webhook Subscription]
LEFT JOIN
[Company] AS [Company]
ON
[API Webhook Subscription].[Company Name] = [Company].[Name] | |||||||
| 7 | Notification Url Blob | Notification Url Blob | Normal | BLOB | 8 | Notification Url Blob | image |
| 8 | User Id | User Id | Normal | GUID | 16 | User Id | uniqueidentifier |
| 9 | Last Modified Date Time | Last Modified Date Time | Normal | DateTime | 8 | Last Modified Date Time | datetime |
| 10 | Client State | Client State | Normal | Text | 2048 | Client State | nvarchar(4096) |
| 11 | Expiration Date Time | Expiration Date Time | Normal | DateTime | 8 | Expiration Date Time | datetime |
| 12 | Resource Url Blob | Resource Url Blob | Normal | BLOB | 8 | Resource Url Blob | image |
| 13 | Notification Url Prefix | Notification Url Prefix | Normal | Text | 250 | Notification Url Prefix | nvarchar(500) |
| 14 | Source Table Id | Source Table Id | Normal | Integer | 4 | Source Table Id | int |
| 15 | Subscription Type | Subscription Type | Normal | Option | 4 | Subscription Type | int |
Available options are:
| |||||||
| 2000000000 | $systemId | System ID | Normal | GUID | 16 | $systemId | uniqueidentifier |
| 2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | $systemCreatedAt | datetime |
| 2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | $systemCreatedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[API Webhook Subscription].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[API Webhook Subscription] AS [API Webhook Subscription]
LEFT JOIN
[User] AS [User]
ON
[API Webhook Subscription].[$systemCreatedBy] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[API Webhook Subscription].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[API Webhook Subscription] AS [API Webhook Subscription]
LEFT JOIN
[User] AS [User]
ON
[API Webhook Subscription].[$systemModifiedBy] = [User].[User Security ID] | |||||||