December | 2015 | Siva's Blog

Archive for December, 2015

ADF BC REST Services–III – Using Row Finder

Published December 29, 2015 ADF 8 Comments
Tags: ADF, REST

In this post, we will see how to use Row Finder in ADF BC REST services.

Open REST resource VO and create a View Criteria as shown below having 2 bind variables for Department name and Location ID.

Go to Row Finders section and create new one with searhByDeptName.

Here we can observe that above VC is selected by default. In Variables section as shown below, we can also set whether bind variable is allowed to be passed in REST resource URL along with Required settings.

Deploy the application and use any REST client to test GET method using the following urls. Observe the usage of row finder and bind variables.

Passing single bind variable:

http://localhost:7001/departmentApi/rest/r1/departments?finder=searchByDeptName;bindDeptName=A

Passing both bind variables:

http://localhost:7001/departmentApi/rest/r1/departments?finder=searchByDeptName;bindDeptName=A,bindLocId=1800

Now mark bindLocId variable as required and try to test without using it in the URL and you will observe the error as shown below.

Using Translate activity for XML to JSON

Published December 27, 2015 BPEL 14 Comments
Tags: 12c, JSON, Translate, XML

In this post, we will discuss about using Translate activity for converting XML to JSON. This is one of the functionalities I wanted to try since release of 12c as nxsd has been enhanced to handle JSON as well. So I tried this using BPEL in both 12.1.3 and 12.2.1 but found to be not working as expected. Hence I will just mention about approach to use Translate activity. And will show you how its working with File Adapter.

Create a BPEL process and drag Translate activity.

Click gear icon to define NXSD schema as per required JSON data.

Finish the wizard as shown below to create NXSD.

Create BPEL variable varJson of NXSD complex type as shown below.

Create XSLT transformation to transform the input variable to varJson. For simplicity, we considered the NXSD structure almost similar to inputVariable.

Now modify Translate activity by giving required values for all other fields.

Click OK. Now our BPEL process should look like below.

Deploy the composite and test to observe the following error.

Note: Please note that the issue has been fixed in latest releases of SOA suite as observed by readers.

However, the same XML to JSON translation is working as expected with File Adapter. Create file adapter using below screenshots using Write operation.