It's all about the answers!

Ask a question

API to export DNG module views to excel


thimmaiah aa (263) | asked Nov 04 '22, 2:17 a.m.
edited Nov 04 '22, 2:20 a.m.

 Hello,


I wanted to export the view of a module via automation. I'm able to get the view details via the reportable API https://serverNAme:port/rm/publish/views?moduleURI=_YbK4wd6IEeaEaOW7hUvrNQ&viewURI=_iRsR8d6IEeaEaOW7hUvrNQ&projectURI=_uxdv8N3FEeaRC8I0G_Qhlg. But i'm not sure how do we export this data to excel.  Any API for the same?

One answer



permanent link
Ralph Schoon (63.2k33646) | answered Nov 04 '22, 3:44 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

 If you want to use the Reportable REST API and then export the data you get into CSV/Excel, you will have to write the code yourself. If the programming language/environment provides libraries for this, you can use them.


Comments
thimmaiah aa commented Nov 04 '22, 3:47 a.m.

Hi Ralph,


Thank you for the response. Are there any other API to export the view to excel if not reportable?  


Ralph Schoon commented Nov 04 '22, 4:17 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

I do not know. Public APIS are Reportable REST, OSLC and APIs documented here: https://jazz.net/wiki/bin/view/Deployment/CLMProductAPILanding . In addition there are internal APIs that mist not be used by customers.  

The APIs usually do not support excel as output format. OSLC/Reportable REST support RDF/XML and maybe JSON. If you want Excel, you will likely have to do the conversion yourself.


thimmaiah aa commented Nov 07 '22, 12:21 a.m.

No this wont help. I see that DNG is internally using the below API to export the data into excel,


https://Server/rm/export/csv?private=*&vvc.configuration=https:/server/rm/cm/stream/**stream_uuid&exporttoken=1667541259670 

Any idea on this?


Ralph Schoon commented Nov 07 '22, 2:48 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER

No                                           

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.