This documentation supports the 20.02 version of Remedy Action Request (AR) System.

To view an earlier version, select the version from the Product version menu.


To create a filter with input and output mappings

The topic describes the procedures for creating a Set Fields filter with input and output mappings to get a purchase order and a line item record:

To create the filter

  1. Select File > New > Filter.
  2. Select the server on which you want to create the filter, and click Finish.
  3. Right-click the Associated Forms panel, and select Expand All Panels.
  4. In the Associated Forms panel, click the Add button (see the "Stock Quote filter — Associated Forms and Execution Options panels" figure (Consuming a simple flat document scenario)).
  5. In the Form Selector dialog box, select the Purchase Order Client form to use as the base form, and click OK.
  6. From the State list, select Enabled.
  7. In the Execution Order field, enter the execution order for the filter, or accept the default value.
  8. In the Execution Options panel, select Submit.

    Purchase Order Client filter — basic options
    (Click the image to expand it.)
  9. Right-click the If Actions panel, select Add Action, and select Set Fields.
    A new panel appears, where you configure the Set Fields action.
  10. From the Data Source list, select WEB SERVICE.
  11. From the Server Name list, select the server on which to store the web service mappings as a server object.
  12. In the WSDL field, enter the path or browse to your WSDL file.
    In this scenario, your URL might look like this:
    
    http://TestServer/arsys/WSDL/public/TestServer/Purchase Order Web Service
    You can also enter a path to a local WSDL file, for example:
    
    C:\Temp\Purchase Order Web Service.wsdl
  13. Click Reload.
  14. If prompted, enter the user name and password required by the remote web server for basic authentication.
  15. From the Port list, select the port for the web service.
  16. From the Operation list, select the getPurchaseOrder operation.
    The menu is automatically populated with the available operations for the web service.

    Purchase Order Client filter — Set Fields action
    (Click the image to expand it.)

To create the input mappings in the filter

  1. In the Input Mapping table, select the ROOT element in the XML Data Type column.
    Note that ROOT is already mapped to the Purchase Order Client.
  2. Click Primary Key in the Mapping Info column.
  3. Click the ellipsis button to open the Field Selector (see Primary Key selection).
  4. Select PO ID as your primary key, and click OK twice.
  5. Select the POID element in the XML Data Type column.
  6. Click the adjacent cell in the Forms/Field column, and click the ellipsis button.
  7. Select the PO ID field and click OK.
    Your input mapping should look similar to the one in Purchase Order Client filter — Set Fields action.
  8. Select File > Save, and name your filter Purchase Order Client Filter.

To create the output mappings in the filter

  1. Select the ROOT element in the XML Data Type column.
    Note that ROOT is already mapped to the Purchase Order Client form.
  2. Click Primary Key in the Mapping Info column.
  3. Click the ellipsis button to open the Field Selector (see Primary Key selection).
  4. Select PO ID as your primary key, and click OK twice.
  5. Map the fields from the Purchase Order Client form as follows, referring to Purchase Order Client filter — Set Fields action:

    XML elements and complex types

    Form and fields

    Primary Key field

    ROOT

    Purchase Order Client

    PO ID

    POID

    PO ID

    CompanyName

    Company Name

    Description

    Description

    PhoneNumber

    Phone Number

  6. Under the Items element in the XML Data Type column, select the Item element.
  7. In the Form/Field column, click the empty table cell next to the Item element.
  8. Click the ellipsis button, and select the Line Items Client form and click OK.
    The Item element is now mapped to the Line Items Client form, as shown in Purchase Order Client filter--Set Fields action.
  9. Click Distinguishing Key/Foreign Key in the Mapping Info column (see Distinguishing Key and Foreign Key selection).
  10. Click the ellipsis button adjacent to the Distinguishing Key field.
  11. Use the Field Selector to select the Item ID field, and click OK.

    Note

    The AR System server does not allow the mapping of an integer as the distinguishing key during the consumption of a web service.

  12. In the same manner, specify a Foreign Key value of Line Item PO ID.
  13. Click OK to confirm your key selections.
  14. Map the fields from the Line Items form as follows, referring to Mapping for the GetPurchaseOrder operation:

    XML elements and complex types

    Form and fields

    Distinguishing Key field

    Foreign Key field

    ROOT/Items/Item

    Line Items Client

    Item ID

    PO ID

    ItemName

    Item Name

    Quantity

    Quantity

    ItemID

    Item ID


    Your output mapping should look similar to the one in Purchase Order Client filter — Set Fields action.
  15. Save your changes to the filter.
Was this page helpful? Yes No Submitting... Thank you

Comments

  1. Kuldeep Nayak

    Hi when I click hyperlink : Purchase Order Client filter — Set Fields action.

    https://docs.bmc.com/docs/ars2002/to-create-your-forms-909638052.html#Tocreateyourforms-88693

    Sep 09, 2020 07:08
    1. Anagha Deshpande

      Hello Kuldeep,

      The link opens a topic that is given as an example for reference.

      Regards,

      Anagha

      Sep 16, 2020 12:00