Oracle Corporation
ORCHESTRATION OF CRUD OPERATIONS FOR A HIERARCHICAL WEB SERVICE DATA MODEL IN A SPREADSHEET

Abstract:

Example embodiments facilitate orchestrating changes of data made (and/or actions specified for execution) in a client-side program with changes of corresponding data made in one or more server-side data objects. An example method includes structuring one or more worksheet relationships between one or more worksheets of a client-side spreadsheet in accordance with one or more data object relationships of one or more data objects of a server-side data structure; determining that one or more operations have been selected for performing on data of one or more of the worksheets; detecting user input operative to initiate performance of the one or more operations; and initiating implementation of the one or more operations (e.g., CRUD (Create, Read, Update, Delete) operations) in accordance with the one or more worksheet relationships and the one or more data object relationships (e.g., hierarchical relationships). A spreadsheet add-in may issue request messages to web services tasked with completing the one or more operations.