REST - Service Implementation in BW 6.x

In TIBCO BW5, REST & JSON Plugin is needed for implementing REST service. 

Whereas in BW6, TIBCO has provided direct support for REST service implementation. So, you can design and implement REST based services without need of any external plugins. 

Here, I am going to explain step by step approach on REST Service Implementation and Testing.

Here, I used GET, POST and Delete HTTP methods.
GET - To retrieve employee details
POST - To create new employee on DB
Delete - To delete employee details from DB

First, create a simple business process and add BusinessWorks REST Resource as shown below

Enter Resource Name and Resource Service Path (will be used from SOAP UI or PostMan) and specify HTTP methods GET, POST..etc. Click on on Next

Based on HTTP methods, you will see the tabs- POST, GET and DELETE

For POST, enter Request and Response alias names and specify data types. Here, I used XSD schema for Request and Response.

Click on Create New Schema. 

Note: If you have created XML schema already for request and response, you can use it directly. Otherwise, create it.

Create Request / Response and corresponding fields with data types (as per your backend system)

Likewise, create similar Request / Response for GET, DELETE and then click OK (final).

Then, you can see the below Skelton without any implemention. 

Create HTTP Connection

Create JDBC Connection

Place JDBCUpdate Activity on POST scope and specify parameters for Statement and Inputs.

And, do similar exercise for GET and DELETE.

Add, queryParameters for GET and Delete methods under components(if you missed while creating schema)

Here, is the final business process.

Deploy it on BW run-time..

Open the Swagger URL for testing the logic. You can also use PostMan or SOAPUI

GET Method Result

POST Methods Result

DELETE Method Result

Final Process Log:

DB Table:

That's all.

Thanks for reading :-)