API(s) for Prognosis?

[Michael_Cunning]

Are there any, or any plans for APIs? We would like to query prognosis for integration with other applications using api(s) if possible.

[Adam_Annen]

Hi Michael,

Although I do not know much about it, I believe the API you might benefit from is called 'REST API'. It has been mentioned a couple times in this forum.
If you do not get the answer you need here, do reach out directly to your IR Account Manager on this need.

[Michael_Cunning]

thank you yes we would want to leverage a REST API I'll do a search and see what I can find here. thanks

[Adam_Annen]

Hi Michael,

I have some good news for you. I was able to reach out to some key staff and get the information on REST API for you.
I will shoot you a direct email on this.

If you like what you see, I encourage you to post back here with feedback so others know this is a viable option they might want.

[Michael_Cunning]

Great news thank you Adam! I will look for the email and will reply back here if it's what we're looking for. appreciate it!

[Shoaib_Dilawar]

Hi Michael,

Rest API exposes prognosis data to web applications on https and returns data as json.

A similar, more programmable interface is PQL, a SQL like syntax for interacting with prognosis data through command line. We also have a node.js based interface to execute PQL statements to gather prognosis data in java script.

We have a hands-on technical deep dive session into these APIs in our upcoming prognosis summit. Have you registered for it? To find more details, please see the forum post: https://online.prognosis.com/forum/ir-prognosis-summit/prognosis-summit-2017/ or go to http://www.ir.com/summit

Hope to see you there.

[Michael_Cunning]

trying to access the REST api the documentation says:
Authorization and Security
Access to the Rest API is restricted to users as defined in the Settings.xml file located in \WebUI\IIS\

We cannot locate that file on our install of Prognosis is there an add on or a place to turn on the API so we can hit it?

[Shoaib_Dilawar]

Hi Michael,

settings.xml was an old way to configure security related settings that is obsolete now. Can you try to access https://server-name/Prognosis/rest/v1/data/ and see what you get? It should list you all the available views that you can get data for.

And then you can append the viewname in the url and get the data for that view. Let me know if it works.

[Michael_Cunning]

thanks - using that on the mangement node gives me this:
This XML file does not appear to have any style information associated with it. The document tree is shown below.


I also tried it with a machine account and it downloaded a data.json file that was empty.

[Shoaib_Dilawar]

Do you have rest xml defined with proper pql views? This should be located at Prognosis\WebUI\IIS\Administration\Config\RestApiDataSets.xml

You can send me a copy of the xml if you have content in it and not getting expected results.