Skip to main content
Pentaho Documentation

App Endpoints for SDR Forms

These are a few API endpoints that you can also use to run the app. To perform a command, alter this example to match your parameters:

http://{host}/pentaho/plugin/{pluginID}/api/{command}

Here are a couple of examples using some parameters:

Genre Selector API:

http://localhost:8080/pentaho/plugin/SDR/api/genre 

Example Response:

 {"metadata":[{"colIndex":0,"colType":"String","colName":"GenreID"},{"colIndex":1,"colType":"String","colName":"Genre"}],"queryInfo":{"totalRows":18},"resultset":[["Action","Action"],["Adventure","Adventure"],["Animation","Animation"],["Childrens","Childrens"],["Comedy","Comedy"],["Crime","Crime"],["Documentary","Documentary"],["Drama","Drama"],["Fantasy","Fantasy"],["Film-Noir","Film-Noir"],["Horror","Horror"],["Musical","Musical"],["Mystery","Mystery"],["Romance","Romance"],["Sci-Fi","Sci-Fi"],["Thriller","Thriller"],["War","War"],["Western","Western"]]}

Gender Selector API:

http://localhost:8080/pentaho/plugin/SDR/api/gender

Example Response:

{"metadata":[{"colIndex":0,"colType":"String","colName":"GenderID"},{"colIndex":1,"colType":"String","colName":"Gender"}],"queryInfo":{"totalRows":2},"resultset":[["M","Male"],["F","Female"]]}
List of App Endpoint Parameters
Endpoint Description
genre Populates the options for the genre selector.
gender Populates the options for the gender selector.
occupation Populates the options for the occupation selector.
income Populates the options for the income selector.
firstdate Returns the limit dates for the data to be processed.
data_source_name Returns the names of all data sources available on the server.
latest_requests Returns the latest 10 requests made in a table, instead of inside of a popup.
sdr_data Processes the request and returns the status of the data.
refresh Refreshes the kettle and dashboard elements to reflect any saved changes. Clears the cache for all kettle endpoints.

A larger number of API endpoints can be found in the Pentaho Developer's Center.