Wso.WebService Lookup

With the WSO.Webservice Lookup control, you can dynamically lookup values and populate form fields with data from Winshuttle for Oracle server. The WSO.Webservice Lookup control calls an Oracle API to obtain values dynamically from Oracle EBS.

This control can be used in two modes: Field Lookup or Page Lookup.

  • Field Lookup enables you to look for the values for a field using Oracle server.
  • Page Lookup enables you to look for a record using Oracle server which can be consumed as input data for a web service on the form.

    Important Note: WSO.Webservice Lookup control should not be removed from your controls manually. If the control is removed you will need to reinstall Winshuttle Designer.

WSO.WebServiceLookup properties

Property

Description

Lookup Type

Specifies the type of lookup to be performed. 

It can have two values:

  • Field – lookup for a field
  • Page – lookup for a record

Mapping Name

This parameter is the name of the web service added in the workflow solution.

All the generic web services added in the workflow solution will be listed in the dropdown, where you can select the desired web service.

LOV Field

Specifies the web service field name of the field to be looked for.

It should be specified only when Lookup Type (see above) is set to Field.

Set Field

Specifies the form field to be set with the result of lookup.

It should be specified only when Lookup Type (see above) is set to Field.

Window Width

Specifies the width (in pixels) of the lookup window.

Window Height

Specifies the height (in pixels) of the lookup window.

Page Size

Specifies the number of records to display per page.


Note: The Winshuttle System Administrator can limit the number of records globally, which might reduce the maximum number records you return.

Configuring WSO.Webservice Lookup control for Webservice Field Lookup

Back to top

  1. In InfoPath, drag a WSO.Webservice Lookup control into the form.
  2. Open the Property Page for the WSO.Webservice Lookup control.
  3. Under Lookup, set Lookup Type to Field.
  4. Under Binding:
    • Mapping Name: Select a web service from the dropdown.
    • LOV Field: Select the field to be looked up from the dropdown.
    • Set Field: Enter the SetField textbox value.
  5. Under Appearance:
    • Window Width: Enter the Window Width Value (in pixels).
    • Window Height: Enter the Window Height Value (in pixels).
    • Page Size: Enter the number of results to display per page.
  6. Click Apply, and then click OK.

Configuring WSO.Webservice Lookup control for Webservice Page Lookup

Back to top

  1. In InfoPath, drag a WSO.Webservice Lookup control into the form.
  2. Open the Property Page for the WSO.Webservice Lookup control.
  3. Under Lookup, set Lookup Type to Page.
  4. Under Binding:
    • Mapping Name: Select a web service from the dropdown.
  5. Under Appearance:
    • Window Width: Enter the Window Width Value (in pixels).
    • Window Height: Enter the Window Height Value (in pixels).
    • Page Size: Enter the number of results to display per page.
  6. Click Apply, and then click OK.

WSO.WebService Lookup example

Back to top

The following is a basic example of how this control might be used in a form in conjunction with Winshuttle Workflow server. In this example, the requester filling out the form uses a search integrated in the form to search for Suppliers, and then select one from the returned results. The selected supplier and related information is then automatically added to the form.

WSO.WebService Lookup example

  1. The user fills in their credentials (EBSUsername, EBSPassword, and Responsibility fields)
  2. The user clicks the Find button to search for suppliers, which opens a window that displays search input fields. Mandatory fields are marked with an asterisk (*).
  3. The user enters search data (Supplier Name, Supplier Number, Address, etc.), and then clicks Search. Results are displayed below the table.
  4. The user clicks Select to select the desired Supplier from the search results.
  5. The selected Supplier and related information (address, etc.) is automatically added to the form and fills in related information for the user.