MCP Server for Salesforce

Build 24.0.9300

User

Stores details about Salesforce users, including login credentials, profiles, and roles.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier for the user record.

Username String False

Login name used by the user to sign in to Salesforce.

LastName String False

User's last name as entered in their profile.

FirstName String False

User's first name as entered in their profile.

Name String True

Full name of the user, typically a combination of first and last names.

CompanyName String False

Name of the company or organization the user is associated with.

Division String False

User's division within the organization, used for reporting and filtering.

Department String False

Department that the user belongs to, such as Sales or IT.

Title String False

Job title of the user within the organization.

Street String False

Street address listed in the user's contact information.

City String False

City listed in the user's contact information.

State String False

State or province listed in the user's contact information.

PostalCode String False

Postal or ZIP code listed in the user's contact information.

Country String False

Country listed in the user's contact information.

Latitude Double False

Geographic latitude coordinate for the user's address.

Longitude Double False

Geographic longitude coordinate for the user's address.

Email String False

Email address used by the user for communication and notifications.

EmailPreferencesAutoBcc Boolean False

Indicates if outgoing emails are automatically BCC'd to the sender.

EmailPreferencesAutoBccStayInTouch Boolean False

Specifies if stay-in-touch emails are automatically BCC'd to the sender.

EmailPreferencesStayInTouchReminder Boolean False

Indicates whether the user receives reminders to stay in touch with contacts.

SenderEmail String False

Email address used as the sender for outbound emails from this user.

SenderName String False

Display name used as the sender for outbound emails from this user.

Signature String False

Email signature appended to messages sent by the user.

StayInTouchSubject String False

Default subject line used for stay-in-touch request emails.

StayInTouchSignature String False

Signature used in stay-in-touch emails sent by the user.

StayInTouchNote String False

Default message body for stay-in-touch request emails.

Phone String False

Primary phone number listed for the user.

Fax String False

Fax number associated with the user.

MobilePhone String False

Mobile or cell phone number listed for the user.

Alias String False

Shortened alias or nickname used for identification in internal Salesforce processes.

CommunityNickname String False

Nickname used by the user in Salesforce communities.

IsActive Boolean False

Indicates whether the user account is currently active.

TimeZoneSidKey String False

Time zone setting for the user, which affects calendar and time-based features.

UserRoleId String False

UserRole.Id

Identifier for the user role, which defines hierarchy and access levels.

LocaleSidKey String False

Locale setting that controls regional formatting such as dates and numbers.

ReceivesInfoEmails Boolean False

Indicates whether the user receives informational emails from Salesforce.

ReceivesAdminInfoEmails Boolean False

Indicates whether the user receives administrative-related emails from Salesforce.

EmailEncodingKey String False

Character encoding used for the user's email communications, such as UTF-8 or ISO-8859-1.

ProfileId String False

Profile.Id

Identifier of the profile assigned to the user, which defines their permissions and access.

UserType String True

Category of the user, such as Standard, Partner, or Customer Portal.

LanguageLocaleKey String False

Language preference setting used to localize the user interface.

EmployeeNumber String False

Employee identification number assigned to the user by the organization.

DelegatedApproverId String False

Identifier of the user authorized to approve items on behalf of this user.

ManagerId String False

User.Id

Identifier of the user's manager, used for hierarchy and reporting.

LastLoginDate Datetime True

Date and time when the user last logged into Salesforce.

LastPasswordChangeDate Datetime True

Date and time when the user last changed or reset their password.

CreatedDate Datetime True

Date and time when the user record was created.

CreatedById String True

User.Id

Identifier of the user who created this user record.

LastModifiedDate Datetime True

Date and time when the user record was last updated.

LastModifiedById String True

User.Id

Identifier of the user who last modified the user record.

SystemModstamp Datetime True

System-generated timestamp of the most recent change to the user record.

OfflineTrialExpirationDate Datetime True

Expiration date of the user's trial license for Salesforce Offline Edition.

OfflinePdaTrialExpirationDate Datetime True

