Click HERE to see how Saviynt Intelligence is transforming the industry. |
07/16/2024 09:18 AM
Hi there,
We import accounts from ServiceNow using the rest connector. We are unable to fetch the department name.
ServiceNow department attribute has JSON value. This value stores two attributes: 1) a link and 2) value. (I tried that link in Postman and it returned all the attributes of the department, I can see the name, and display name attribute)
I believe we need to tweak ImportAccountJSON and make a nested call to fetch the department name.
Screenshot: Accounts > Other Attributes
Regards,
Pritesh Bhawsar
07/16/2024 09:30 AM
07/17/2024 01:46 AM
@pbhawsar Did you refer below forum thread
07/17/2024 02:59 AM
I already tried "CUSTOMPROPERTY5": "department.value~#~char", but this doesn't fulfil our use case. It shows the value of the department on CP5, the value is non-human readable.
For instance, if the department name is "Customer Support" then the value might be "5d7f0044e0bfc871020e5bcb17f03d43"
(we need the department name as a value to be populated on CP5, which can be fetched by another REST call. In the department JSON, the Link attribute value is the URL for that call, and if we use the GET method with the link URL, we'll get the JSON response of the department. From the JSON response, we can fetch the department name.)
07/17/2024 09:07 PM
07/19/2024 02:14 AM
Hi @rushikeshvartak ,
Yes, exactly! It requires a nested call to fetch the department name (I mentioned it in the post).
Could you share the snippet of how to make nested calls in ImportAccountEntJSON and update the CP5 with the department name?
07/19/2024 05:54 PM
Does department api response contains account name ?
07/22/2024 12:26 AM
It doesn't contain an account name. it's an independent API call.
07/22/2024 09:31 AM
07/22/2024 11:34 AM
Is there any way to update these values? Because it's not only a department attribute but the same case with the manager, location, cost center, company and other attributes.
07/22/2024 11:48 AM
08/01/2024 06:50 AM
Hi @pbhawsar
Could you please try with the below in call2 and confirm if it works.
${response.department.message.links[0].href}"
Regards,
Dhruv Sharma