Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

API to export DNG module views to excel

Questions
Tags
Users
Badges
thimmaiah aa
(26●3) 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?

0 votes

1 answer
824 views
0 votes

One answer

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (63.9k●3●36●48) Nov 04 '22, 3:44 a.m.

 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.

0 votes

Comments
thimmaiah aa
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
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Nov 04 '22, 4:17 a.m.

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
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
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Nov 07 '22, 2:48 a.m.

No                                           

Your answer

Register or log in 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 10,938

Question asked: Nov 04 '22, 2:17 a.m.

Question was seen: 824 times

Last updated: Nov 07 '22, 2:48 a.m.

Confirmation Cancel Confirm