Expiration date of the user's trial license for Salesforce Sales Anywhere or PDA support.

UserPermissionsMarketingUser Boolean False

Indicates whether the user has marketing permissions, such as managing campaigns.

UserPermissionsOfflineUser Boolean False

Specifies whether the user has access to the Salesforce Offline Edition.

UserPermissionsCallCenterAutoLogin Boolean False

Allows the user to automatically log into the assigned call center.

UserPermissionsMobileUser Boolean False

Indicates whether the user is enabled for Salesforce mobile features.

UserPermissionsSFContentUser Boolean False

Specifies whether the user has access to Salesforce Customer Relationship Management (CRM) Content.

UserPermissionsKnowledgeUser Boolean False

Grants access to Salesforce Knowledge features.

UserPermissionsInteractionUser Boolean False

Allows the user to create, run, or manage flows in Flow Builder.

UserPermissionsSupportUser Boolean False

Grants Service Cloud access to the user, enabling case management and related features.

UserPermissionsSiteforceContributorUser Boolean False

Enables the user to contribute to Site.com (now Experience Cloud) content.

UserPermissionsSiteforcePublisherUser Boolean False

Allows the user to publish content within Site.com (Experience Cloud) environments.

UserPermissionsChatterAnswersUser Boolean False

Grants the user access to Chatter Answers, enabling community question and answer features.

ForecastEnabled Boolean False

Indicates whether the user can access forecasting features for sales planning.

UserPreferencesActivityRemindersPopup Boolean False

Determines whether the user receives pop-up reminders for activities.

UserPreferencesEventRemindersCheckboxDefault Boolean False

Controls whether event reminders are enabled by default when creating new events.

UserPreferencesTaskRemindersCheckboxDefault Boolean False

Controls whether reminders are enabled by default when creating new tasks.

UserPreferencesReminderSoundOff Boolean False

Indicates whether the reminder sound is disabled for pop-up notifications.

UserPreferencesDisableAllFeedsEmail Boolean False

Indicates whether the user has disabled all Chatter email notifications.

UserPreferencesDisableFollowersEmail Boolean False

Indicates whether the user has disabled email notifications when someone follows them.

UserPreferencesDisableProfilePostEmail Boolean False

Specifies whether the user receives emails for profile posts.

UserPreferencesDisableChangeCommentEmail Boolean False

Determines whether the user is notified by email when comments are changed.

UserPreferencesDisableLaterCommentEmail Boolean False

Indicates whether the user receives email notifications for later comments on posts they commented on.

UserPreferencesDisProfPostCommentEmail Boolean False

Specifies whether the user is notified about comments on their profile posts.

UserPreferencesApexPagesDeveloperMode Boolean False

Enables developer mode, which shows Apex debug logs and page component outlines.

UserPreferencesHideCSNGetChatterMobileTask Boolean False

Hides the task encouraging the user to install Chatter Mobile.

UserPreferencesDisableMentionsPostEmail Boolean False

Disables email notifications when the user is mentioned in a post.

UserPreferencesDisMentionsCommentEmail Boolean False

Disables email notifications when the user is mentioned in a comment.

UserPreferencesHideCSNDesktopTask Boolean False

Hides the task suggesting Chatter Desktop setup.

UserPreferencesHideChatterOnboardingSplash Boolean False

Suppresses the Chatter onboarding splash screen for the user.

UserPreferencesHideSecondChatterOnboardingSplash Boolean False

Suppresses a second Chatter onboarding screen, if available.

UserPreferencesDisCommentAfterLikeEmail Boolean False

Prevents email alerts for comments made after the user likes a post.

UserPreferencesDisableLikeEmail Boolean False

Indicates whether the user receives emails when someone likes their post.

UserPreferencesDisableMessageEmail Boolean False

Disables email notifications for private messages sent via Chatter.

UserPreferencesOptOutOfTouch Boolean False

Indicates whether the user has opted out of stay-in-touch requests.

UserPreferencesDisableBookmarkEmail Boolean False

