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
- Click Next
- Click Next Again to accept the Remote Server defaults
- Click Next to accept no Authentication
- Click Discover
- Gives the below error: -
- 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)
The application gives this error: -
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