The Prognosis REST API provides the function of executing the custom PQL query. Please refer to the online help for it:
Hope this helps.
NO, utilizing the RestAPI is not the easiest way of doing this as it doesn't accomplish getting the actual display of the data.. the RestAPI is for utilizing a very limited data set in another application in limited circumstances at this point.
There are several different ways you can get the data into the Prognosis WebUI; it all depends on the structure of the query and number of fields. We cover this in the Advanced Dashboard manipulation course where PQL is a prerequisite.
There are two way you do this though at a high level for a customer.
1) Execute the query from PQL via an Extractor; pull it into a custom record via an extractor script. Then it is in Prognosis and usable in both user interfaces.
2) Create a shell dashboard on that record and publish it to the web with the same number of fields; change our the PQL query it executes in the .DASHBOARD file and usually also in the query_user.xml file.
If you have services hours we can help you work through this as well.