Integrate SailPoint with a Power BI dashboard

Hi Team,

We are planning to integrate SailPoint with a Power BI dashboard to display the following KPIs:

  • Total number of applications currently integrated with SailPoint (Connected vs. Disconnected)
  • UAR / PER status: Completed / Pending / In-Progress
  • Applications included in RBAC integration (Yes/No)
  • Application mapping with LeanIX to identify BU, Owner, Region, Application Status, and Total User Count
  • Number of applications to be onboarded on a quarterly basis (based on an Excel sheet, refreshed quarterly)

While reviewing the available API collections, I was unable to find an API that provides a list of applications.

Could you please share the relevant API collection or suggest an alternative approach to implement this integration with Power BI?

Regards,
Srinivas.

Hello @srini_carrier

Yes you are correct that currently there is no API that provides applications list. You can try custom approach by creating REST endpoint using sailpoint.rest.Resource and return a list of Application objects.

public class GetApplications extends BaseCustomEndpoint {
    @Override
    public void getApplicationsList(SailPointContext context, HttpServletRequest request, HttpServletResponse response) {
        try {
        List<Application> apps = context.getObjects(Application.class);
        List<Map<String, Object>> result = new ArrayList<>();
        for (Application app : apps) {
            Map<String, Object> row = new HashMap<>();
            row.put("name", app.getName());
            row.put("type", app.getType());
            row.put("owner", app.getOwner());
            row.put("rbacEnabled", app.getAttribute("isRBACIntegrated"));
            result.add(row);
            
        } catch (Exception e) {
            writeErrorResponse(response, e);
        }
		return result;
    }
}

After fine tuning this code you can expose it via sailpoint.web.WebService

Hi @asharma65 ,

Good day!

do you have any document or reference for creating REST endpoint, could you please guide me?

Regards,

Srinivas.

Hi @srini_carrier

There are no direct rest apis to get this data, instead you can think about solution in the below way.

You can create sql data source in power bi and connect to identityiq database via a service account and get all the required data using spt tables

all the data that you are asking can be retrieved vua sailpoint identity iq spt tables.

1 Like

Hi Ashish,

Is it possible to get a list of built applications via the Search Tab or using Postman? I have tried using several suggestions using the AI option on the Search screen inside ISC but nothing returns. I have also looked for a List Applications or Get Applications in Postman but again nothing is being returned.

Hi @asharma65

Yes, it’s possible to retrieve the list of built applications from IdentityIQ using Postman. You can use the following SCIM API endpoint:

GET http://localhost:8080/identityiq/scim/v2/Applications

Thank you.

Sorry, we are on Identity Security Cloud.

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