Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

AAD connector not importing required attributes

parthaghosh
New Contributor III
New Contributor III

Hi All,

we are using AAD connector for importing Accounts and access.

issue 1: 
We are unable to import the required attributes even after mapping in ACCOUNT_ATTRIBUTES and adding the fields in ACCOUNT_IMPORT_FIELDS.

ACCOUNT_ATTRIBUTES:

{
"acctLabels": {
"customproperty1": "FirstName",
"customproperty2": "City",
"customproperty3": "Job Title",
"customproperty1": "Given Name",
"customproperty2": "City",
"customproperty3": "Job Title",
"customproperty4": "Hire Date",
"customproperty5": "onPremisesLastSyncDateTime",
"customproperty6": "onPremisesSecurityIdentifier",
"customproperty7": "Business Phones",
"customproperty8": "Usage Location",
"customproperty9": "mail",
"customproperty10": "Telephone Number",
"customproperty11": "physicalDeliveryOfficeName",
"customproperty12": "Street Address",
"customproperty14": "Surname",
"customproperty16": "extensionAttribute8",
"customproperty17": "Country",
"customproperty19": "preferredLanguage",
"customproperty20": "country",
"customproperty22": "Department",
"customproperty28": "onPremisesSamAccountName",
"customproperty29": "corpCustomAttribute009",
"customproperty30": "corpCustomAttribute010",
"customproperty31": "extensionAttribute1",
"customproperty32": "extensionAttribute7",
"customproperty33": "extensionAttribute9",
"customproperty34": "extensionAttribute13",
"customproperty35": "Mobile",
"customproperty36": "userType",
"customproperty37": "corpCustomAttribute031",
"customproperty38": "onPremisesImmutableId",
"customproperty39": "mailNickName",
"customproperty47": "facsimileTelephoneNumber",
"customproperty48": "Postal Code",
"customproperty21": "accountEnabled"
},
"colsToPropsMap": {
"accountID": "id~#~char",
"name": "userPrincipalName~#~char",
"customproperty1": "givenName~#~char",
"customproperty2": "city~#~char",
"customproperty3": "jobTitle~#~char",
"customproperty4": "hireDate~#~char",
"customproperty5": "onPremisesLastSyncDateTime~#~char",
"customproperty6": "onPremisesSecurityIdentifier~#~char",
"customproperty7": "businessPhones~#~char",
"customproperty8": "usageLocation~#~char",
"customproperty9": "mail~#~char",
"customproperty10": "telephoneNumber~#~char",
"customproperty11": "physicalDeliveryOfficeName~#~char",
"customproperty12": "streetAddress~#~char",
"customproperty14": "surname~#~char",
"customproperty16": "extensionAttribute8~#~char",
"customproperty17": "country~#~char",
"customproperty19": "preferredLanguage~#~char",
"customproperty20": "country~#~char",
"customproperty22": "department~#~char",
"customproperty28": "onPremisesSamAccountName~#~char",
"customproperty29": "corpCustomAttribute009~#~char",
"customproperty30": "corpCustomAttribute010~#~char",
"customproperty31": "extensionAttribute1~#~char",
"customproperty32": "extensionAttribute7~#~char",
"customproperty33": "extensionAttribute9~#~char",
"customproperty34": "extensionAttribute13~#~char",
"customproperty35": "mobile~#~char",
"customproperty36": "userType~#~char",
"customproperty37": "corpCustomAttribute031~#~char",
"customproperty38": "onPremisesImmutableId~#~char",
"customproperty39": "mailNickName~#~char",
"customproperty47": "facsimileTelephoneNumber~#~char",
"customproperty48": "postalCode~#~char",
"displayname": "displayName~#~char",
"customproperty21": "accountEnabled~#~char"
}
}

 

ACCOUNT_IMPORT_FIELDS:

id,userPrincipalName,givenName,city,jobTitle,onPremisesLastSyncDateTime,onPremisesSecurityIdentifier,businessPhones,usageLocation,mail,telephoneNumber,physicalDeliveryOfficeName,streetAddress,surname,extensionAttribute8,country,preferredLanguage,country,department,onPremisesSamAccountName,corpCustomAttribute009,corpCustomAttribute010,extensionAttribute1,extensionAttribute7,extensionAttribute9,extensionAttribute13,mobile,userType,corpCustomAttribute031,onPremisesImmutableId,mailNickName,facsimileTelephoneNumber,postalCode,displayName,accountEnabled,hireDate

 

Value not coming 'mailNickname'
getting error when 'hireDate' is added in the field list.

 

issue 2:

when we create a new job trigger for full import of accounts, its giving error for so many attributes as invalid.

Error Message - {"error":{"code":"Request_UnsupportedQuery","message":"Invalid property: telephoneNumber","innerError" .............

also this job trigger is hitting https://graph.microsoft.com/v1.0/users/delta endpoint.
question: why a full import job invoking the delta import endpoint?
what is the difference between full import and incremental import job trigger?


Is there any bug related to this? or is it fixed in any future versions?

 

regards,

Partha

5 REPLIES 5

Raghu
Valued Contributor III
Valued Contributor III

Can you share logs


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

rushikeshvartak
All-Star
All-Star

try without hireDate

id,userPrincipalName,givenName,city,jobTitle,onPremisesLastSyncDateTime,onPremisesSecurityIdentifier,businessPhones,usageLocation,mail,telephoneNumber,physicalDeliveryOfficeName,streetAddress,surname,extensionAttribute8,country,preferredLanguage,country,department,onPremisesSamAccountName,mailNickName,facsimileTelephoneNumber,postalCode,displayName,accountEnabled,corpCustomAttribute009,corpCustomAttribute010,extensionAttribute1,extensionAttribute7,extensionAttribute9,extensionAttribute13,mobile,userType,corpCustomAttribute031,onPremisesImmutableId

 

rushikeshvartak_0-1712892677629.png

 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

parthaghosh
New Contributor III
New Contributor III

Thanks Rushikesh.
the account import is working from /users endpoint without the hireDate field. but do you know the reason behind it, why hireDate doesn't come?

and also, why mailNickname not coming in account, even if it comes in REST response in postman.

also any Idea about issue 2?

 

regards,

Partha

Hi @parthaghosh 

Hiredate is not a valid field in Azure Ad, mailnickname attribute value should be populated normally , you can get this checked in ticket as logs may be needed.

Also on the detla token- even in full import it will call the delta graph Api to call to fetch the delta token and keep it so that it can be used for the next incremental runs. so the job will get failed if there are attributes which are not supported by delta token. 

This is the system design to fetch the token, so you would need to use the specific attributes which are supported if not you can use the rest connector to fetch the attributes.

 

Thanks

Darshan

Share postman response.

saviynt internally used deltatoken that’s expected 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.