Method of deriving web service interfaces from form and table metadata

• US 9,158,557 B2
• Filed: 07/01/2013
• Issued: 10/13/2015
• Est. Priority Date: 04/27/2007
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Inventors: Rafnsson, Rognvaldur Kristinn
• Primary Examiner(s): DAO, TUAN C.
• Application Number:
  US13/932,501
• Publication Number:
  US 20130298142A1
• Time in Patent Office: 834 Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/95 Retrieval from the web
• CPC Class Codes: G06F 40/174 Form filling; Merging
• CPC Class Codes: G06F 9/451 Execution arrangements for user interfaces

Abstract

A system and method of deriving web service interfaces from form and table metadata is disclosed. The method uses a discovery subsystem to discover services that are available on an application server, retrieves the metadata descriptions of the services on the application server and uses the services discovered and the metadata descriptions to create web services interfaces such that the service is available using web services description language.

Claims

1. A computer-implemented method of calling a web service interface, the method comprising:

deriving, by a computing device, the web service interface from a user interface form, the web service interface making an application on an application server available using web services description language; and

sending, by a computing device, a service request via the web service interface to the available application, the web service interface defining

a web service field, the web service field derived from user interface form metadata, the user interface form metadata specifying a field within a database table shown on the user interface form, and

a web service method, the web service method related to an operation of the user interface form.

2. The computer-implemented method of claim 1, wherein the web service interface further defines a second web service method for inserting a record into a database table.

3. The computer-implemented method of claim 2, wherein the web service interface further defines a third web service method for updating the record.

4. The computer-implemented method of claim 3, wherein the web service interface further defines a fourth web service method for deleting the record.

5. The computer-implemented method of claim 1, wherein the web service method is related to at least one of finding, updating, or retrieving data from the database table.

6. The computer-implemented method of claim 1, wherein the web service interface is based on a Simple Object Access Protocol (SOAP).

7. The computer-implemented method of claim 1, wherein the web service interface is registered in another database table.

8. The computer-implemented method of claim 1, wherein the user interface form defines an external view of an entity.

9. The computer-implemented method of claim 8, wherein the entity relates to one of a customer or an order.

10. One of an optical disk, a magnetic storage device or a solid state storage device having computer executable code thereon which, when executed by a computer, causes a computer to:

derive a web service interface from a user interface form, the web service interface making an application on an application server available using web services description language; and

send a request via a web service interface to the available application, the web service interface defining

a web service field, the web service field derived from user interface form metadata, the user interface form metadata specifying a field within a database table shown on the user interface form, and

a web service method, the web service method related to an operation of the user interface form.

11. The optical disk, magnetic storage device or solid state storage device of claim 10, wherein the web service interface further defines a second web service method for inserting a record into a database table.

12. The optical disk, magnetic storage device or solid state storage device of claim 11, wherein the web service interface further defines a third web service method for updating the record.

13. The optical disk, magnetic storage device or solid state storage device of claim 12, wherein the web service interface further defines a fourth web service method for deleting the record.

14. The optical disk, magnetic storage device or solid state storage device of claim 10, wherein the web service method is related to at least one of finding, updating, or retrieving data from the database table.

15. The optical disk, magnetic storage device or solid state storage device claim 10, wherein the web service interface is based on a Simple Object Access Protocol (SOAP).

16. The optical disk, magnetic storage device or solid state storage device of claim 10, wherein the web service interface is registered in another database table.

17. The optical disk, magnetic storage device or solid state storage device of claim 10, wherein the user interface form defines an external view of an entity.

18. The optical disk, magnetic storage device or solid state storage device of claim 17, wherein the entity relates to one of a customer or an order.

19. A computer system comprising a processor for executing computer executable code and a memory for storing the computer executable code, the computer executable code comprising code for calling a web service interface, wherein the computer code further comprises code for:

deriving, by a computing device, the web service interface from form and table metadata, the web service interface making an application on an application server available using web services description language; and

sending, by a computing device, a request via the web service interface to the available application, the web service interface defining

a web service field, the web service field derived from user interface form metadata, the user interface form metadata specifying a field within a database table shown on the user interface form, and

a web service method, the web service method related to an operation of the user interface form.

20. The computer system according to claim 19, wherein the web service interface further defines:

a second web service method for inserting a record into a database table;

a third web service method for updating the record; and

a fourth web service method for deleting the record.