SSIS Components for Microsoft Office 365

Build 23.0.8839

Users

Read, Insert, Update and Delete a User.

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', '[email protected]', true, '123password')

Columns

Name Type ReadOnly References Description
id [KEY] String True

deletedDateTime Datetime False

accountEnabled Bool False

businessPhones String False

city String False

companyName String False

country String False

createdDateTime Datetime False

department String False

displayName String False

employeeHireDate Datetime False

employeeId String False

employeeLeaveDateTime Datetime False

employeeOrgData_costCenter String False

employeeOrgData_division String False

employeeType String False

givenName String False

identities String False

imAddresses String False

isResourceAccount Bool False

jobTitle String False

lastPasswordChangeDateTime Datetime False

mail String False

mailNickname String False

mobilePhone String False

officeLocation String False

onPremisesDistinguishedName String False

onPremisesDomainName String False

onPremisesExtensionAttributes_extensionAttribute1 String False

onPremisesExtensionAttributes_extensionAttribute10 String False

onPremisesExtensionAttributes_extensionAttribute11 String False

onPremisesExtensionAttributes_extensionAttribute12 String False

onPremisesExtensionAttributes_extensionAttribute13 String False

onPremisesExtensionAttributes_extensionAttribute14 String False

onPremisesExtensionAttributes_extensionAttribute15 String False

onPremisesExtensionAttributes_extensionAttribute2 String False

onPremisesExtensionAttributes_extensionAttribute3 String False

onPremisesExtensionAttributes_extensionAttribute4 String False

onPremisesExtensionAttributes_extensionAttribute5 String False

onPremisesExtensionAttributes_extensionAttribute6 String False

onPremisesExtensionAttributes_extensionAttribute7 String False

onPremisesExtensionAttributes_extensionAttribute8 String False

onPremisesExtensionAttributes_extensionAttribute9 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

passwordProfile_forceChangePasswordNextSignIn Bool False

passwordProfile_forceChangePasswordNextSignInWithMfa Bool False

passwordProfile_password String False

postalCode String False

preferredLanguage String False

securityIdentifier String False

state String False

streetAddress String False

surname String False

userPrincipalName String False

userType String False

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839