Objective

To demonstrate the ability of a Fiorano REST application to interact with an end user by exposing a secured REST service which accepts HTTP DELETE requests at a URL and responds with a count of records deleted from the database successfully.

Prerequisites

• Start the Fiorano Enterprise Server (FES) and the Fiorano Peer Server (FPS)
• Login to the eStudio application
  • Get familiar with the basic menus and perspectives (panels) in eStudio application
• Add DB jars (ojdbc.jar) to the System Library by following the steps mentioned in Adding Resources to a Microservice. This is for the DB component to work seamlessly.

Scenario

• Configure the RESTStub component to receive HTTP DELETE requests from RESTConsumer and process it as query configured in a DB component. Bind the DB schema to the RESTStub and transform the routes between the RESTStub and the DB.

• Configure the RESTConsumer component to send HTTP DELETE requests triggered using a Feeder component which adapts to the RESTConsumer schema.

How it Works

The REST service gets deployed in the peer server and when a rest client sends a request to the service, the request is available on the output port. The response can be routed back by connecting a route to the input port.

Components used

• RESTStub
• RESTConsumer
• DB
• Feeder
• Display

Setting up the Example

Configuring Server Event Process

Create an Event Process with the name 'REST-DELETE_Server' to configure a server application with a DB component to raise a query. 

Configuring DB component

Use the DB component to store data and return the result for the Insert Query statement.

To configure the DB component, perform the actions below in the REST-DELETE_Server event process:

1. Under the DB category in the Microservice Palette, drag the DB component to the Fiorano Orchestrator.
   
    
   
   

2. Double-click the component to open the Configuration Property Sheet (CPS). 

3. In the Managed Connection Factory panel, click the Database Configuration ellipsis button to configure the DB Connection. Provide the credentials for the DB from which the table needs to be accessed.

   Icon

   Refer to the Database Configuration section for more information about the properties that need to be configured.

    
    

4. Click OK and click the Test button present in the Managed Connection Factory panel to confirm a successful connection with the message "Connection created successfully". Click Next to move to the Interaction Configurations panel.
   
   

   Icon

   Ensure that DB jars are added to the System Library as instructed in the Prerequisites section above. If not added, there may be issues with the connection.

5. In the Interaction Configurations panel, click SQL Configuration ellipsis button to configure Insert SQL statement with the Query Name: insert.

   Icon

   Refer to the Simple Insert Statement section to insert values to a table.

   
   
   
   

6. Click Finish to complete SQL Configuration.
   
   
   
   

7. Click Finish in the Interaction Configurations panel to complete the DB Configuration.

Configuring RESTStub component

The RESTStub component exposes Restful services in the Fiorano environment. To configure the RESTstub component, perform the actions below in the eStudio application:

1. In the REST-DELETE_Server event process, drag the RESTStub component from the Web category in the Microservice palette to the Fiorano Orchestrator.
   
   
    

2. Double-click the component to open the Configuration Property Sheet (CPS).

   Icon

   Notice that the RESTStub component does not have any ports attached to it; ports appear only after configuration.

3. The first screen in the CPS, wizard (1 of 3), is used to define the service using a user interface for WADL. WADL can be created manually by defining different aspects of the service or can load an existing WADL and edit the configurations.
   Provide Service Name as 'Sample' with which the event process functionality is exposed as RESTful service.
   
   
4. Under the Create/Edit WADL section, perform the actions below:
   
   

   1. Bind the DB input port and output port schemas to the RESTStub

      1. Click Schemas under the Configuration tab.

         Icon

         Port Schemas appear only if the DB component is configured correctly.

      2. In the Schemas Configuration section, click the Add  button and click Load from Port Schemas option

      3. In the Select Port dialog box that is displayed, select 'IN_PORT'.
         
         
         
         

      4. Similarly, select the OUT_PORT too and click OK. Both schemas get added under the Schemas section.
         
         

   2. Add DELETE method

      1. Right-click the GET node and select the Remove Method option to remove the default method.
         
         
         
         

      2. Right-click resource under the Rresources node, go to Add Method and select DELETE option to add the DELETE method.
         
         
          

   3. Rename resource path to give logical meaning to the scenario

      1. Click the resource node. 

      2. Under the Resource Configuration tab, replace the default value of Path 'resourcePath' with 'deleteData'.
         

         
         
         

   4. Add the request SQL element to the DELETE node

      1. Click the DELETE node.

      2. Click the Add  button under the Request Configuration tab.

      3. Click the ellipsis  button under the Representation tab.

      4. In the Select Element window displayed, select "SQL_CFG_1" under Request element and click OK.
         
         
         
         

   5. Add the response SQL element to DELETE node

      1. Right-click the DELETE node and click the Add Response option. The Response node is displayed.

      2. Click the Response node

      3. Click the Add  button under the Response Configuration tab.

      4. Click the ellipsis  button under the Representation tab.

      5. In the Select Element window, select "SQL_CFG_1" under the Response element and click OK.
         
         

Configuring Transformation

