Account aggregation Task Result CSV. Is it possible that CSV file should be sent out as an email attachment once task is completed?

IdentityIQ (IIQ) IIQ Discussion and Questions
, ,
1

Which IIQ version are you inquiring about?

Version 8.3

Share all details related to your problem, including any error messages you may have received.

Once the Account Aggregation task is completed, Is that possible that the CSV file created in the task result can be sent out as an Email attachment.
If yes, please suggest the possible steps to perform the same.

2

check option for Email Task Alerts in Task Definition , I see below email template can be used and one of the arg is resultId I think this can be used to get the result data .

image
image3082×1346 399 KB

but if you are looking for the CSV attached , i don;t think any ootb option . you may need to use the sequential task were the later one will read the data from the 1st task and send the email with attached CSV.

3

Thanks @vishal_kejriwal1 would you be able to share the reference links if any to read about it on how it can be done.

4

something like below you can use

#set($spctx=$spTools.class.forName("sailpoint.api.SailPointFactory").getMethod("getFactory", null).invoke(null, null).getCurrentContext())
#set($taskResultObject = $spctx.getObjectById($spTools.class.forName("sailpoint.object.TaskResult"), $id))

taskResultObject should have required value .

5

Thanks @vishal_kejriwal1,
We tried the above solutions; we are able to return the taskResult object and also the jasper Result as well, could you please suggest how to convert the jasperResult into human readable format like CSV format.

Thanks

6

I don’t think you can add CSV file with velocity , I would recommend that you cab add the required value in body of email.

1 Like
7

Hi @anubhav_varshney07,

Please try the sample code from below link and let me know if it helps to achieve your use-case.

Thanks

1 Like
8

Hi @anubhav_varshney07 , Is you issue resolved ?

1 Like
9

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.