Users
The Users resource provides methods that allow you to manage users for the account.
Table Specific Information
Select
The driver 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 driver.
- Id supports the '=' operator.
For example, the following queries are processed server side:
SELECT * FROM Users WHERE Id='9523f1-aa0-4fe17-a9w7b-6860618adf'
Columns
| Name | Type | Description |
| aboutMe | String | |
| accountEnabled | Bool | |
| ageGroup | String | |
| assignedLicenses | String | |
| assignedPlans | String | |
| birthday | Datetime | |
| businessPhones | String | |
| city | String | |
| companyName | String | |
| consentProvidedForMinor | String | |
| country | String | |
| department | String | |
| deviceEnrollmentLimit | Int | |
| displayName | String | |
| employeeId | String | |
| faxNumber | String | |
| givenName | String | |
| hireDate | Datetime | |
| imAddresses | String | |
| interests | String | |
| isResourceAccount | Bool | |
| jobTitle | String | |
| legalAgeGroupClassification | String | |
| licenseAssignmentStates | String | |
| String | ||
| mailboxSettings_automaticRepliesSetting_status | String | |
| mailboxSettings_automaticRepliesSetting_externalAudience | String | |
| mailboxSettings_automaticRepliesSetting_scheduledStartDateTime_dateTime | String | |
| mailboxSettings_automaticRepliesSetting_scheduledStartDateTime_timeZone | String | |
| mailboxSettings_automaticRepliesSetting_internalReplyMessage | String | |
| mailboxSettings_automaticRepliesSetting_externalReplyMessage | String | |
| mailboxSettings_archiveFolder | String | |
| mailboxSettings_timeZone | String | |
| mailboxSettings_language_locale | String | |
| mailboxSettings_language_displayName | String | |
| mailboxSettings_workingHours_daysOfWeek | String | |
| mailboxSettings_workingHours_startTime | Time | |
| mailboxSettings_workingHours_endTime | Time | |
| mailboxSettings_workingHours_timeZone_name | String | |
| mailNickname | String | |
| mobilePhone | String | |
| mySite | String | |
| officeLocation | String | |
| onPremisesDistinguishedName | String | |
| onPremisesDomainName | String | |
| onPremisesExtensionAttributes_extensionAttribute1 | String | |
| onPremisesExtensionAttributes_extensionAttribute2 | String | |
| onPremisesExtensionAttributes_extensionAttribute3 | String | |
| onPremisesExtensionAttributes_extensionAttribute4 | String | |
| onPremisesExtensionAttributes_extensionAttribute5 | String | |
| onPremisesExtensionAttributes_extensionAttribute6 | String | |
| onPremisesExtensionAttributes_extensionAttribute7 | String | |
| onPremisesExtensionAttributes_extensionAttribute8 | String | |
| onPremisesExtensionAttributes_extensionAttribute9 | String | |
| onPremisesExtensionAttributes_extensionAttribute10 | String | |
| onPremisesExtensionAttributes_extensionAttribute11 | String | |
| onPremisesExtensionAttributes_extensionAttribute12 | String | |
| onPremisesExtensionAttributes_extensionAttribute13 | String | |
| onPremisesExtensionAttributes_extensionAttribute14 | String | |
| onPremisesExtensionAttributes_extensionAttribute15 | String | |
| onPremisesImmutableId | String | |
| onPremisesLastSyncDateTime | Datetime | |
| onPremisesProvisioningErrors | String | |
| onPremisesSamAccountName | String | |
| onPremisesSecurityIdentifier | String | |
| onPremisesSyncEnabled | Bool | |
| onPremisesUserPrincipalName | String | |
| otherMails | String | |
| passwordPolicies | String | |
| passwordProfile_password | String | |
| passwordProfile_forceChangePasswordNextSignIn | Bool | |
| passwordProfile_forceChangePasswordNextSignInWithMfa | Bool | |
| pastProjects | String | |
| postalCode | String | |
| preferredLanguage | String | |
| preferredName | String | |
| provisionedPlans | String | |
| proxyAddresses | String | |
| responsibilities | String | |
| schools | String | |
| showInAddressList | Bool | |
| signInSessionsValidFromDateTime | Datetime | |
| skills | String | |
| state | String | |
| streetAddress | String | |
| surname | String | |
| usageLocation | String | |
| userPrincipalName | String | |
| userType | String | |
| Id [KEY] | String |