Prevents email notifications when someone bookmarks the user's content.

UserPreferencesDisableSharePostEmail Boolean False

Disables email notifications for shared Chatter posts involving the user.

UserPreferencesEnableAutoSubForFeeds Boolean False

Automatically subscribes the user to feeds they interact with.

UserPreferencesDisableFileShareNotificationsForApi Boolean False

Disables email notifications triggered by API-based file shares.

UserPreferencesShowTitleToExternalUsers Boolean False

Allows the user's job title to be visible to external community users.

UserPreferencesShowManagerToExternalUsers Boolean False

Allows the user's manager information to be shown to external users.

UserPreferencesShowEmailToExternalUsers Boolean False

Allows the user's email address to be visible to external users.

UserPreferencesShowWorkPhoneToExternalUsers Boolean False

Allows the user's work phone number to be displayed to external users.

UserPreferencesShowMobilePhoneToExternalUsers Boolean False

Allows the user's mobile number to be visible to external users.

UserPreferencesShowFaxToExternalUsers Boolean False

Allows the user's fax number to be displayed to external users.

UserPreferencesShowStreetAddressToExternalUsers Boolean False

Allows the user's street address to be shown to external users.

UserPreferencesShowCityToExternalUsers Boolean False

Allows the user's city to be visible to external users.

UserPreferencesShowStateToExternalUsers Boolean False

Allows the user's state or province to be visible to external users.

UserPreferencesShowPostalCodeToExternalUsers Boolean False

Allows the user's postal or ZIP code to be displayed to external users.

UserPreferencesShowCountryToExternalUsers Boolean False

Allows the user's country to be visible to external users.

UserPreferencesShowProfilePicToGuestUsers Boolean False

Enables the user's profile picture to be shown to guest users.

UserPreferencesShowTitleToGuestUsers Boolean False

Allows the user's title to be shown to unauthenticated guest users.

UserPreferencesShowCityToGuestUsers Boolean False

Allows the user's city to be displayed to guest users.

UserPreferencesShowStateToGuestUsers Boolean False

Allows the user's state or province to be visible to guest (unauthenticated) users.

UserPreferencesShowPostalCodeToGuestUsers Boolean False

Allows the user's postal or ZIP code to be shown to guest users.

UserPreferencesShowCountryToGuestUsers Boolean False

Allows the user's country to be visible to guest users.

UserPreferencesHideS1BrowserUI Boolean False

Hides the Salesforce1 (now Salesforce mobile web) interface in the browser for the user.

ContactId String False

Contact.Id

Identifier of the contact record associated with the user, if applicable.

AccountId String True

Account.Id

Identifier of the account linked to the user, primarily for community or partner users.

CallCenterId String False

CallCenter.Id

Identifier of the call center configuration assigned to the user.

Extension String False

Phone extension number associated with the user for call center use.

FederationIdentifier String False

Unique SAML federation ID used for single sign-on (SSO) authentication.

AboutMe String False

Free-text field where the user can provide a brief biography or personal description.

FullPhotoUrl String True

URL linking to the user's full-sized profile photo.

SmallPhotoUrl String True

URL linking to the user's thumbnail-sized profile photo.

DigestFrequency String False

Frequency setting for how often the user receives Chatter digest emails.

DefaultGroupNotificationFrequency String False

Default notification frequency for Chatter group updates when the user joins a group.

LastViewedDate Datetime True

Timestamp indicating when the user record was last viewed.

LastReferencedDate Datetime True

Timestamp indicating when the user record was last referenced in related records or automation.

GeoLoc__Latitude__s Double False

Custom field capturing the user's geographic latitude, typically used for mapping or territory management.

GeoLoc__Longitude__s Double False

Custom field capturing the user's geographic longitude.

GeoLoc__c String True

Custom geolocation field storing latitude and longitude as a single string or formatted point.

TextLong__c String False

Custom long-text field for storing extended user information or metadata.

ExternId__c String False

Custom external identifier used to map the Salesforce user to an external system or source.

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