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!

Oracle apex - ORDS RESTful Services - Post list object

Khoa KimApr 21 2022

Hello, I have successfully posted 1 object from client to ORDS RESTful Services.
But the problem is my data is too big from many clients. The api request too much makes the amount of CPU processing is very high.
So I want to reduce the number of requests by instead of posting 1 object, I post an array of objects. Example:
{
"listobject": [
{
"field1": "17",
"field2": "141",
"field3": "1",
"field4": "24-04-2022 15:30:45",
"field5": "INFO",
"field6": "Abc1234567890"
},
{
"field1": "17",
"field2": "141",
"field3": "1",
"field4": "24-04-2022 15:30:45",
"field5": "INFO",
"field6": "Abc1234567890"
}
]
}
I tried but ORDS RESTful Services throw 555 User Defined Resource Error when i get data using :listobject operator (listobject is name of array in json text).
Can you help me. Thank you.

Comments
Post Details
Added on Apr 21 2022
2 comments
494 views