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!

ORDS REST service with URL path parameter?

Paul JorstadJan 24 2020 — edited Jan 24 2020

Hello!
I want to have REST services with the PK as part of the URL, like https://host/ords/db1/my_module/person/123321

I.e. pass the unique ID as the last part of the URL. Of course, this is only applicable when there is only one "primary key" parameter This is out of the box when auto REST is enabled but we don't use that. We create every service by hand, preferabely from Apex' UI (RESTful services). By default, the parameter is added as the querystring like this: https://host/ords/db1/my_module/person?ID=123321. In the Apex UI, when you define a parameter, you can select "HTTP_HEADER" or "URI", but I don't see any difference when trying the service out.

Thanks

This post has been answered by Paavo on Jan 24 2020
Jump to Answer

Comments

Very good tutorial and explained to the point.. Great and useful quick reference..

veera2

Thanks for the nice article.  could  you pls explain  what is client and server in this context.

-Veera

Thamizharasu

Thanks for the nice article.  could  you pls explain  what is client and server in this context.

-Veera

Hi Veera2,

Thanks for your question. Client means the client code which will talk to the REST API. Server means the REST API which will produce result for the consumer.

I hope this will clarify your question.

Thanks,

Tham

Ajit Kumar Singh

Thanks for the nice article.

user8193082

nice!!, thanks

User_GIRQ8

Nice article. Could you please explain, how can we limit the number of requests originating from a same IP i.e "Rate Limiting" through Jersey to avoid flooding?@

1 - 6

Post Details

Added on Jan 24 2020
2 comments
2,360 views