Power BI Connector for SugarCRM

Build 25.0.9454

CJ_WebHooks

Stores webhook endpoint configurations for Customer Journey automation events. This table supports real-time system integration and external process triggers.

Columns

Name Type ReadOnly Description
Id [KEY] String False

The unique identifier (Id) for this Customer Journey webhook record. This field ensures reliable referencing across workflows and integrations.

Name String False

The display name of the webhook configuration. This field identifies the webhook in setup and reporting screens.

Date_Entered Datetime True

The date and time when this webhook record was created. This field supports audit and lifecycle tracking.

Date_Modified Datetime True

The date and time when this webhook record was most recently modified. This field supports update and change auditing.

Modified_User_Id String True

The Id of the user who most recently modified this webhook record. This field supports accountability and traceability.

Modified_By_Name String True

The name of the user who most recently modified this webhook record. This field provides a readable reference for the Modified_User_Id field.

Created_By String True

The Id of the user who created this webhook record. This field supports ownership history and audit traceability.

Created_By_Name String True

The name of the user who created this webhook record. This field provides a readable reference for the Created_By field.

Description String False

A full descriptive explanation of the purpose or function of this webhook. This field provides context for how and why the webhook is used.

Deleted Bool False

A Boolean field that returns a value of 'true' when the webhook record is marked for deletion. It returns a value of 'false' when the record remains active. This field supports soft-delete workflows and record retention policies.

Url String False

The endpoint URL to which the webhook sends data when triggered. This field defines the external system being notified.

Error_Message_Path String False

The path in the response payload or metadata that contains error details when webhook execution fails. This field supports error handling and debugging.

Sort_Order Int False

The numeric value that determines the order in which this webhook executes when multiple webhooks are triggered. This field controls execution sequence.

Request_Method String False

The HTTP method that is used when executing the webhook request' (for example, 'POST' or 'PUT'). This field defines how data is transmitted to the external system.

Request_Format String False

The data format that is used for the webhook request payload (for example, 'JSON' or 'Form Data'). This field ensures that data is encoded in a format the receiving system accepts.

Response_Format String False

The expected format of the external system's response. This field supports response handling and validation logic.

Trigger_Event String False

The Customer Journey event that triggers the webhook (for example, 'step completion', 'stage transition', or 'workflow milestone'). This field controls when data is sent.

Request_Body String False

The request payload that is sent to the external system when the webhook runs. This field can include variable substitutions that are based on journey context.

Headers String False

The HTTP headers that are included in the webhook request, such as authorization tokens or content-type declarations. This field supports secure and standards-compliant integration.

Custom_Post_Body String False

An alternative request body value that is defined manually rather than auto-generated. This field allows specialized integration behavior.

Ignore_Errors Bool False

A Boolean field that returns a value of 'true' when webhook failures should be ignored and workflow progress should continue. It returns a value of 'false' when errors should interrupt processing.

Active Bool False

A Boolean field that returns a value of 'true' when the webhook is enabled and will execute when triggered. It returns a value of 'false' when the webhook is disabled.

Parent_Id String False

The Id of the parent Customer Journey workflow or activity to which this webhook is connected. This field anchors the webhook within a specific guided process.

Parent_Name String False

The display name of the parent workflow or activity that is associated with this webhook. This field provides a readable reference for the Parent_Id field.

Parent_Type String False

The type of record that serves as the parent context for this webhook. This field determines where the webhook applies within the Customer Journey structure.

Following Bool False

A Boolean field that returns a value of 'true' when the current user follows this record for updates. It returns a value of 'false' when the user is not following the record.

My_Favorite Bool False

A Boolean field that returns a value of 'true' when the current user marks this webhook as a favorite. It returns a value of 'false' when the record is not marked as a favorite.

Tag String False

A tag or label that is used to categorize this webhook record for filtering, grouping, and search purposes.

Commentlog String True

The list of comment entries and discussion notes that is related to this webhook record. This field supports collaboration and audit review.

Locked_Fields String True

The list of fields that cannot be modified for this record. This field supports data protection during approval or controlled workflow states.

Sync_Key String True

The synchronization key that links this webhook record to external systems or replication services. This field supports data consistency across platforms.

Team_Id String False

The Id of the primary team that is associated with this webhook record. This field establishes base-level access permissions.

Team_Set_Id String False

The Id of the team set that grants shared access to this webhook across multiple teams. This field supports collaborative work environments.

Acl_Team_Set_Id String False

The Id of the Access Control List (ACL) team set that governs permission enforcement for this record.

Team_Count String False

The number of teams that have access to this webhook. This field supports visibility and access reporting.

Team_Name String False

The name of the primary team that is associated with this record. This field provides a readable reference for the Team_Id field.

Acl_Team_Names String True

The list of team names that are associated with this record for access and collaboration visibility.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454