Difference between revisions of "Web Services Integration"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
Line 154: Line 154:
The trick is to capture the login-verification data returned in the first step as one or more [[Process Variables]], and use it in the subsequent step.
The trick is to capture the login-verification data returned in the first step as one or more [[Process Variables]], and use it in the subsequent step.


For example, to access the {{EnterpriseBrand}} [[REST API]]s, the login resource returns a JSession ID. The data structure returned by the login resource looks like this:
For example, to access the {{EnterpriseBrand}} [[REST API]]s, the login resource returns a JSession ID. The data structure returned by the login resource looks like this in XML:
:<tt><platform>
:<tt><platform>
:: <login>
:: <login>

Revision as of 02:58, 18 December 2013

About Web Services

A Web Service is basically a process that is standing by, waiting to do something for you once your program makes an internet connection and tells it what to do. The service might be to retrieve information or store it, perform a procedure on a remote server, take an order, or perform any other task that can be programmed.

A Web Service whose connections are specified using the Web Service Description Language (WSDL) can be integrated into the platform without programming, by performing a few configuration steps.

In addition, the interface defined by the WSDL can be simplified by the IT admin, so it more closely matches the application:

  • Ignore fields that are not needed
  • Hardcode data for fields whose values are fixed
  • Create more friendly names for the remaining fields defined in the WSDL
(For example, a web service that concatenates three fields ("field_1", "field_2", and "field_3") can be configured so that the designer sees it as a service which concatenates "first_name" and "last_name" to create "full_name", where "field_2" is hardcoded with a string that contains a single space.)

Those steps are covered below, under Configuring a Web Service.

Once done, an application designer can add a step in a Process to utilize the Web Service. The designer then uses the application-friendly names to:

  • Map current record fields to and from WSDL input and output fields
  • Specify fixed values or expressions for WSDL input fields
  • Define expressions that operate on WSDL output fields and store the results in the record

The mechanisms are discussed further below, under Working with a Web Service.

Managing Web Service Configurations

Setting Up a SOAP Web Service

Start by uploading the WSDL file:

  1. Download the WSDL file for the service the application will connect to.
    (Web Services managed by the WebMethods integration server are recommended.)
  2. Go to GearIcon.png > Developer Resources > Web Services
  3. Click [New Web Services Invocation]
    The Web Service tab is active, by default. That's the SOAP service option.
  4. Do one of the following to read the WSDL file:
    • Click [Select WSDL], browse to the folder that contains the file, and upload it, or
    • Enter a URL in the text box and click [Download]
  5. In the form that opens, configure the service connection:
    • Basic Parameters:
    • Title - Required. Give the service a title. (Displays in the Name column of the Services list.)
    • Operation - Required. Choose one of the operations defined in the WSDL file
    • Version - Required. Enter text to identify the service version
    • Service Parameters:
    • URL - Optional. Use this field to point to a destination other than one defined in the WSDL file
    • Username - Optional. Username required to use the service, when needed
    • Password - Optional. Password required to use the service, when needed
    • TTL - Optional. The "Time to Live", in milliseconds. (The amount of time the platform will wait before abandoning a service request.)
  6. Click [Next]

Setting Up a REST Web Service

  1. Go to GearIcon.png > Developer Resources > Web Services
  2. Click [New Web Services Invocation]
  3. Click the REST Service tab.
  4. Configure the service connection:
    • Header Parameters
      Specify a comma separated list of parameters that will be specified as inputs to the service.
      When the HTTP resource is accessed, those values are included in the request header, rather than in the request body.
      For example, to access an AgileApps Cloud platform REST API, the header needs to include a session cookie, and it can optionally specify the data format to return (XML or JSON), so the header variables would be: cookie,accept.
      __TBD: Are the terms case sensitive? Do I have the correct case here?__
    • Content Type
      Specify the type of content that will be sent to the service (XML or JSON).
      The same type of data should used when entering sample Request and Response data in the sections that follow.
      __TBD: I assume that this setting determines which parser is used to process the samples. Is that true?__
    • URL
      Specify the URL for the REST resource.
      Note: For a service that requires an initial login, you'll need to set up two services: One for the login resource, and one for the data resource you intend to access.
    • HTTP Method
      Specify the HTTP request type: GET, POST, PUT, or DELETE.
      By convention, GET fetches data, POST adds data, PUT replaces data, and DELETE removes it.
    • Request
      Provide an XML or JSON structure that exemplifies the one the service expects you to send.
      The entries defined in the structure become the data-configuration parameters for inputs to the service.
    • Response
      Provide an XML or JSON structure that exemplifies the one your receive.
      The entries defined in the structure become the data-configuration parameters for outputs from the service.
  5. Click [Process REST]
    The samples you entered are processed to create the configuration screens for data interchange.

Configuring the Data Interchange Parameters

In this part of the setup process, you can simplify the service's data parameters for process designers.

