Hi Moises,the Cognos Mashup Sevice (CMS) sounds like what you are looking for (In fact, the early internal working name for CMS was "RaaS - reports as a service". 😎). CMS is built into CA, so it's ready to be used (there are samples available as well). CMS provides both a REST interface and a SOAP (doc/lit) interface to consume a Cognos report as a web service. CMS also allows you to choose the output format used in the response, to match your needs (for your usecase, you probably want to look at the DataSet, DataSetJSON, or the JSON output formats).
Here's a link to the documentation on Cognos Mashup Service: https://www.ibm.com/docs/en/cognos-analytics/11.0.0?topic=guide-overview-mashup-service
The above documentation will show you the options on how to authenticate (including the CMS auth service option), how to send a request to the report web service, for the respective report (and specify the desired output format), and more advanced use cases (such as dealing with prompts and how to work with saved report output versions in the CMS API).jim
Cognos has a very rich REST API that exposes many of the elements in various formats.In addition to what Jim posted, here's a super quick cheat sheet:Construct the URL like this: https://SERVER/ibmcognos/bi/v1/disp/rds/reportData/searchPath/<SEARCHPATH>?fmt=datasetJSON&async=off&p_pYear=2022&p_pParameterWithSpecialCharacters=<![CDATA[aa%^&*a]]>In addition to JSON you can also have it return HTML or HTML fragments, it can even convert the report into images.I use CMS for a number of tools, including my Alerts system:
In the background it's running a report, with data filters specific to the user, and then generating various types of alerts (showing Banner and Toast here)I've also used it to make a search prompt that doesn't require the report be submitted to see the results.Outside of Cognos I've used CMS to populate the screen of a CRM, and another time to embed data in an education website.In addition to the reports, you can also use the Cognos REST API to read and work with Cognos programmatically. https://www.ibm.com/docs/en/cognos-analytics/11.2.0?topic=api-rest-reference. This is security aware, so it won't show objects the user doesn't have access to.