Using ISC API to run an identity search inside of a workflow and grabbing the returned results and displaying them in an email

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

Hello i’m kind of stuck atm due to client and ISC restrictions, but the goal is to run a search query for users terminated within the last 24 hours. I need the results displayed in an email but terminations can be more than 20 people so using a subscription and previewing the results is not an option.

The search part works fine in the workflow and returns a list of users in JSON format. I can’t display my code, but I was wondering if it was possible to grab those results and display them on an email to bypass the 20 user restriction set via subscription? if possible, how would that email template look like inside of the workflow.

I saw the article post a month ago about copying the template for the subscription email and using it but i’m not sure how that works.

Thanks.

2

Hi,

Using workflows you can run the search query API and send all results in the email. In email you can write velocity to use the returned data and construct a table in HTML.

-Abhinov

3

You can pretty much do that in Workflow. Since you are already succeeded with Search query in the Workflow, I assume the search result will be an array list and you need to

  • Create Send Email Action
    • Build the HTML table in the Body
    • Iterate through the Search result’s array list by using VTL and set the value to each cell

Here is the reference Workflow: Fetch Array from HTTP request and send in Email in a table with separated values with similar scenario.

Hope this helps you.

1 Like