Data retrieved by Salesforce Sales Cloud connector

Data retrieved by the Salesforce Sales Cloud connector that is stored by Snow.

UserLicense

For reference information, see UserLicense .

API property	Description
Id	The user license ID.
CreatedDate	The user license created date.
LicenseDefinitionKey	A string that uniquely identifies a particular user license.
MasterLabel	The user license label.
Name	The internal name of the user license.
Status	The current status of the user license. Valid values: Active, Disabled.
TotalLicenses	The number of user licenses in the organization.
UsedLicenses	The number of user licenses that are assigned to active users in the organization.

Profile

For a list of possible values for the UserType property, see Salesforce API docs .

API property	Description
Id	Profile ID.
Description	Description of the profile.
Name	The name of the profile.
CreatedById	The ID of the user that created the profile.
LastModifiedById	The ID of the user that modified the profile last.
LastModifiedDate	The date and time when the profile was last modified.
UserType	The category of user license.
UserLicense.Id	ID of the UserLicense associated with this profile.

User

For a list of possible values for the UserType property, see Salesforce API docs . The PowerPartner, CSPLitePortal, CustomerSuccess, and PowerCustomerSuccess user types are excluded from consolidated user data in SaaS.

API property	Description
Id	The user's ID.
Email	The user’s email address.
Alias	The user’s alias, for example: jsmith.
FirstName	The user’s first name.
LastName	The user’s last name.
LastLoginDate	The date and time when the user last successfully logged in.
Name	Concatenation of FirstName and LastName.
Username	Contains the name that a user enters to log in to the API or the user interface.
UserType	The category of user license.
City	The city associated with the user.
CompanyName	The name of the user’s company.
Department	The company department associated with the user.
Division	The division associated with this user, similar to Department, and unrelated to DefaultDivision.
Profile.Id	The ID of the user’s profile.
Profile.Country	The country of the user's profile.
UserRole.Name	Name of the user role.
LocaleSidKey	Locale (two-letter ISO code).

Organization

For a list of possible values for the Organization property, see Salesforce API docs .

API property	Description
Id	The organization's ID.
Name	The organization's name.
InstanceName	The name of the instance.
OrganizationType	The edition of the organization. For example, Enterprise edition or Unlimited edition.
PrimaryContact	Name of the primary contact for the organization.

PermissionSetLicense

For a list of possible values of PermissionSetLicense, see Salesforce API docs .

API property	Description
Id	The PermissionSetLicense's ID.
ExpirationDate	The date at which the permission set license expires.
Language	The language of the permission set license.
MasterLabel	The label of the permission set license.
PermissionSetLicenseKey	A string that uniquely identifies a particular permission set license.
Status	The status of a permission set license. If Active, the permission set license is available and if Disabled, the permission set license has expired.
TotalLicenses	The total number of the permission set licenses that are available in your organization.
UsedLicenses	The number of the permission set licenses that are currently assigned to users.

PermissionSetLicenseAssign

For a list of possible values of PermissionSetLicenseAssign, see Salesforce API docs

API property	Description
Id	The PermissionSetLicenseAssign’s ID.
AssigneeId	The ID of the user to assign the permission set license, as specified in PermissionSetLicenseId.
PermissionSetLicenseId	The ID of the permission set license the user is assigned to.

ActiveFeatureLicenseMetric

For a list of possible values of ActiveFeatureLicenseMetric, see Salesforce API docs

API property	Description
Id	The ID of the feature license.
ActiveUserCount	The number of users assigned to the feature license, who have logged in within the last 30 days.
AssignedUserCount	The number of users assigned to this feature license.
FeatureType	The type of feature license.
MetricsDate	The date the feature license metrics were collected.
SystemModstamp	The timestamp for when the feature license metrics were collected.
TotalLicenseCount	The number of feature licenses in the organization.

TenantUsageEntitlement

API property	Description
Id	The ID of the TenantUsageEntitlement.
MasterLabel	The label of the TenantUsageEntitlement.
StartDate	The date when the subscription usage for the tenant started.
EndDate	The date when the subscription usage for the tenant expired.
AmountUsed	The quantity of the subscription that has been used.
CurrentAmountAllowed	The quantity of a subscription that a tenant is allowed to use.
Frequency	How often the tenant's subscription data is automatically reviewed by Salesforce to see how much of the subscription has been used.
ResourceGroupKey	Tracks resource usage across different segments for the same setting. For example, a Message entitlement that tracks email messages and SMS messages separately could have one ResourceGroupKey of SMS and another ResourceGroupKey of Email.
UsageDate	The date when the subscription was last used.