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!

Can a REST Service be created for multiple tables?

user_2077894Dec 7 2023 — edited Dec 7 2023

I was wondering if a REST service can be created for multiple tables. For example, I have 2 tables - PROJECTS and PROJECT_BIDS. Could a REST service be created that is expecting a JSON payload that looks something like this:

{"PROJECT":"Project1",
 "PROJECT_BID":[{"PROJECT":"Project1",
                 "BID":"Bid1"
                },
                {"PROJECT":"Project1",
                 "BID":"Bid2"
                }
               ]
}

Is it possible to create a REST service that would MERGE the data directly into the 2 tables, in case the data already exists in the tables? I hope this makes sense.

Thanks,

Dan

This post has been answered by thatJeffSmith-Oracle on Dec 11 2023
Jump to Answer
Comments
Post Details
Added on Dec 7 2023
1 comment
379 views