Power BI Connector for SugarCRM

Build 25.0.9454

Activities

Provides a unified view of interactions such as calls, meetings, tasks, and emails across modules. This view helps users track engagement history and follow-up activity for accounts, contacts, and opportunities.

Columns

Name Type Description
Id [KEY] String The unique identifier (Id) for this activity record. This field ensures that the record can be referenced reliably across related modules.
Name String The display name or descriptive label for this activity. This field helps users identify the activity in lists, dashboards, and history views.
Date_Entered Datetime The date and time when this activity record is created in the system. This field supports lifecycle auditing and historical reporting.
Date_Modified Datetime The date and time when this activity record is most recently modified. This field enables users to track changes over time.
Modified_User_Id String The Id of the user who most recently modified this activity record. This field supports auditing of update responsibility.
Modified_By_Name String The name of the user who most recently modified this activity record. This field provides a readable reference for the Modified_User_Id field.
Created_By String The Id of the user who originally created this activity record. This field ensures traceability for initial record creation.
Created_By_Name String The name of the user who originally created this activity record. This field provides a readable reference for the created_by field.
Description String A narrative or explanatory note that describes the context or details of the activity. This field supports collaboration and historical review.
Deleted Bool A Boolean field that returns a value of 'true' when the activity record is marked for deletion. It returns a value of 'false' when the record remains active. This field supports soft-delete workflows and record recovery.
Parent_Id String The Id of the parent record that is associated with this activity. This field establishes the relationship between the activity and its originating module.
Parent_Type String The module or entity type of the parent record that is associated with this activity. This field allows the system to interpret the meaning of the Parent_Id field.
Activity_Type String The classification of the activity, such as call, meeting, task, or email. This field supports sorting, filtering, and reporting on activity types.
Data String Serialized or structured data that is associated with this activity. This field can store metadata or system-generated detail that is required by activity sources.
Comment_Count Int The number of comments that are associated with this activity. This field supports engagement analysis and collaboration tracking.
Last_Comment String The content of the most recent comment that is posted on this activity. This field provides quick visibility into the latest discussion context.
Following Bool A Boolean field that returns a value of 'true' when the current user is following this activity to receive updates. It returns a value of 'false' when the user is not subscribed to follow the record.
My_Favorite Bool A Boolean field that returns a value of 'true' when the current user marks this activity as a favorite. It returns a value of 'false' when the record is not marked as a favorite.
Locked_Fields String The list of fields that are locked and cannot be modified for this activity record. This field helps maintain data integrity in controlled situations.
Sync_Key String The synchronization key that links this activity to external systems or data sources. This field supports cross-system data consistency.

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