Power BI Connector for SugarCRM

Build 25.0.9454

Messages

Stores records that represent message conversations and threaded communication. This table supports collaborative discussions and contextual communication history linked to CRM records.

Columns

Name Type ReadOnly Description
Accept_Status String False

The acceptance status of the message for the current user. This value indicates the participation response state in the communication.

Accept_Status_Users String False

A list of users and their associated acceptance status for the message. This field is used to track message delivery engagement across multiple participants.

Acl_Team_Names String True

The display names of the access control teams that govern visibility for this message. This field supports role- and team-based record access control.

Acl_Team_Set_Id String False

The Identifier (Id) of the access control team set that is associated with this message. This Id enables multi-team sharing configurations.

Assigned_User_Id String False

The Id of the user who is assigned to the message. This assignment determines ownership and responsibility.

Assigned_User_Name String True

The display name of the user who is assigned to the message.

Aws_Comprehend_Data String False

Raw sentiment or classification data returned from the Amazon Web Services (AWS) Comprehend service. This field captures automated conversation analysis metadata.

Aws_Contact_Id String True

The Id of the AWS Connect contact that is linked to this message. This value supports synchronization with call center events and conversation logs.

Channel_Type String False

The channel through which the message was communicated (for example, SMS, email, and internal chat).

Commentlog String True

A reference to the associated comment log entries. These entries store discussion history and collaboration notes.

Contact_Id String False

The Id of the contact associated with the message when the message involves a known contact entity.

Contact_Name String True

The display name of the contact associated with the message.

Conversation String True

The conversation thread identifier that is used to group related messages into a continuous discussion sequence.

Conversation_Link String False

A hyperlink or external reference to the full conversation thread. This link supports cross-system navigation.

Created_By String True

The Id of the user who created the message record. This value supports authorship tracking.

Created_By_Name String True

The display name of the user who created the message record.

Date_End Datetime False

The date and time when the message conversation ended or was last active.

Date_Entered Datetime True

The date and time when the message record was created.

Date_Modified Datetime True

The date and time when the message record was last modified.

Date_Start Datetime False

The date and time when the message conversation began.

Deleted Bool False

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

Description String False

A detailed narrative or descriptive text that is associated with the message. This field is often used to store summary details or conversation context.

Direction String False

Indicates whether the message direction is inbound or outbound. This field supports routing, reporting, and workflow branching.

Following Bool False

A Boolean field that returns a value of 'true' when the current user is following the message. It returns a value of 'false' when the message is not being followed. This feature enables activity monitoring and notifications.

Id [KEY] String True

The unique Id of the message record.

Invitee_Contact_Id String True

The Id of the contact who was invited to participate in the conversation.

Invitee_Contact_Name String True

The display name of the invited contact.

Invitee_Lead_Id String True

The Id of the lead who was invited to participate in the conversation.

Invitee_Lead_Name String True

The display name of the invited lead.

Invitees String True

A list of records representing individuals who are invited to participate in the message conversation. This field can reference contacts, leads, or users.

Locked_Fields String True

A system-managed list of fields that are restricted from modification. This field is used to maintain record integrity.

Modified_By_Name String True

The display name of the user who last modified the message record.

Modified_User_Id String True

The Id of the user who last modified the message record.

My_Favorite Bool False

A Boolean field that returns a value of 'true' when the current user marks the message as a favorite. It returns a value of 'false' when it is not marked as a favorite. This feature supports personalized record prioritization.

Name String False

The name or subject of the message as it is displayed in lists and record views.

Parent_Id String False

The Id of the SugarCRM record that is referenced by the Parent_Type field. This value establishes contextual linkage to another CRM entity such as an account, case, or opportunity.

Parent_Name String True

The display name of the parent record referenced by the Parent_Id field.

Parent_Type String True

The module name of the parent record that this message is associated with. This value determines the context relationship type.

Sentiment String False

A sentiment classification value that is derived from conversation analysis (for example, 'POSITIVE', 'NEGATIVE', 'NEUTRAL', and 'MIXED'.

Status String False

The message status value that indicates the processing, delivery, or follow-up state.

Sync_Key String True

An internal synchronization key that is used to reconcile message records across integrated systems or replication operations.

Tag String False

Tags that are assigned to the message record. Tags support categorization, search, and filtering.

Team_Count String False

The count of teams that have access to the message through the team security model.

Team_Id String False

The Id of the primary team that is associated with the message. This assignment controls core record-level access.

Team_Name String False

The display name of the team that is associated with the message.

Team_Set_Id String False

The Id of the team set that is assigned to the message. Team sets support shared access among multiple teams.

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