I almost got there . if this code helps someone. see below. I know it is specific to our custom entity, but essentially it calls our web service which returns a json object like so {"severity": "Warning", "result": "Your message goes here"}I am saying almost, because I am having issues where on-line sql does not like variables declared as PLSQLAP_DOCUMENT_API.Documentdeclare PROCEDURE PROCESS_RESPONSE(RESPONSE_ IN CLOB) IS JSON_STR_ CLOB; START_ NUMBER; END_ NUMBER; JSON_OBJ_ JSON_OBJECT_T; RESULT_ varchar(4000); SEVERITY_ varchar(20); BEGIN DBMS_OUTPUT.PUT_LINE(JSON_STR_); START_ := INSTR(RESPONSE_, '{'); END_ := INSTR(RESPONSE_, '}', -1); JSON_STR_ := SUBSTR(RESPONSE_, START_, END_ - START_ + 1); JSON_OBJ_ := JSON_OBJECT_T.PARSE(JSON_STR_); --JSON_OBJ_ := TREAT(JSON_OBJ_.GET_OBJECT('data') AS JSON_OBJECT_T); RESULT_ := JSON_OBJ_.GET_STRING('result'); SEVERITY_ := JSON_OBJ_.GET_STRING('severity'); DBMS_OUTPUT.PUT_LINE('Returned response: ' || SEVERITY_ ||
@paulc I am on the cloud version (Aurena). It sounds like I need to open a ticket with support, but I am not even sure what to say in it.
Hello, We heavily use Power BI reporting, we currently have an on-prem assyst environment and we are mid-flight on a project to migrate it IFS SaaS. As part of this it includes amending all of our existing report data sources to the new SaaS database. We also use CSGs to differentiate our data for different customers, I have a wide variety of reports and I am happy to knowledge share with you all. I also like to see how different people have used the assyst db and data for thier reporting. I am looking for somebody who could tell me how to connect Power BI to the data. I am not even sure where to start. Is there some documentation that you found?
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.