Start by mapping input fields (fields going to the service):

  1. In the hierarchy of fields that appears, click the [-] icon to collapse a section, click [+] to expand it.
  2. For each input field, choose one of:
    • Ask for Mapping -
    • Friendly Name - Give the WSDL field a name the application designer will recognize
    • Ignore - Ignore this value
    • Hardcode - Provided a hardcoded value for the field. (The application will never even see it.)
    • Username - Supply the Username value defined in the initial configuration step ($username).
    • Password - Supply the Password value defined in the initial configuration step ($password).
  3. Click [Next]

Then map output fields (fields coming from the service):

  1. In the hierarchy of fields that appears, click the [-] icon to collapse a section, click [+] to expand it.
  2. For each output field, choose one of:
    • Ask for Mapping - Ask the designer to supply the name of a record field to store the value into.
    • Friendly Name - Give the WSDL field a name the application designer will recognize
    • Ignore - Ignore this value
  3. Click [Save]

The Web Service is now ready for use by an application designer.

Viewing and Modifying a Configuration

  1. Go to GearIcon.png > Developer Resources > Web Services
  2. Click the Service name
  3. Click [Details]
  4. Follow the steps described in the previous section to view the configuration and make changes.

Adding a New Version

  1. Go to GearIcon.png > Developer Resources > Web Services
  2. Click the Service name
  3. Click [Add New Version]
  4. Follow the steps described earlier to add another version of the service.
    (Be sure to provide a value in the Version field.)

Testing a Service

  1. Go to GearIcon.png > Developer Resources > Web Services
  2. Click the Service name
  3. Click [Test Service]
  4. Provide input values.
  5. Click [Execute]
  6. Output values are displayed

Working with Web Services

Invoking a Web Service in a Process

Once a Web Service has been configured, you can add it as a step in a Process:

  1. Go to GearIcon.png > Objects > {object} > Processes
  2. Create a new process, or select an existing one and click the flow diagram to edit it.
    The process model editor opens.
  3. From the palette, drag the element to Execute Web Service into the model
  4. Fill in the parameters for this process step:
    • Name - Give the step a name
    • Web Service - Select one of the Web Services configured for the application
      If the service has a version identifier, it is displayed following the service name
      For example: Some Service [Version 2]
    • Input Mapping - For each field that goes to the service, choose one of the following, and then choose the WSDL field that the value goes into, from the list of friendly names defined in the Web Service configuration:
    • Use Object Field - Select a field from the current record
    • Use Fixed Value - Define a fixed value
    • Use Expression - Create an expression based on record fields. When the dialog opens:
      • Click Field to select a field in the record, or in a record referenced by a Lookup
      • Click the dropdown to select an operator
      • Click Function to select a Function
      • Click in the text area to enter a value
      • Click [Insert] to insert the result into the mapping field
    • Output Mapping - For each field that comes from the service, choose one of the following, and then choose the record field to store the value in:
    • Use WSDL Field - Select a WSDL output field from the list of friendly names defined in the Web Service configuration.
    • Use Expression - Create an expression based on WSDL fields. When the dialog opens:
      • Click Field to select a WSDL field
      • Click the dropdown to select an operator
      • Click Function to select a Function
      • Click in the text area to enter a value
      • Click [Insert] to insert the result into the mapping field
  5. Click [Save]
    When the process reaches this step, the Web Service is automatically invoked, and the specified data interchange occurs.

Logging In to a Web Service

Some Web Services require a separate log-in step before resources can be accessed. That behavior is typical of REST services, and applies to some SOAP services, as well.

For such services, create a two-step process:

  • The first step invokes the service's log-in resource
  • The second step invokes the data-interchange resource

The trick is to capture the login-verification data returned in the first step as one or more Process Variables, and use it in the subsequent step.

For example, to access the AgileApps Cloud platform REST APIs, the login resource returns a JSession ID. The data structure returned by the login resource looks like this in XML:

<platform>
<login>
<jsessionID>...

So the path to that value in the data structure is platform.login.jsessionID Here, an expression is created using that value, in the form it will be needed next:

RESTwebServiceLoginStep.png

Here, the expression created in the login step is included in the cookie parameter, when accessing a data resource:

RESTwebServiceDataAccessStep.png

Invoking a Web Service From a Rule

  1. Create a Process that invokes the web service, like the one shown here:
    WebServiceProcessModel.png
    (If needed, add an initial step that invokes the service in order to log in.)
  2. Create a Process that uses the Process Model.
  3. Launch the Process from a Rule

Invoking a Web Service using an API

  1. Create a Process that invokes the web service, like the one shown above.
    (If needed, add an initial step that invokes the service in order to log in.)
  2. Create a Process that uses the Process Model.
  3. Create an Event Rule that launches the process.
  4. In the code that is using the REST or Java API, trigger the event to launch the process.