TDV Adapter for Office 365

Build 21.0.8137

Users

The Office365 table Users.

Table Specific Information

Select

Query the Users table by retrieving everything from Users, specifying a Id, or filtering by a column:

SELECT * FROM Users WHERE Id = '616391f0-32d8-4127-8f25-aa55771d6617'

SELECT DisplayName, Id FROM Users WHERE DisplayName LIKE 'John%'

Insert

The following are required to create a new organizational User:

INSERT INTO Users (AccountEnabled, DisplayName, MailNickname, UserPrincipalName, PasswordProfile_ForceChangePasswordNextSignIn, PasswordProfile_Password) VALUES (false, 'John Smith', 'JohnS', 'smithjohn@yourcompanydomain.com', true, '123password')

Columns

Name Type ReadOnly References Description
id [KEY] String True

Etag String False

deletedDateTime Datetime False

accountEnabled Bool False

ageGroup String False

assignedLicenses String False

assignedPlans String False

businessPhones String False

city String False

companyName String False

consentProvidedForMinor String False

country String False

createdDateTime Datetime False

creationType String False

department String False

displayName String False

employeeHireDate Datetime False

employeeId String False

employeeOrgData_costCenter String False

employeeOrgData_division String False

employeeType String False

externalUserState String False

externalUserStateChangeDateTime Datetime False

faxNumber String False

givenName String False

identities String False

imAddresses String False

isResourceAccount Bool False

jobTitle String False

lastPasswordChangeDateTime Datetime False

legalAgeGroupClassification String False

licenseAssignmentStates String False

mailNickname String False

mobilePhone String False

officeLocation String False

onPremisesDistinguishedName String False

onPremisesDomainName String False

onPremisesImmutableId String False

onPremisesLastSyncDateTime Datetime False

onPremisesProvisioningErrors String False

onPremisesSamAccountName String False

onPremisesSecurityIdentifier String False

onPremisesSyncEnabled Bool False

onPremisesUserPrincipalName String False

otherMails String False

passwordPolicies String False

passwordProfile_forceChangePasswordNextSignIn Bool False

passwordProfile_forceChangePasswordNextSignInWithMfa Bool False

passwordProfile_password String False

postalCode String False

preferredLanguage String False

provisionedPlans String False

proxyAddresses String False

showInAddressList Bool False

signInSessionsValidFromDateTime Datetime False

state String False

streetAddress String False

surname String False

usageLocation String False

userPrincipalName String False

userType String False

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137