Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only
  • 1.  Trouble connecting to PAC using API KEY

    Posted Mon February 27, 2023 10:58 AM

    Hi all, I'm trying to connect to the TM1 REST api using the docs here

    IBM Cloud Docs

    I can get an access token fine and if I check it in jwt.ms the token looks good, it has my email, "scope":"ibm openid" etc...

    However if I try to GET the servers at https://de1.planning-analytics.ibmcloud.com/api/v0/tm1Servers then I always get a 401 error and this json. (I'm adding Authorization: Bearer my_token in postman)

    {
        "error""access_denied",
        "error_description""Failed to verify OAuth information. Transaction ID=2232394673"
    }

    My test instance is available through the web UI at https://de1.planning-analytics.ibmcloud.com so I think I'm putting in the correct url.

    The help page says I can try to get the url from the "service launch page" but I've no idea where that is and haven't found anything useful clicking about.

    Can anyone help me with what I'm doing wrong? Please let me know if you need any additional info.

    Thanks, Colin



    ------------------------------
    Colin Overton
    ------------------------------


  • 2.  RE: Trouble connecting to PAC using API KEY

    Posted Mon March 13, 2023 08:55 AM

    Generally, PA on Cloud you need to connect using a 'non-interactive' account. PAoC does not have API key management at this point. 

    Hopefully this article will assist:
    https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=cloud-tm1-rest-api



    ------------------------------
    Michael McGeein
    ------------------------------



  • 3.  RE: Trouble connecting to PAC using API KEY

    Posted Mon March 13, 2023 11:47 AM

    Hi Michael,

    Thanks for the info. Our scenario involves users connecting to TM1 for reporting/dashboarding so they'd have to be able to log in as themselves. It sounds like this isn't currently possible so we'll have to leave this for now.

    Thanks for your help



    ------------------------------
    Colin Overton
    ------------------------------



  • 4.  RE: Trouble connecting to PAC using API KEY

    Posted Mon March 13, 2023 12:41 PM

    Hi @Colin Overton, I think this is a big limitation for the IBM PA Cloud integration capabilities. Please vote for this request for enhancement: 

    Enable IBMid / email (interactive) accounts to access IBM PA Cloud through TM1 REST API

    https://ibm-data-and-ai.ideas.ibm.com/ideas/PAOC-I-1114

    @Michael McGeein, is there any chance we could bring it to the PA DEV team attention?

    Thank you!!!



    ------------------------------
    Vlad Didenko
    Founder at Succeedium
    TeamOne Google Sheets add-on for IBM Planning Analytics / TM1
    https://succeedium.com/teamone/
    ------------------------------



  • 5.  RE: Trouble connecting to PAC using API KEY

    Posted Mon March 13, 2023 01:10 PM

    Voted!



    ------------------------------
    Colin Overton
    ------------------------------



  • 6.  RE: Trouble connecting to PAC using API KEY

    Posted Tue March 14, 2023 09:07 PM

    AFAIR you can request up to 99 Non-Interactive Users at no cost. Assuming you have less than 100 users, a possible workaround is to map each of your users to a distinct Non-Interactive User.



    ------------------------------
    Bernd Siebert
    ------------------------------