Method of deriving web service interfaces from form and table metadata

• US 8,484,663 B2
• Filed: 04/27/2007
• Issued: 07/09/2013
• Est. Priority Date: 04/27/2007
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Rafnsson, Rognvaldur Kristinn
• Primary Examiner(s): DAO, TUAN C.
• Application Number:
  US11/741,318
• Publication Number:
  US 20080271047A1
• Time in Patent Office: 2,265 Days
• Field of Search: None
• US Class Current: 719/320
• 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 method of deriving web service interfaces from form and table metadata comprising:

receiving from a service client at a discovery subsystem a first request for services that are available on an application server;

responding to the first request with a web service entry corresponding to a form registered in a database table as a service, wherein the form defines

a user interface of an application,

an external view of an entity,

which fields are visible in the external view of the entity,

whether the external view of the entity allows one of a read, a modify, an insert and a delete function to be operated on the entity, and

whether particular fields in the external view of the entity are one of read-only or editable;

receiving from the service client a second request for a description of the service;

retrieving form metadata regarding the form on the application server;

determining from the form metadata what fields from what tables are shown on the form;

retrieving table metadata regarding properties of the fields, wherein each of the fields shown on the form appears as a field in the XML type using a name and type of the field from the table metadata; and

using the form metadata and the table metadata to respond to the second request with a description of the service in the Web Services Definition Language (WSDL) format.

2. The method of claim 1, wherein the second request comprises a WSDL request.

3. The method of claim 1, further comprising receiving the first request and the second request at the application server using the Hypertext Transport Protocol (HTTP) and receiving simple object access protocol (SOAP) requests for service interactions including insert and update.

4. The method of claim 1 wherein the web service entry is in a web service discovery tool format known as DISCO format.

5. The method of claim 1 wherein abstractions intended to be web accessible as a web-service are registered in the database table.

6. The method of claim 5, wherein the discovery subsystem is populated from the database table.

7. The method of claim 1, wherein the web service entry in the response contains a Uniform Resource Locator (URL) pointing to a WSDL description of the service.

8. The method of claim 1, wherein an XML type is built from the form metadata and the table metadata and a name of the service.

9. A computer readable storage medium comprising computer executable code for deriving web service interfaces from form and table metadata, wherein the computer code further comprises code for:

receiving from a service client at a discovery subsystem a first request for services that are available on an application server;

responding to the first request with a web service entry corresponding to a form registered in a database table as a service, wherein the form defines

a user interface of an application,

an external view of an entity,

which fields are visible in the external view of the entity,

whether the external of the entity allows one of a read, a modify, an insert and a delete function to be operated on the entity, and

whether particular fields in the external view of the entity are one of read-only or editable;

receiving from the service client a Web Service Description Language (WSDL) request for a description of the service;

retrieving form metadata regarding the form on the application server;

determining from the form metadata what fields from what tables are shown on the form;

retrieving table metadata regarding properties of the fields; and

using the form metadata and the table metadata to respond to the WSDL request with a description of the service in the WSDL format.

10. The computer readable medium of claim 9, wherein abstractions intended to be web accessible as a web-service are registered in the database table and wherein the discovery subsystem is populated from the database table.

11. The computer readable medium of claim 9, wherein the web service entry in the response contains a Uniform Resource Locator (URL) pointing to a WSDL description of the service.

12. A computer system comprising a processor for executing computer executable code, a memory for storing computer executable code and an input/output circuit, the computer executable code further comprising code for deriving web service interfaces from form and table metadata, wherein the computer code further comprises code for:

receiving from a service client at a discovery subsystem a first request for services that are available on an application server;

responding to the first request with a web service entry corresponding to a form registered in a database table as a service, wherein the form defines

a user interface of an application,

an external view of an entity,

which fields are visible in the external view of the entity,

whether the external view of the entity allows one of a read, a modify, an insert and a delete function to be operated on the entity, and

whether particular fields in the external view of the entity are one of read-only or editable;

receiving from the service client a Web Service Description Language (WSDL) request for a description of the service;

retrieving form metadata regarding the form on the application server;

determining from the form metadata what fields from what tables are shown on the form;

retrieving table metadata regarding properties of the fields;

building an XML type comprising a name of the service and a field corresponding to each of the fields shown on the form using a name and type of the field from the table metadata; and

responding to the WSDL request with a description of the service in the WSDL format comprising the XML type.