Skip to Main Content

ORDS, SODA & JSON in the Database

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!

REST data services URL format best practices?

Aaron L.Nov 15 2021

Is there any documentation or recommended reading on how to create your REST Data Services URLs (URIs?) properly?
An Oracle consultant showed me how to make one service 3 years ago and I've used that enough to make a few more, but I feel like I'm creating a mess by not knowing the best strategy.
For example:
My standard I've been using is
domain_name /ords/schema_name/module_name/json/{myParam}
To get an employee record it would be something like
domain_name /ords/hr/emp/json/HT3232
But I read somewhere a while back that said there should be just one "emp" data service for many different requests. I know I can add GET, POST, PUT, and DELETE handlers, but am I restricted to one of each of those per service "module" (what it is called in SQL Developer)?
Can I make something like domain_name /ords/hr/emp/json/HT3232/supervisor to get the emp's supervisor's record? What should I know that I don't?
I'm just looking for advice on a good read to learn best practices on this. Is it a book, Oracle doc, great web site?
I'm running Oracle REST Data Services 18.4.0.r3541002 and SQL Developer 19.4.0.354

Comments

Post Details

Added on Nov 15 2021
3 comments
955 views