ServiceNow - Importing manager attribute

[kunal_saxena]

Hi,

We are importing accounts from ServiceNow. We are facing issue while importing manager attribute into Saviynt.

We are getting manager value as below from ServiceNow.
[
  link:https://xyz.service-now.com/api/now/table/sys_user/5313cdb697cdf1545e9b74b722346e,   value:5313cdb697cdf1545e9b74b722346e
]

Can someone please suggest how we can update manager attribute in ImportAccountEntJSON mapping to retrieve manager's username instead of above value?

Also how we can pass manager attribute in CreateAccountJSON for ServiceNow? Tried passing ${userManager.username} but it didn't work.

Thanks,

Kunal

[SumathiSomala · Accepted solution]

@kunal_saxena you can exclude reference link in the url

"url":"https://XXXXXXXXX.service-now.com/api/now/table/sys_user?sysparm_query=active=true&sysparm_exclude_reference_link=true&sysparm_display_value=true"

otherwise  try below mapping

"CUSTOMPROPERTY8": "manager.value~#~char",

[kunal_saxena]

Thanks @SumathiSomala . The suggestion to exclude reference link in the URL worked.

"url":"https://XXXXXXXXX.service-now.com/api/now/table/sys_user?sysparm_query=active=true&sysparm_exclude_reference_link=true&sysparm_display_value=true"

Now, we are able to import manager into Saviynt in FirstName LastName format.

[rushikeshvartak]

Refer https://forums.saviynt.com/t5/identity-governance/importing-user-manager-from-servicenow/m-p/11969#M...