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!

JSON and Web Service reference (Parameters)

Richard LeggeOct 10 2017 — edited Oct 12 2017

APEX 5.1 SE 12.1

Hi, I've been trying to get a POST Web service working. Initially by using the IN and OUT parameters (which I couldn't.).  After much research, the recommendation it seems is to use JSON as the input source.

I finally got a service working via this method, and have created a Web Service Reference.

My question is: When it comes to using the Web Service reference in my app via creating a process of type web service, and choosing the service. How can I turn the JSON input specified on the input, as parameters on the process? Are there substitution variables for the JSON? If so, what is the format?

Also, why do parameters not work at all..  (If you want to check on apex.oracle.com workspace: VRS usename: test password: test   Application:291     Check the RESTful Service definitions (in test), and the Web Service references. There is a working JSON POST reference (you need to set HTTP Header Content Type to application/json when you run the test). There is also a working GET reference, and a non working POST reference with input parameters)

Rgds

Richard

This post has been answered by Pavel_p on Oct 10 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 8 2017
Added on Oct 10 2017
3 comments
437 views