Workflow creation for terminated users

Identity Security Cloud (ISC) ISC Discussion and Questions
,
1

Hi All,

I’m working on a workflow in SailPoint to identify whether a terminated user is a member of any governance group. Once identified, I want to send an email to the user’s manager that includes the names of all governance groups the user was part of.

I’ve successfully created the workflow and retrieved all governance groups using an HTTP request. However, I’m facing a challenge with the email part:
When I use {{$.httpRequest.body}} in the email template, it includes the entire JSON response.

My goal is to include only the governance group names in the email.
The API I’m using is:
GET beta/workgroups?filters=memberships.identityId eq "Users_ID"

Can anyone guide me on how to extract and format just the group names from the JSON response for use in the email?

Thanks in advance!

2

Hi @AbhijeetPatil , you need to parse the required details from the HTTP Response like {{$.hTTPRequest.body.id}}. If the response returns with an array, you may need to use Loop operator to get the required details and refer it in the email template. I would assign all the required values into a context variable in “Template Context“ in Send Email action and refer those variables in the Body.

3

You need to use velocity template in your email body for this.

In templating context add:

{"groupNames.$":"$.hTTPRequest.body[*]"}

And edit HTML of the email body to add this:

#foreach ($groupName in ${groupNames})
$groupName.name <br>
#end

This will display group names listed one per line