I can do an export of all Identities through the UI, but not all Identity Attributes are present.
Use Case… Being able to preview Identity values on given individuals is great prior to making any mapping changes. Love that feature. But I want to get all identities with all of their attributes to see what may have been missed, or to prove that risks are minimal going to production as all of the Identity Data is consistent and transforms as needed. I want to be able to anticipate issues due to dirty data or maybe a possible requirement that was missed.
What would be the best API route to go? Get a list of all Identity Attributes, Get a list of all Identities, call each Identity individually and get all Identity attribute from the specific Identity? Write out each Identity to a CSV with their corresponding values and then evaluate for inconsistencies…??
As you’ve pointed out, there are a few approaches you can take to do this. You can use the list identities endpoint with pagination to get all identities in your tenant with their attributes, or you can use the search API to get all identities, which will include a lot of information about each identity including their attributes. In either case, the result will be an array of JSON objects, which might not be the best format for your reporting needs. I highly recommend you check out my video on API reporting to see how you can utilize the typescript SDK to fetch all identities using the list identities endpoint and then transform the results into a CSV file.
I probably won’t get to this in the next week or two, but I may try with Python, using Pandas with vscode Jupyter Notebook. The idea being that the dataframe is visual and doesn’t have to be exported to Excel if you don’t want it. The trickiest part will probably be the JSON Objects.