Exporting Identities with Specific Attributes via API

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

I would like to perform a search and export all identities from our system, focusing on specific attributes, and have them organized in a predefined order within a CSV file.

Here’s what I aim to achieve with this CSV export:

Retrieve all identities from the system: I want to include all existing identities

Specify specific attributes: I would like to extract particular attributes for each identity, such as displayName, country, entuty, externalEmail, etc. I have a predefined list of attributes that I want to include in the export.

Maintain a predefined order: It would be ideal if the attributes appear in a specific order in the final CSV file. This will greatly facilitate subsequent data analysis and processing.

One specific question I have is: Is it feasible to achieve this export using the IdentityNow API?

Thank you in advance for your time and assistance.

2

@rayannait

You should be able to achieve this by searching @access(source.name:IdentityNow) which will display all identities in your tenant then you can use the column chooser on the right side of the table to choose the attributes you desire to have in your report. The order will depend on the sequence you choose the attributes from column chooser.

Yes, you can use this API to get it via API but your response would be limited and you would need to parse the json response to csv.

1 Like
3

Thank you for your reactivity and your answer.

Is it possible to use the same function available in search via column selectors but in an API call?

We’d like to sort our attributes in a certain order.

4

Hi @rayannait
You can customise as you wish using search endpoint
here - search-post | SailPoint Developer Community

        sort: ["-attributes.email"],
        queryResultFilter: {
        includes: [
            "displayName","email","attributes.location","attributes.cloudLifecycleState","attributes.brand"
        ]}

I would recommend to utilise SDK built by @developer_relations .

5

Hi Antony,

Thanks for answering

I managed to get the right attributes, but not in the order I wanted.

I’ve tested this api call, but it involves sorting identities, whereas what I want to do is sort attributes.

6

Hey @rayannait
I think that can be achieved with any programming language.
For example, I am returning the selected fields using custom column names in the order I required.

let certs = val.data.map(cert => {
            return{
                campaign: cert.campaign?.name,
                phase :cert.phase,
                reviewer: cert.reviewer?.name,
                reviewerEmail:cert.reviewer?.email,
                Progress: (cert.decisionsMade as number /(cert.decisionsTotal as number))*100 + "%",
                total:cert.decisionsTotal,
                decision: cert.decisionsMade,
                completed: cert.completed,
                signed: cert.signed,
                reassignmentStatus:reassigned ,
                reassignedFrom: cert.reassignment?.from?.reviewer?.name,
             }
}

PS: Above example is achieved through typescript using the SailPoint SDK.

1 Like
7

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