TM1 Forum

Hi,
I am trying to use TM1 Rest API to retrieve Metadata from the Chores like Chores names, their Parameters, their set run time, etc... which would be given to our clients in a separate interface -- be it anything. They want to click a button and see all the details of Chores.

What is the way to do it is what I am perplexed about. I am completely new to the API World and under a lot of pressure to do it.

• Should I try to use Excel TM1 Workbook to do it -- is it possible to link Buttons with API Calls?

• Or should I try to use TI processes to link the API Calls -- is it doable in any way?

• How do I display the retrieved data (which would be in JSON format) properly to the clients? My thought is they would not like to see the data in JSON format but rather in some easy-to-read format with all the data retrieved properly.

Please help!

Many thanks,
-Arden

Hello,

Did you see this topic ?
https://www.tm1forum.com/viewtopic.php?t=16195

You will indeed format the JSON output to something more readable and accessible.

For this requirement I suggest you have a look at Arc. It does exactly what you describe (click on a chore and see everything about the chore in a separate pane). Of course it does a whole lot of other stuff as well. But the price per user is very small compared to what I imagine the cost of your time is to build a bespoke application which does a lot less.

(I'm an employee of the company behind Arc but I'm not a sales guy and derive no financial benefit from it's sales).

Do you expect users to see the chores (they would need the corresponding permissions) or some admin account to export this information somewhere?

Using TeamOne Google Sheets add-on (free for developers), you can see, search, compare and deploy chores directly from Google Sheets (no installation is required):