1. Developing Integrated Spreadsheets Using Oracle Visual Builder Add-in for Excel
  2. Use Multiple Layouts for Multi-level Business Objects
  3. Requirements for Dependent Layouts

Requirements for Dependent Layouts

To ensure that your dependent layouts function without error, Oracle Visual Builder Add-in for Excel requires that the REST service complies with the requirements set out here.

URL Path Requirements

To ensure all operations of dependent layouts can be done without errors, the add-in requires the following:

  • Parent business object:
    • Collection path: /{parentResource}
    • Item path: /{parentResource}/{parentResource_Id}
  • Child business object
    • Collection path: /{parentResource}/{parentResource_Id}/{childResource}
    • Item path: /{parentResource}/{parentResource_Id}/{childResource}/{childResource_Id}
  • Grandchild business object
    • Collection path: /{parentResource}/{parentResource_Id}/{childResource}/{childResource_Id}/{grandchildResource}
    • Item path: /{parentResource}/{parentResource_Id}/{childResource}/{childResource_Id}/{grandchildResource}/{grandchildResource_Id}

This example shows the collection and item paths for the parent, child, and grandchild business objects in the following three-level hierarchy:
Three-level business object hierarchy, showing PurchaseOrders as the parent, lines as the child, and schedules as the grandchild

Parent paths:

  • Collection path: /PurchaseOrders
  • Item path: /PurchaseOrders/{PurchaseOrders_Id}

Child paths:

  • Collection path: /PurchaseOrders/{PurchaseOrders_Id}/lines
  • Item path: /PurchaseOrders/{PurchaseOrders_Id}/lines/{lines_Id}

Grandchild paths:

  • Collection path: /PurchaseOrders/{PurchaseOrders_Id}/lines/{lines_Id}/schedules
  • Item path: /PurchaseOrders/{PurchaseOrders_Id}/lines/{lines_Id}/schedules/{schedules_Id}

GET and POST Response Requirements

GET and POST responses must contain self links that uniquely identify a record. For example:

"links": [
        {
          "rel": "self",
          "href": "http://localhost:8888/ords/hr_rest/ExpenseReports/15001"
        }
 ]

Notes on Oracle REST Data Services Support