One of the interesting things in knowing how to work with the API is that we can use CDA to get data into an external application. This is interesting if we're not using CDE or CDF to build the dashboard. Anyhow, a good reason for you to know about the API is so you can go further when using CTools.
You can make requests to CDA using Web API. The base URL to use is $BASE_URL/$WEBAPP/plugin/cda/api/
, where $BASE_URL
is the protocol, hostname, and port, and $WEBAPP
is the web application name used on Apache Tomcat, and the default webapp is defined as pentaho.
For example, the following URL is referring the pentaho
webapp: http://localhost:8080/pentaho/plugin/cda/api/doQuery?path=/public/plugin-samples/cda/cdafiles/mondrian-jndi.cda&dataAccessId=1¶mstatus=Shipped
Next we will cover the available endpoint. An endpoint, defines the particulars of a specific endpoint at which a given service is available.