Need help to get the proxyAddresses in userattribute

[draut]

Hi All,

I need help importing the proxyAddresses from the Active Directory to userattribute.

I used the below-mentioned query in USER_ATTRIBUTE JSON in the AD connector.

[username::employeeNumber#String,userattribute_email::proxyAddresses#String,createdate::whenCreated#customDate--yyyyMMddHHmmss.'0Z',updatedate::whenChanged#customDate--yyyyMMddHHmmss.'0Z']

After running the AD import job I am getting an error :

Unknown column 'userattribute_email' in 'field list'

Account Attribute :

[
NAME::sAMAccountName#String,
DISPLAYNAME::displayName#String,
DESCRIPTION::objectCategory#String,
ACCOUNTCLASS::objectClass#String,
accountID::distinguishedName#String,
CREATED_ON::whenCreated#date,
LASTLOGONDATE::lastLogon#millisec,
COMMENTS::distinguishedName#String,
CUSTOMPROPERTY1::manager#String,
CUSTOMPROPERTY2::name#String,
CUSTOMPROPERTY3::sn#String,
CUSTOMPROPERTY4::employeeNumber#String,
CUSTOMPROPERTY5::mail#String,
CUSTOMPROPERTY6::cn#String,
CUSTOMPROPERTY7::givenName#String,
CUSTOMPROPERTY8::title#String,
CUSTOMPROPERTY9::userAccountControl#number,
CUSTOMPROPERTY10::c#String,
CUSTOMPROPERTY11::uSNCreated#String,
CUSTOMPROPERTY35::objectguid#binary,
VALIDTHROUGH::accountExpires#millisec,
UPDATEDATE::whenChanged#date,
RECONCILATION_FIELD::CUSTOMPROPERTY35]

Error Snap  :

Attaching the logs .

Thanks

[rushikeshvartak]

Refer https://forums.saviynt.com/t5/saviynt-knowledge-base/achieve-email-uniqueness-check-during-email-gen...