Connecting Ports Creating Routes

Connect the ports of the RESTStub and DB components in the following manner:

• Output Port of RESTStub component to the Input Port of DB component.
• Output Port of DB component to the Input Port of RESTStub component.

Route Transformation

To configure transformation between input and output ports of the RESTStub and the DB, perform the actions below in the Fiorano Orchestrator:

1. Right-click route1, point to Configure Transformation and select the Mapper Project option to open the Fiorano Mapper editor.
   
   
    
2. In the Mapper Project, connect values in Input Structures and Output Structures as below:
   1. de to ZERO MANY
   2. eid
      
      
   
    
3. Click the Save icon (or File > Save) to save the transformation configuration and close the Mapper Project editor.
   
   
4. Similarly, for route2, go to the Mapper Project window and connect "UpdateCount".
   
   
   
   

5. Save the mapping configuration as explained in step 3.

   Icon

   Now the dotted lines in the route are transformed to bold lines implying that the route transformation has been done.

   

Launching the Server Event Process

WADL URL has to be copied from the RESTStub component to use in the RESTConsumer component added in later steps. Perform the actions below in the Fiorano Orchestrator:

1. Click the Check Resource and Connectivity (CRC)  icon (or press ALT+SHIFT+C) to check resources and connectivity.

   Icon

   Ensure that the security configurations completed in the Profile Management and the RESTStub are in sync with the corresponding configurations for SSL Security or Basic Authentication. Errors may occur while checking resource and connectivity (CRC if these are not configured correctly.
2. Click the Run Event Process  icon (ALT+SHIFT+R) to run the event process.

3. Right-click the RESTStub component and click the Copy WADL URL option to copy the WADL URL.
   
   

Configuring Client Event Process

Create another Event Process with the name REST-DELETE_Client to configure a client event application with a Feeder and Display.

Configuring RESTConsumer

The RESTConsumer component serves as a client to access exposed services within the Fiorano Environment. To configure the RESTConsumer component and communicate with the RESTStub which has an exposed RESTservice, perform the actions below in the REST-DELETE_Client application:

1. Add the RESTConsumer component from Web category in Microservice Palette to the Fiorano Orchestrator.
   
   
    
2. Double-click the component to open the Configuration Property Sheet (CPS).
   
   
   
   
3. Perform the actions below in the wizard (1 of 3) panel:
   1. Enable the Load WADL option. The From URL option gets active/editable.
   2. Select the From URL option and paste the WADL URL copied from RESTStub onto it.

   3. Click the Load WADL button to apply the RESTStub schemas. The schemas get populated as shown below.
       

   

Click Next till the last panel where the Finish button will be enabled and click Finish to close the CPS and to save the configuration. The input and output ports get generated.

Configuring Feeder

1. Add Feeder and Display components from the Util category in the Microservice Palette into the REST-DELETE_Client orchestrator.
2. Connect the ports of the RESTConsumer to the Feeder and Display components in the following manner:
   1. Output Port of the Feeder component to the Input Port of the RESTConsumer component.
   2. Output Port of the RESTConsumer component to the Input Port of the Display component.
       
   
   
   
3. Double-click the Feeder component and click the Connected Port Schemas button in the Message Type Configuration panel. Select the last child node ('resource_DELETE_Request' in this example) in the Connected ports window to import the RESTConsumer schema into the feeder and click OK.
   
   
   
   
4. The Select Root Element text box and the schema editor get populated with the RESTConsumer schema. Click Next.
   
   
   
   
5. In the Message Details Configuration panel, click Generate Sample to open the XSD Sample Generation Dialog box and click OK.
   
   
   
   
6. Click the Finish or Save and Close button to complete the Feeder configuration.

Running the Example

To see the REST-DELETE_Client Event Process running in conjunction with REST-DELETE_Server Event Process, perform the actions below in the REST-DELETE_Client Event Process:

1. Click the Check Resource and Connectivity  icon (or press ALT+SHIFT+C) to check the resource and connectivity.
2. Click the Run Event Process  icon (ALT+SHIFT+R) to run the event process. The Feeder and Display windows get opened.

3. Provide the required column values (in this example, eid: 101) in the Feeder window and click Send.
   
   

    Expand for sample input

   

   Icon

   This changes the name inserted using RESTPOST.

   
   

4. If the DELETE query is successful, 'UpdateCount' shows "1" in the Display window.
   
    
   
   

   Icon

   In order to verify, GET method can be used in DB before and after the deletion of data.

   GET method to retrieve existing data in the DB table

   Click Execute in the DB Test Interation Specifications Panel; it shows as an empty screen as the lone data in the DB is removed.

   
   

Reference

• Download REST DELETE Client and Server Example event processes and import it to the Event Process Repository in the Server Explorer within eStudio to understand the configuration used in this example and to execute the working sample.
• Please note that the component options used in this example are basic to have an overview of the application. To explore other options present in the RESTStub and the RESTConsumer components, refer to the sections: RESTStub and RESTConsumer.