Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question.

Asked: October 04, 2022 - 7:29 pm UTC

Last updated: October 10, 2022 - 2:14 am UTC

Version: 10

Viewed 10K+ times! This question is

You Asked

Hello,

1. Could you please confirm if we can use REST API as DATASOURCE for RDF report, to generate the output ?

Otherwise, what alternative can be done to store REST API data and then use it for RDF report ? Will Before-Report trigger come into play ?

2. Previously, the RDF reports have been designed using the tables from Oracle CZ schema (Oracle Configurator) and now the requirement is to use REST API as DATASOURCE.

Is there a way to find out what all tables are being used in existing RDF reports without using the conversion of RDF to REX and then do manual search ?


Note :- The answers to above two queries are important (from business point of view), since we are moving onto Oracle Cloud (where everything is better)

Kindly, suggest.

Regards,
Vybhav

and Connor said...

Reports supports XML as a data source, eg

https://docs.oracle.com/middleware/12213/formsandreports/build-reports/orbr_xmlpds.htm#RSBDR00044

but for me, I would look at using some of the APEX facilities to do easy access to a REST data source and us JSON_TABLE or the APEX_DATA_PARSER to convert to result to rows and columns. Thus your SQL would end up being something like:

SELECT line_number,col001,col002,col003,col004,col005 ...
FROM   TABLE(APEX_DATA_PARSER.PARSE
               (p_content   => APEX_WEB_SERVICE.MAKE_REST_REQUEST_B
                                (p_url => 'https://YOU_REST_TARGET.COM',
                                 p_http_method => 'GET')));


Even if never use APEX, installing APEX for all the cool tools it provides is a smart option on any database

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Thank You

Vybhav, October 07, 2022 - 4:42 am UTC

Thank you for providing your valuable inputs, really appreciated.

I will discuss this solution with business and see how easily it can be implemented.

For now the new data will be coming from Azure DevOps databases and bypass Oracle Configurator module tables data.
Connor McDonald
October 10, 2022 - 2:14 am UTC

glad we could help

More to Explore

APEX

Keep your APEX skills fresh by attending their regular Office Hours sessions.