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 Zoho Expense connector uses the following default correlation and object configurations.
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 ID
SailPoint requires that certain attributes remain in your configuration. These attributes are referred to as account IDs.
Caution
Changing the attribute marked as the account ID after aggregating accounts can result in duplicate accounts being created. To avoid this, either reset the accounts on this source before editing the account ID attribute or edit the account ID attribute before aggregating accounts.
To resolve issues caused by changing account IDs, reconfigure them to their default values.
The following table lists the default account IDs for this connector:
| Account ID | Schema Object Type |
|---|---|
| id | User |
Default Account Attributes
The Zoho Expense 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 |
|---|---|
| user_id | Unique identifier for the user. |
| role_id | Unique identifier for the user's role. |
| display_name | The name displayed for the user. |
| name | The user's full name or login name. |
| The user's email address. | |
| invitation_type | The method used to invite the user (e.g., "email"). |
| is_super_admin | Boolean indicating if the user has super admin privileges. |
| accounting_app_name | Name of the accounting application. |
| accounting_reference_id | Reference ID for accounting purposes. |
| accounting_vendor_reference_id | Vendor-specific reference ID for accounting. |
| user_role | The specific role assigned to the user (e.g., "admin"). |
| user_type | The type of user. |
| can_approve | Boolean indicating if the user has approval capabilities. |
| status | Current status of the user. |
| default_approver_id | Unique identifier of the user's default approver. |
| default_approver_name | Name of the user's default approver. |
| default_approver_email | Email of the user's default approver. |
| is_from_crm | Boolean indicating if the user originated from a CRM system. |
| is_current_user | Boolean indicating if this represents the currently logged-in user. |
| approves_to_id | Unique identifier of the entity or person the user approves to. |
| approves_to_name | Name of the entity or person the user approves to. |
| approves_to_email | Email of the entity or person the user approves to. |
| submission_amount_limit | The maximum amount the user can submit. |
| approval_amount_limit | The maximum amount the user can approve. |
| created_time | Timestamp when the user record was created. |
| last_modified_time | Timestamp when the user record was last modified. |
| user_mail_in_id | Unique mail-in ID for the user. |
| employee_number | Employee identification number. |
| mobile | User's mobile phone number. |
| last_four_digits | Last four digits (possibly of a credit card or bank account). |
| bank_name | Name of the user's bank. |
| department_id | Unique identifier for the user's department. |
| department_name | Name of the user's department. |
| policy_id | Unique identifier for a policy associated with the user. |
| policy_name | Name of the policy associated with the user. |
| is_from_zoho_people | Boolean indicating if the user originated from Zoho People. |
| travel_policy_id | Unique identifier for the user's travel policy. |
| travel_policy_name | Name of the user's travel policy. |
| travel_policy_display_name | Display name of the user's travel policy. |