Workflow Webhook Subscription

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

Table Type: Company

Table Name: Workflow Webhook Subscription
Database Table Name: CRONUS UK Ltd_$Workflow Webhook Subscription$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 469

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Workflow Webhook Subscription$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Id]
   ,[WF Definition Id]
   ,[Conditions]
   ,[Notification Url]
   ,[Enabled]
   ,[User Id]
   ,[Client Id]
   ,[Client Type]
   ,[Event Code]
   ,[Created Date]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Workflow Webhook Subscription$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Workflow Webhook Subscription table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Id Primary Key Searchuniqueidentifier
3WF Definition Id Searchnvarchar(40)
4Conditions Searchimage
5Notification Url Searchimage
6Enabled Searchtinyint
7User Id Searchnvarchar(100)
8Client Id Searchuniqueidentifier
9Client Type Searchnvarchar(100)
10Event Code Searchnvarchar(256)
11Created Date Searchdatetime
12$systemId Searchuniqueidentifier
13$systemCreatedAt Searchdatetime
14$systemCreatedBy Searchuniqueidentifier
15$systemModifiedAt Searchdatetime
16$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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