Oracle Analytics Cloud and Server
Is there a RESTAPI available to access OAC charts?
Summary:
Hello,
Is there a RESTApi available to access OAC charts?
Content (required):
I have a requirement to automate the health status of OAC charts (if any of the charts are broken we would like to trigger an alert). I want to develop an automation script for this using Canaries.
This would require access to the API. Is there an API that is be available for the current OAC, that I could access?
Version (include the version you are using, if applicable):
OAC v6.1
Code Snippet (add any code snippets that support your topic, if applicable):
N/A
Answers
-
To my knowledge there isn't a native API to check the status of a visualization. By broken I'm assuming you mean there is a Query Error.
If that is the case you could build a solution leveraging the Usage Tracking features - if you're using ADW as a source you could then build an API against the Usage Tracking table to get the status of a query.
-
You are right. By broken I mean a Query Error. Would the Usage Tracking feature enable me to detect the text 'Query Error' when occurs? Would this text be part of the query_blob field?
Thanks, Chethana
-
There is a field that is used to define when a query error occurs. I believe the field is on the Logical Query table, identified as SUCCESS_FLG.
To my knowledge a query error would result in SUCCESS_FLG = '3'.
As far as identifying what Project/Canvas this error occurs on I would look to the SAW_SRC_PATH field on the Logical Query table.
-
Thank you
-
The field SAW_SRC_PATH in utlogical table returns null, when SUCCESS_FLG = '3'
Is there a way to find the Project/Canvas name where the error has occurred?
Thanks in advance,
Chethana
-
That is unexpected behavior...
It may depend on how your underlying data model is being created. Are you leveraging an RPD based approach?
-
Yes, we are leveraging RPD based approach and seeing this. Any recommendations to correct this?
-
I would have to poke around your environment. My only other suggestion is to try and parse the canvas information from the Query Text/Blob.
-
Okay. I've actually tried parsing this info from Query Text/Blob. It does'nt seem to give the right info. I am unable to find Canvas name in these fields.
Also, what is the recommended procedure to generate the RPD ? Does it need to be re-generated when we connect to a new ADW? (in our case we have used an existing RPD with a new ADW and tenancy).
Apparently, the query, "select saw_src_path,query_blob,query_text from utlogical where success_flg=3 and saw_src_path like '%canvas%'" gives me desired results with old ADW - I have issues when connected to new ADW using same RPD.
Thanks, Chethana
