I follow your insteruction for API access https://server-name/Prognosis/rest/v1/data/
however, I am getting below error
The dataset setting looks good to me in RestApiDataSets.xml.
Can you guid me access the data using API?
if there is syntax error in the query inside your restapi xml file, then it may give that error. Can you try running the query manually (that you have in the dataset xml) to make sure it works fine on cmdline?
As sugested by you I tried running the querries from CMD using ..\irpqlcli.
They are working fine as expected, see below.
sometime restarting IIS>PrognosisSite can reset the views. try that, if it doesn't work, you can open a support case, send us the dataset XML and we can have a look.
Hi @Amol ,
I was working with our support team on your issue and I am guessing you were not logged into prognosis when you tried to run that URL? To access REST objects, you first need to login to prognois webUI, otherwise server will come back as 500.
Once you log in, we were able to verify that your rest xml (same as out of box xml) loads fine. Look out for a closure from support team on this as well.
The current Prognosis Online help document has the following statement about the REST API Authorization and Security:
"If the Rest API request contains the cookie that belongs to the existing Prognosis Web Application session, the cookie will be accepted and the role will be recognized and authenticated. Otherwise request is not coming from the existing Web Application session, and HTTP Basic authentication will be required in the REST request."
We will update this statement to clearly include the Prognosis Web Application login step to get REST API to work.
Thank you for bringing this to our attention.