Schema Reference

The application schema is used to configure the objects returned from a connector.

Note

The Account Schema tab is used to define the attributes for each object type in the application being configured. The schema attributes can be defined as Entitlement or Multi-Valued. Refer to Managing Source Account Schemas for more information.
The schema attributes that are not present by default must be defined as strings if not specified.

The Smartsheet connector uses the following default correlation and object configurations.

Default Correlation Configuration

Before you aggregate accounts from this source, you can map account attributes with their corresponding identity attributes based on your requirements.

You can customize the correlation configuration. Refer to Assigning Source Accounts to Identities for more information.

When you first create the Smartsheet source, the default correlation mapping is:

Account Attribute	Operation	Identity Attribute
email	Equals	Work Email (email)
firstName	Equals	Given Name (firstname)
lastName	Equals	Family Name (lastname)

Default Account Schema

Each source supports a variety of details, or attributes, about each user who has an account, such as their name, email address, manager name, and location.

The set of account attributes each source stores and how they're organized is known as the account's schema. To best represent your data, you can configure sources to use an account schema matching the one you use in the external connector. Refer to Managing Source Account Schemas for more information.

Default Account Attributes

The Smartsheet connector supports the following default account schema attributes and customer configurable attributes. The attributes must be defined as strings if not specified.

Attribute Name	Description
id	User's ID.
email	User's primary email address.
firstName	User's first name.
lastName	User's last name.
admin	Indicates whether the user is a system admin (can manage user accounts and organization account).
licensedSheetCreator	Indicates whether the user is a licensed user (can create and own sheets).
groupAdmin	Indicates whether the user is a group admin (can create and edit groups).
resourceViewer	Indicates whether the user is a resource viewer (can access resource views).
jiraAdmin	Indicates whether the user is a JIRA admin.
salesforceAdmin	Indicates whether the user is a Salesforce admin.
salesforceUser	Indicates whether the user is a registered Salesforce user.
title	User's title.
department	User's department.
company	User's company.
workPhone	User's work phone number.
mobilePhone	User's mobile phone number.
role	User's role.
sheetCount	The number of sheets owned by the current user within the organization account.
lastLogin	Last login time of the current user.
groups	A list of groups the user is a member of.

Default Entitlement Attributes

Entitlement attributes define the entitlements, such as groups or roles, that can be assigned to the managed system's user accounts. Refer to Managing Entitlements for more information.

Caution

Changing the attribute marked as the Entitlement ID after aggregating accounts or entitlements can result in duplicate entitlements being created, or access profiles and roles breaking. To avoid this, edit the entitlement schema before performing any aggregations.

Attribute Name	Description
id	Group ID.
name	Group name.
description	Group description.
owner	Group owners email address.
ownerId	Group owners user ID.
createdAt	Time of creation.
modifiedAt	Time of last modification.

Documentation Feedback

Feedback is provided as an informational resource only and does not form part of SailPoint’s official product documentation. SailPoint does not warrant or make any guarantees about the feedback (including without limitation as to its accuracy, relevance, or reliability). All feedback is subject to the terms set forth at https://developer.sailpoint.com/discuss/tos.