You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

APEX - Creating page based on SaaS REST API. HTTP-400 Bad Request on update.

edited Apr 16, 2022 7:50AM in Autonomous Database


Created a page based on the SaaS Suppliers RESTful API. Retrieving row works fine, HTTP-400 when I try and update one


Hey folks

I'm trying to create an APEX page which lets me retrieve the suppliers using REST and then update one of them.


I've created a Web Source Module, URL Path Prefix is /fscmRestApi/resources/

Operations are GET and PATCH

GET is set to Database Action of Fetch Rows

PATCH is set to Database Action of Update row


I edit the PATCH operation so that the Request Body Template is 

  "supplierid":#SUPPLIERID#, "supplier":#SUPPLIER#

so it can only update 2 fields.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!