I'm using Microsoft Power Automate to get all domain users in IBM Apptio (Access Administration) and put it into either a SharePoint list or onto an existing Excel file in SharePoint. This will help streamline and automate our monthly update emails.

It completely surprises me that there is no ADM or Datalink to be able to pull frontdoor/access environment information into TBM studio automatically.
For customers that use TargetProcess as well, not been able to keep users/integration users in sync from Apptio only tools is a pretty big gap.

I'm using Microsoft Power Automate to get all domain users in IBM Apptio (Access Administration) and put it into either a SharePoint list or onto an existing Excel file in SharePoint. This will help streamline and automate our monthly update emails.

I recently inquired about ingesting the Access Admin data into a reference table in Cost Transparency and my premier support contact shared the following with me.  

This can be done via REST connector in Datalink. Here are the steps:

1. You would need to provide an API key pair for your DL service account (normally start with uls_svc).
2. Follow the instruction in REST Connector setup
3. Find your environment ID in Access Admin
4. Setup for REST:
1. HTTP Method = Get
2. Authentication Type = Apptio; REST URL = https://frontdoor.apptio.com
3. Need Refresh Token = Yes
4. Insert the Public Key into Frontdoor Key and Secret Key into Frontdoor Secret
5. for Environment User report, the path = api/export/environmentusers/environment/{envId}

 My contact also said that if we aren't able to configure it successfully, that we could seek assistance from the support staff.  You may need to open a support case if it doesn't work.  Hope this helps.

It completely surprises me that there is no ADM or Datalink to be able to pull frontdoor/access environment information into TBM studio automatically.
For customers that use TargetProcess as well, not been able to keep users/integration users in sync from Apptio only tools is a pretty big gap.

I'm using Microsoft Power Automate to get all domain users in IBM Apptio (Access Administration) and put it into either a SharePoint list or onto an existing Excel file in SharePoint. This will help streamline and automate our monthly update emails.