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!

Apex 21.1: REST API: POST Handler for array in JSON

SmithJohn45Apr 4 2022

here is a requirement for a Mobile app to create a POST Handler in a REST API for data which is in JSON format but in array, during my search found https://www.thatjeffsmith.com/archive/2018/12/executing-pl-sql-with-array-inputs-via-ords/ its using example for very simple data and data which i will receive is in below format, please help to write a POST Handler to insert data in below format.

[
userid: 2,
order_note:"that the quick brown...",
items: {
{"OrderText": "OrdText", "PickupLoc": "PickLoc", "DropOffLoc": "DropOff"},
{"OrderText": "OrdText", "PickupLoc": "PickLoc", "DropOffLoc": "DropOff"},
{"OrderText": "OrdText", "PickupLoc": "PickLoc", "DropOffLoc": "DropOff"}
}
]

regards

This post has been answered by InoL on Apr 4 2022
Jump to Answer
Comments
Post Details
Added on Apr 4 2022
4 comments
2,889 views