Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Summary

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

Content

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/11.13.18.05/suppliers

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.

Register

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