/
Invoking Multiple Operations via Request Box
com.atlassian.confluence.content.render.xhtml.migration.exceptions.UnknownMacroMigrationException: The macro 'next_previous_links' is unknown.

Invoking Multiple Operations via Request Box

Jun 09, 2019

In this tutorial, you define a data service that can invoke request box operations. The request box feature allows you to invoke multiple operations (consecutively) to a datasource using a single operation.

Setting up a datasource

Follow the steps given below to set up a MySQL database for this tutorial.

  1. Download the product installer from here, and run the installer.

  2. Install the MySQL server.

  3. Download the JDBC driver for MySQL and copy it to your <EI_HOME>/lib directory.

  4. Create a database named Company.

    CREATE DATABASE Company;

  5. Create the Employees  table:

    USE Company; CREATE TABLE `Employees` (`EmployeeNumber` int(11) NOT NULL, `FirstName` varchar(255) NOT NULL, `LastName` varchar(255) DEFAULT NULL, `Email` varchar(255) DEFAULT NULL, `JobTitle` varchar(255) DEFAULT NULL, `OfficeCode` int(11) NOT NULL, PRIMARY KEY (`EmployeeNumber`,`OfficeCode`));

Define a data service to invoke request box operations

Let's create a data service using the Create Data Service wizard:

  1. Start the WSO2 ESB profile.

  2. Open the ESB profile's Management Console using https://localhost:9443/carbon, and log in using admin as the username and the password.

  3. Click Create under Data Service.

  4. Add a name for the data service.

  5. Select the Enable Boxcarring check box.
    As a result of selecting this check box, the Disable Legacy Boxcarring Mode check box will appear on your screen as shown below. Select this new check box (Disable Legacy Boxcarring Mode) as well.

  6. Click Next and then click Add New Datasource.

  7. Connect to the Company database that you defined above.

  8. Click Save and then click Next to go to the Queries screen.

  9. Click Add New Query to specify the query details:

    1. Enter addEmployeeQuery as the query ID.

    2. Enter the following SQL dialect:

      insert into Employees (EmployeeNumber, FirstName, LastName, Email,OfficeCode) values(:EmployeeNumber,:FirstName,:LastName,:Email,:OfficeCode)

    3. Click Generate Input Mapping and input mappings are generated automatically.

    4. Click Save.

  10. Click Add New Query to Create another query for the Company datasource:

    1. Enter selectEmployeebyIDQuery as the query ID.

    2. Enter the following SQL dialect:

      select EmployeeNumber, FirstName, LastName, Email, OfficeCode from Employees where EmployeeNumber=:EmployeeNumber

    3. Generate input and output mappings:

      1. Click Generate Input Mapping and input mappings are generated automatically for the employee number.

      2. Click Generate Response to automatically generate the output mappings for the fields in the Employees table.

    4. Click Save.

  11. Click Next and then click Add New Operation.

  12. Create two operations to add and select employees.

    1. Enter the following details to create the addEmployeeOp operation that adds new employees to the database.

    2. Save the operation.

    3. Click Add New Operation and enter the details as shown below to create the selectEmployeeOp operation that gets the details of an employee from the database.

    4. Click Save.

  13. Click Finish.

Invoking the data service 

The Deployed Services window allows you to manage data services. You can try the data service you created by using the TryIt tool in this screen, which is in your product by default.  

  1. In the Deployed Services screen, click Try this Service to open the data service you just created from the TryIt tool.
    You will find that there is an additional request_box operation.

  2. Select the request_box operation and enter the following values:

    • Enter values for the addEmployeeQuery query.

    • Enter the same employee number you used for the above query in the selectEmployeebyID query:

    Copy the following, paste it in the TryIt tool, and click Send to try it out:

    <body> <p:request_box xmlns:p="http://ws.wso2.org/dataservice"> <!--Exactly 1 occurrence--> <addEmployeeOp xmlns="http://ws.wso2.org/dataservice"> <!--Exactly 1 occurrence--> <xs:EmployeeNumber xmlns:xs="http://ws.wso2.org/dataservice">1003</xs:EmployeeNumber> <!--Exactly 1 occurrence--> <xs:FirstName xmlns:xs="http://ws.wso2.org/dataservice">Chris</xs:FirstName> <!--Exactly 1 occurrence--> <xs:LastName xmlns:xs="http://ws.wso2.org/dataservice">Sam</xs:LastName> <!--Exactly 1 occurrence--> <xs:Email xmlns:xs="http://ws.wso2.org/dataservice">chris@sam.com</xs:Email> <!--Exactly 1 occurrence--> <xs:OfficeCode xmlns:xs="http://ws.wso2.org/dataservice">1</xs:OfficeCode> </addEmployeeOp> <!--Exactly 1 occurrence--> <selectEmployeeOp xmlns="http://ws.wso2.org/dataservice"> <!--Exactly 1 occurrence--> <xs:EmployeeNumber xmlns:xs="http://ws.wso2.org/dataservice">1003</xs:EmployeeNumber> </selectEmployeeOp> </p:request_box> </body>

    You get the following response:

    <axis2ns26:DATA_SERVICE_REQUEST_BOX_RESPONSE xmlns:axis2ns26="http://ws.wso2.org/dataservice"> <Entries xmlns="http://ws.wso2.org/dataservice"> <Entry> <EmployeeNumber>1003</EmployeeNumber> <FirstName>Chris</FirstName> <LastName>Sam</LastName> <Email>chris@sam.com</Email> <OfficeCode>1</OfficeCode> </Entry> </Entries> </axis2ns26:DATA_SERVICE_REQUEST_BOX_RESPONSE>
com.atlassian.confluence.content.render.xhtml.migration.exceptions.UnknownMacroMigrationException: The macro 'next_previous_links2' is unknown.