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"]]}

Here is a 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.