Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORDS based Web Source Modules with Parameters problem

Oliver WatersFeb 7 2019 — edited Feb 8 2019

Hi,

Can anyone help me with what I'm hoping is a very simple web source module requirement?

My requirement is to display a classic report with a Value Attribute Pairs - Column Template i.e. based on one row being returned from an ORDS web service. Although for some reason I am struggling to get the response to parse in the APEX application.

Using oracle.example.hr employees module/ template as an example on apex.oracle.com, what am I doing wrong in the following steps?

Step 1 Create App;

Step 2 Create Web Source Module as follows: -

  • Type = ORDS
  • Name = emp
  • Endpoint = (See below) - does this need the /:id/ ??
  • URL Parameter 1 = id
  • Value = 7369

pastedImage_7.png

  • Click Next
  • Click Next Again to accept the Remote Server defaults
  • Click Next to accept no Authentication
  • Click Discover
  • Gives the below error: -

pastedImage_10.png

  • If I now click Advanced and remove the 7369 from the value parameter it will now Discover ok; however

When using this web source module in a classic report, and setting the parameter attribute to a static value of 7369 (SMITH/CLERK)

pastedImage_15.png

The application gives this error: -

pastedImage_16.png

Does anyone know what I'm doing wrong here and how to correctly parse an ORDS based RESTful service defined via SQL Workshop to accept parameters for a single row?

Thanks in advance,

Oliver

This post has been answered by Oliver Waters on Feb 8 2019
Jump to Answer
Comments
Post Details
Added on Feb 7 2019
9 comments
775 views