Users
Represents various ways a user can view assigned tasks.
Table Specific Information
Select
The connector will use the Microsoft Planner API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.
- Id supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM Users WHERE UserId = '9523f1-aa0-4fe17-a9w7b-6860618adf'
Columns
| Name | Type | Description |
| UserId [KEY] | String | The ID of the user. |
| aboutMe | String | The label About Me corresponds to this field. |
| accountEnabled | Bool | The label account enabled corresponds to this field. |
| ageGroup | String | Typically used to set the age group of the user. |
| assignedLicenses | String | The licenses that are assigned to the user, including inherited licenses. |
| assignedPlans | String | The plans that are assigned to the user. |
| authorizationInfo_certificateUserIds | String | Label Authorization Info Certification User IDs corresponds to this field. |
| birthday | Datetime | The birthday of the user. |
| businessPhones | String | The telephone numbers for the user. |
| city | String | The city where the user is located. |
| companyName | String | The name of the company that the user is associated with. |
| consentProvidedForMinor | String | Typically used to set whether consent was obtained for minors. |
| country | String | The country/region where the user is located. |
| createdDateTime | Datetime | The date and time the user was created. |
| creationType | String | Specifies the method by which the user account was created. |
| customSecurityAttributes | String | An open complex type that holds the value of a custom security attribute that is assigned to a directory object. |
| department | String | The name of the department in which the user works. |
| deviceEnrollmentLimit | Int | Label Device Enrollment Limit corresponds to this field. |
| displayName | String | The name displayed in the address book for the user. |
| employeeHireDate | Datetime | The date and time when the user was hired or will start work in a future hire. |
| employeeId | String | The employee identifier assigned to the user by the organization. |
| employeeLeaveDateTime | Datetime | The date and time when the user left or will leave the organization. |
| employeeOrgData_costCenter | String | Represents cost center organization data associated with the employee. |
| employeeOrgData_division | String | Represents division organization data associated with the employee. |
| employeeType | String | Captures enterprise worker type. |
| externalUserState | String | This property represents the invited user's invitation status. |
| externalUserStateChangeDateTime | Datetime | Shows the timestamp for the latest change to the externalUserState property. |
| faxNumber | String | The fax number of the user. |
| givenName | String | The first name of the user. |
| hireDate | Datetime | The hire date of the user. |
| identities | String | Specifies the identities that can be used to sign in to this user account. |
| imAddresses | String | The instant message voice-over IP session initiation protocol addresses for the user. |
| interests | String | A list for the user to describe their interests. |
| isResourceAccount | Bool | Do not use. This is reserved for future use. |
| jobTitle | String | The user's job title. |
| lastPasswordChangeDateTime | Datetime | The last time the user changed their password or when their password was created, whichever date is the most recent. |
| legalAgeGroupClassification | String | Typically used by enterprise applications to determine the legal age group of the user. |
| licenseAssignmentStates | String | State of license assignments for this user. |
| String | The Simple Mail Transfer Protocol address for the user. | |
| mailboxSettings_archiveFolder | String | Label Mailbox Settings Archive Folder corresponds to this field. |
| mailboxSettings_automaticRepliesSetting_externalAudience | String | Label Mailbox Settings Automatic Replies External Audience corresponds to this field. |
| mailboxSettings_automaticRepliesSetting_externalReplyMessage | String | Label Mailbox Settings Automatic Replies External Reply Message corresponds to this field. |
| mailboxSettings_automaticRepliesSetting_internalReplyMessage | String | Label Mailbox Settings Automatic Replies Internal Reply Message corresponds to this field. |
| mailboxSettings_automaticRepliesSetting_scheduledEndDateTime_dateTime | String | Label Mailbox Settings Automatic Replies Scheduled End Date Time corresponds to this field. |
| mailboxSettings_automaticRepliesSetting_scheduledEndDateTime_timeZone | String | Label Mailbox Settings Automatic Replies Scheduled End Date Timezone corresponds to this field. |
| mailboxSettings_automaticRepliesSetting_status | String | Label Mailbox Settings Automatic Replies Status corresponds to this field. |
| mailboxSettings_dateFormat | String | Label Mailbox Settings Automatic Replies Date Format corresponds to this field. |
| mailboxSettings_delegateMeetingMessageDeliveryOptions | String | Label Mailbox Settings Delegate Meeting Message Delivery Options corresponds to this field. |
| mailboxSettings_language_displayName | String | Label Mailbox Settings Language Display Name corresponds to this field. |
| mailboxSettings_language_locale | String | Label Mailbox Settings Language Locale corresponds to this field. |
| mailboxSettings_timeFormat | String | Label Mailbox Settings Time Format corresponds to this field. |
| mailboxSettings_timeZone | String | Label Mailbox Settings Time Zone corresponds to this field. |
| mailboxSettings_userPurpose | String | Label Mailbox Settings User Purpose corresponds to this field. |
| mailboxSettings_workingHours_daysOfWeek | String | Label Mailbox Settings Working Hours Days of Week corresponds to this field. |
| mailboxSettings_workingHours_endTime | Time | Label Mailbox Settings Working Hours End Time corresponds to this field. |
| mailboxSettings_workingHours_startTime | Time | Label Mailbox Settings Working Hours Start Time corresponds to this field. |
| mailboxSettings_workingHours_timeZone_name | String | Label Mailbox Settings Working Hours Time Zone Name corresponds to this field. |
| mailNickname | String | The mail alias for the user. |
| mobilePhone | String | The primary cellular telephone number for the user. |
| mySite | String | The URL for the user's site. |
| officeLocation | String | The office location in the user's place of business. |
| onPremisesDistinguishedName | String | Contains the on-premises Active Directory distinguished name or DN. |
| onPremisesDomainName | String | Contains the on-premises domainFQDN, also called dnsDomainName synchronized from the on-premises directory. |
| onPremisesExtensionAttributes_extensionAttribute1 | String | Contains Extension Attributes 1. |
| onPremisesExtensionAttributes_extensionAttribute10 | String | Contains Extension Attributes 10. |
| onPremisesExtensionAttributes_extensionAttribute11 | String | Contains Extension Attributes 11. |
| onPremisesExtensionAttributes_extensionAttribute12 | String | Contains Extension Attributes 12. |
| onPremisesExtensionAttributes_extensionAttribute13 | String | Contains Extension Attributes 13. |
| onPremisesExtensionAttributes_extensionAttribute14 | String | Contains Extension Attributes 14. |
| onPremisesExtensionAttributes_extensionAttribute15 | String | Contains Extension Attributes 15. |
| onPremisesExtensionAttributes_extensionAttribute2 | String | Contains Extension Attributes 2. |
| onPremisesExtensionAttributes_extensionAttribute3 | String | Contains Extension Attributes 3. |
| onPremisesExtensionAttributes_extensionAttribute4 | String | Contains Extension Attributes 4. |
| onPremisesExtensionAttributes_extensionAttribute5 | String | Contains Extension Attributes 5. |
| onPremisesExtensionAttributes_extensionAttribute6 | String | Contains Extension Attributes 6. |
| onPremisesExtensionAttributes_extensionAttribute7 | String | Contains Extension Attributes 7. |
| onPremisesExtensionAttributes_extensionAttribute8 | String | Contains Extension Attributes 8. |
| onPremisesExtensionAttributes_extensionAttribute9 | String | Contains Extension Attributes 9. |
| onPremisesImmutableId | String | This property is used to associate an on-premises Active Directory user account. |
| onPremisesLastSyncDateTime | Datetime | Indicates the last time at which the object was synced with the on-premises directory. |
| onPremisesProvisioningErrors | String | Errors when using Microsoft synchronization product during provisioning. |
| onPremisesSamAccountName | String | Contains the on-premises SAM Account Name synchronized from the on-premises directory. |
| onPremisesSecurityIdentifier | String | Contains the on-premises security identifier for the user that was synchronized from on-premises to the cloud. |
| onPremisesSyncEnabled | Bool | This field is true if this user object is currently being synced from an on-premises Active Directory. |
| onPremisesUserPrincipalName | String | Contains the on-premises userPrincipalName synchronized from the on-premises directory. |
| otherMails | String | A list of other email addresses for the user. |
| passwordPolicies | String | Specifies password policies for the user. |
| passwordProfile_forceChangePasswordNextSignIn | Bool | Specifies that the user will be forced to change the password on the next sign-in. |
| passwordProfile_forceChangePasswordNextSignInWithMfa | Bool | Specifies that the user will be forced to change the password on the next sign-in with multi-factor authentication. |
| passwordProfile_password | String | Specifies the password profile for the user. |
| pastProjects | String | A list for the user to enumerate their past projects. |
| postalCode | String | The postal code for the user's postal address. |
| preferredDataLocation | String | The preferred data location for the user. |
| preferredLanguage | String | The preferred language for the user. |
| preferredName | String | The preferred name for the user. |
| provisionedPlans | String | The plans that are provisioned for the user. |
| proxyAddresses | String | Label Proxy Addresses corresponds to this field. |
| responsibilities | String | A list for the user to enumerate their responsibilities. |
| schools | String | A list for the user to enumerate the schools they attended. |
| securityIdentifier | String | Security identifier of the user. |
| serviceProvisioningErrors | String | Errors published by a federated service describing a nontransient, service-specific error regarding the properties or link from a user object. |
| showInAddressList | Bool | Label Show In Address List corresponds to this field. |
| signInActivity_lastNonInteractiveSignInDateTime | Datetime | Specifies the last non-interactive signed-in date and time of the sign-in for a given user. |
| signInActivity_lastNonInteractiveSignInRequestId | String | Specifies the last non-interactive signed-in request ID of the sign-in for a given user. |
| signInActivity_lastSignInDateTime | Datetime | Specifies the last signed-in date and time of the sign-in for a given user. |
| signInActivity_lastSignInRequestId | String | Specifies the last signed-in request ID of the sign-in for a given user. |
| signInSessionsValidFromDateTime | Datetime | Specifies any refresh tokens or session tokens issued before this time are invalid. |
| skills | String | A list for the user to enumerate their skills. |
| state | String | The state or province in the user's address. |
| streetAddress | String | The street address of the user's place of business. |
| surname | String | The user's last name. |
| usageLocation | String | A two-letter country code required for users that are assigned licenses due to legal requirements to check for availability of services in countries. |
| userPrincipalName | String | The user principal name of the user. |
| userType | String | A string value that can be used to classify user types in your directory. |
| authentication_id | String | The authentication ID of the user. |
| calendar_id | String | The calendar ID of the user. |
| cloudClipboard_id | String | The user's cloud clipboard ID. |
| drive_id | String | The user's OneDrive ID. |
| employeeExperience_id | String | The Employee Experiene ID of the user. |
| inferenceClassification_id | String | Specifies the classification of the user's messages based on explicit designations that override inferred relevance or importance. |
| insights_id | String | Specifies the relationships between a user and items. |
| manager_id | String | The ID of the user's manager. |
| onenote_id | String | The OneNote ID of the user. |
| outlook_id | String | The Outlook ID of the user. |
| photo_id | String | The user's profile photo ID. |
| planner_id | String | The user's planner ID. |
| presence_id | String | Label Presence ID corresponds to this field. |
| settings_id | String | Label Settings ID corresponds to this field. |
| teamwork_id | String | Label Teamwork ID corresponds to this field. |
| todo_id | String | Specifies the To Do services available to a user. |