Webi Report Table to Json

[Former Member]

I have a simple table like this in my Business Object Report.

I need to capture these data inside the table in Json format.

"Table1": { 
  "201601": "305",
  "201602": "253",
  "201603": "231",
  "201604": "252",
  "201605": "60"
  },

The ultimate purpose is to use it for D3.js

to create a animated bar chart.

********************************************************************

I have read the following articles.

I have a tiny basic knowledge of Restful & Javascript.

I need further resources to know how to capture data inside dimensions & variables

...

Could anyone guide me to the right resources...?

[daniel_paulsen · Accepted solution]

Hi Hayden,

You can retrieve the dataset of a report element (in this case a VTable) using the following URL:

GET .../raylight/v1/documents/<docId>/reports/<reportId>/elements/<elementId>/dataset

the documentation can be found at:SAP BusinessObjects Business Intelligence platform 4.1 – SAP Help Portal Page          

Look for the guide: "SAP BusinessObjects RESTful Web Service SDK User Guide for Web Intelligence and the BI Semantic Layer" and go to the section on report elements. There is a sample response for a vTable element that should meet your needs.

Dan

[Former Member · Accepted solution]

Thank you  Daniel...!

I have been searching for hours to find right documentation.

I really appreciate your support!

[Former Member · Accepted solution]

It is asking me for password...

I will keep researching online if I can get it from somewhere else...

[daniel_paulsen · Accepted solution]

Hi Hayden,

Yes, you will need an S-User ID to log onto the Service Market Place (SMP) to access the RESTful documentation.  You can ask your Admin to create a logon for you or download the documents for you.

in the meantime, you can figure out how to get the dataset by using

/documents                                                                          to GET the document ID

/documents/<docId>/reports                                             to GET the report ID

/documents/<docId>/reports/<reportID>/elements       to GET the element ID

Dan

[Former Member · Accepted solution]

Thank you so much!!!!