IBM Apptio

Apptio

A place for Apptio product users to learn, connect, share and grow together.


#Aspera
#Apptio
#Automation
#FinOps
#Apptio
#ITAutomation
 View Only

  • 1.  API in Access Administration to GET Domain Users

    Posted 05/22/25 11:32 AM

    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.



    ------------------------------
    Joseph Fant
    ------------------------------


  • 2.  RE: API in Access Administration to GET Domain Users

    Posted 05/23/25 02:08 AM

    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.



    ------------------------------
    Andrew Bell
    ------------------------------



  • 3.  RE: API in Access Administration to GET Domain Users

    Posted 05/23/25 08:49 AM

    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.



    ------------------------------
    Julie Whitehurst
    ------------------------------

    Original Message


  • 4.  RE: API in Access Administration to GET Domain Users

    Posted 05/23/25 08:54 AM

    Thank you, I will give it a try today!



    ------------------------------
    Joseph Fant
    ------------------------------

    Original Message


  • 5.  RE: API in Access Administration to GET Domain Users

    Posted 03/29/26 07:58 PM

    It took me a while, but I eventually got there with help of support.

    The Frontdoor API is a complex with nested data depending on custom or standard role usage.

    In addition to the above instructions from Julie listed on connecting Datalink to Frontdoor API, we had to use resource path url of api/v2/environmentusers/environment/{envId} and also:

    1. use a payload indicator of "data^objects"

    2. Limit-Offset as Pagination type as the API has a limit of records returned so if you have large userbase/role assignments you'll go over ti

    3. Limit Param Value of 450 and Offset Param Name of start


    Then on the TBM Studio side, add a formula step after import on the destination table (the destination table name entered in datalink)

    customRoles environment =If($_ = "",result customRoles environment,$_)

    customRoles id =If($_ = "",result customRoles id,$_)

    customRoles name =If($_ = "",result customRoles name,$_)

    defaultRoles id =If($_ = "",result defaultRoles id,$_)

    defatultRoles name =If($_ = "",result defaultRoles name,$_)



    ------------------------------
    Andrew Bell
    ------------------------------

    Original Message


Related Content