1. Developing Integrated Spreadsheets Using Oracle Visual Builder Add-in for Excel
  2. REST Service Support
  3. REST Operations

REST Operations

Table and Form-over-Table capabilities are enabled for GET, PUT, PATCH, POST, and DELETE operations as follows:

  • Download is enabled if there is a GET operation on the collection path. Note that you must first download rows before you can perform operations on the item path. Therefore, GET on the collection path is a prerequisite for operations on the item path such as PUT, PATCH, or DELETE.
  • Existing row updates are enabled if the item path has either a PUT or PATCH operation.

    Depending on your configuration, the add-in includes either all data values or just changed values in editable cells for the changed row(s) on upload. For information about how to send only changed values, see Send Only Changed Data During Upload.

  • Create new rows is enabled if the collection path has a POST operation.
  • Delete existing rows is enabled if the item path has a DELETE operation.

Note:

Even if the business object supports an operation, you can still choose to disable a layout's capability by deselecting it in the Layout Designer's Advanced tab.