REST API: Cloud

Post Reply
Dimix
Posts: 29
Joined: Fri Jan 15, 2016 2:53 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

REST API: Cloud

Post by Dimix » Tue Jul 02, 2019 9:42 pm

Hi Gurus,

Yes, this is way too complicated for me. :)

I'm using Postman to learn how to use the Rest API. I'm currently reading a local instance of TM1, but now want to connect to an instance on Cloud instead. Seems that the request is a bit different between the two, the local instance require a httpport, the Cloud instance the name of the server. Correct?

Local:
https://localhost:12354/api/v1/$metadata
https://localhost:12354/api/v1/Cubes

Cloud:
https:/xxa01.planning-analytics.ibmcloud.com/tm1/api/Planning Sample/api/v1/$metadata
https:/xxa01.planning-analytics.ibmcloud.com/tm1/api/Planning Sample/api/v1/Cubes

The metadata request works for both instances, but I can't retrieve the cubes from the Cloud instance, I get an error: 401 Unathorized. I have tried different authentication types, but can't get it to work, can't find the correct way to pass e.g. namespace in Postman. Should I be able to connect to an instance on Cloud?

ascheevel
Posts: 90
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: 11.2
Excel Version: 2016

Re: REST API: Cloud

Post by ascheevel » Tue Jul 02, 2019 11:32 pm

How are you authenticating? I was messing with this a couple weeks ago and learned that you can only use the non-interactive user account.

Dimix
Posts: 29
Joined: Fri Jan 15, 2016 2:53 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: REST API: Cloud

Post by Dimix » Wed Jul 03, 2019 7:09 am

Thanks, will take a look at it.

Dimix
Posts: 29
Joined: Fri Jan 15, 2016 2:53 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: REST API: Cloud

Post by Dimix » Wed Jul 31, 2019 10:03 am

I got it to work using a non-interactive account. Next step is to make it work with a 'real' account. Seen somewhere that it should work.

kangkc
Community Contributor
Posts: 196
Joined: Fri Oct 17, 2008 2:40 am
OLAP Product: TM1
Version: 9.x
Excel Version: 200x
Location: Singapore

Re: REST API: Cloud

Post by kangkc » Thu Aug 01, 2019 1:13 am

Based on what I understand from IBM, it will only work with non-interactive account for PA Cloud, which we have validated.
CAM Namespace ID is "LDAP" based on PA Cloud welcome kit.

Never manage to find out the Namespace ID for interactive account from IBM to test it out.
Will be interested if this is possible.

ascheevel
Posts: 90
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: 11.2
Excel Version: 2016

Re: REST API: Cloud

Post by ascheevel » Wed Aug 07, 2019 6:37 pm


Post Reply