Users
null
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 Id = '9523f1-aa0-4fe17-a9w7b-6860618adf'
Columns
Name | Type | Description |
aboutMe | String | |
accountEnabled | Bool | |
ageGroup | String | |
assignedLicenses | String | |
assignedPlans | String | |
authorizationInfo_certificateUserIds | String | |
birthday | Datetime | |
businessPhones | String | |
city | String | |
companyName | String | |
consentProvidedForMinor | String | |
country | String | |
createdDateTime | Datetime | |
creationType | String | |
customSecurityAttributes | String | |
department | String | |
deviceEnrollmentLimit | Int | |
displayName | String | |
employeeHireDate | Datetime | |
employeeId | String | |
employeeLeaveDateTime | Datetime | |
employeeOrgData_costCenter | String | |
employeeOrgData_division | String | |
employeeType | String | |
externalUserState | String | |
externalUserStateChangeDateTime | Datetime | |
faxNumber | String | |
givenName | String | |
hireDate | Datetime | |
identities | String | |
imAddresses | String | |
interests | String | |
isResourceAccount | Bool | |
jobTitle | String | |
lastPasswordChangeDateTime | Datetime | |
legalAgeGroupClassification | String | |
licenseAssignmentStates | String | |
String | ||
mailboxSettings_archiveFolder | String | |
mailboxSettings_automaticRepliesSetting_externalAudience | String | |
mailboxSettings_automaticRepliesSetting_externalReplyMessage | String | |
mailboxSettings_automaticRepliesSetting_internalReplyMessage | String | |
mailboxSettings_automaticRepliesSetting_scheduledEndDateTime_dateTime | String | |
mailboxSettings_automaticRepliesSetting_scheduledEndDateTime_timeZone | String | |
mailboxSettings_automaticRepliesSetting_status | String | |
mailboxSettings_dateFormat | String | |
mailboxSettings_delegateMeetingMessageDeliveryOptions | String | |
mailboxSettings_language_displayName | String | |
mailboxSettings_language_locale | String | |
mailboxSettings_timeFormat | String | |
mailboxSettings_timeZone | String | |
mailboxSettings_userPurpose | String | |
mailboxSettings_workingHours_daysOfWeek | String | |
mailboxSettings_workingHours_endTime | Time | |
mailboxSettings_workingHours_startTime | Time | |
mailboxSettings_workingHours_timeZone_name | String | |
mailNickname | String | |
mobilePhone | String | |
mySite | String | |
officeLocation | String | |
onPremisesDistinguishedName | String | |
onPremisesDomainName | String | |
onPremisesExtensionAttributes_extensionAttribute1 | String | |
onPremisesExtensionAttributes_extensionAttribute10 | String | |
onPremisesExtensionAttributes_extensionAttribute11 | String | |
onPremisesExtensionAttributes_extensionAttribute12 | String | |
onPremisesExtensionAttributes_extensionAttribute13 | String | |
onPremisesExtensionAttributes_extensionAttribute14 | String | |
onPremisesExtensionAttributes_extensionAttribute15 | 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 | |
onPremisesImmutableId | String | |
onPremisesLastSyncDateTime | Datetime | |
onPremisesProvisioningErrors | String | |
onPremisesSamAccountName | String | |
onPremisesSecurityIdentifier | String | |
onPremisesSyncEnabled | Bool | |
onPremisesUserPrincipalName | String | |
otherMails | String | |
passwordPolicies | String | |
passwordProfile_forceChangePasswordNextSignIn | Bool | |
passwordProfile_forceChangePasswordNextSignInWithMfa | Bool | |
passwordProfile_password | String | |
pastProjects | String | |
postalCode | String | |
preferredDataLocation | String | |
preferredLanguage | String | |
preferredName | String | |
provisionedPlans | String | |
proxyAddresses | String | |
responsibilities | String | |
schools | String | |
securityIdentifier | String | |
serviceProvisioningErrors | String | |
showInAddressList | Bool | |
signInActivity_lastNonInteractiveSignInDateTime | Datetime | |
signInActivity_lastNonInteractiveSignInRequestId | String | |
signInActivity_lastSignInDateTime | Datetime | |
signInActivity_lastSignInRequestId | String | |
signInSessionsValidFromDateTime | Datetime | |
skills | String | |
state | String | |
streetAddress | String | |
surname | String | |
usageLocation | String | |
userPrincipalName | String | |
userType | String | |
authentication_id | String | |
calendar_id | String | |
cloudClipboard_id | String | |
drive_id | String | |
employeeExperience_id | String | |
inferenceClassification_id | String | |
insights_id | String | |
manager_id | String | |
onenote_id | String | |
outlook_id | String | |
photo_id | String | |
planner_id | String | |
presence_id | String | |
settings_id | String | |
teamwork_id | String | |
todo_id | String | |
UserId [KEY] | String |