TM1 Forum

Hello everybody,

we're testing TM1 10.2 to create custom dashboards together with a web-developer.
(10.2 is not a must for us.)

Ist it somehow possible to get views as raw-csv files from the TM1 Application Web-Api?
We found the following link, but we couldnt find an equivalent for 10.2. http://goo.gl/d5vCJ6

Thank you very much in advance.
Moritz

moritz wrote:Ist it somehow possible to get views as raw-csv files from the TM1 Application Web-Api?
We found the following link, but we couldnt find an equivalent for 10.2. http://goo.gl/d5vCJ6

Well, that's not really an API in the form you are talking about. It's just for creating hyperlinks that are designed to take you to specific objects in TM1 without having to navigate your way there through the UI. What you want to do, create a CSV dump of a cube view, is not possible with the Web API. Even with the regular API it's not really feasible. What you need to do is create a shell TI process that accepts input parameters, in which you build the subsets, views, writes the CSV file, and then cleans up after itself. You can make most of this dynamic with the parameters passed. You can then call the TI with TM1RunTI.exe so you don't have to be logged into TM1 to run.

Hi Tomok,

thank you for your answer.

We also thought of that! But the request time would take to long.

In the meantime we inspected the new TM1 10.2 Application Web Interface.
The data is called by these two requests:
https://www.dropbox.com/s/zymse7r6f07lm ... .54.34.png

The problem is, that the response data is already rendered into the final form.
We're pretty sure, that we could misuse these files to generate the wanted data via cURL. ( http://goo.gl/sGNdDo )

I look forward for your opinion.
Greetings from Germany