Apex 5
ORDS 3
Tomcat 6
I'm new to RESTful services, and trying to figure out how to consume one.
Scenario:
I have a general application.
In shared components i created a Webservice Reference
1. I used: http://jsonplaceholder.typicode.com/users as the URL which gets a list of users in JSON format.
2. I set NO as to basic authentication
3. HTTP Method i put GET
4. I removed the INPUT PARAMETERS
5. For REST OUTPUT PARAMETERS i add "id", "name" and "email"
I saved it successfully.
And it let me test it successfully using the TEST option in Webservice References.
Then i create a new page.
On the page, i create new REPORT region.
Then i select WEB SERVICE RESULT as the type.
I selected REST as the Web Reference Type
I choose my reference from which i created earlier in the Webservice References.
I selected my fields for output (id, name,email)
Then i clicked CREATE SQL REPORT
I ran the page, and i'm getting NO DATA FOUND
I edited the query and here is the query:
select c001 "id"
, c002 "name"
, c003 "email"
from apex_collections = 'TEST'
So it looks like the webservice results should be placed in this TEST collection.
But it seems this test collection is never executing.
I went to the SESSION in developer mode and changed the view to COLLECTIONS.
There are no results.
Has anyone created a general webservice report using Webservice Result report type?
Am i doing this wrong? Is there another way to do this other then using javascripts methods/calls?