Using Translate activity for XML to JSON

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.

Now in BPEL process, create invoke activity to invoke the file adapter.

Now create XSLT to transform inputVariable to inputFileWrite.

Now deploy composite again and test using same input as above. Now we will observe an output file in directory D as shown below.

You can find a sample project here having both of the cases discussed above.

14 Responses to “Using Translate activity for XML to JSON”

Feed for this Entry Trackback Address

1 Nagaraj S Rao November 1, 2020 at 3:30 AM

Hello,

The Payload mentioned above has Order , Order Lines . I have a similar situation where if there are multiple Order Lines and upon passing the JSON Payload to the BPEL Process, the Receive activity only has the last Order line and the other Order lines are lost. Any pointers on the reason for this behavior.

2 Anonymous December 26, 2017 at 12:34 PM

This has been fixed long back , contact customer support.

3 Anonymous October 4, 2017 at 12:18 PM

Thanks for the detailed post. I also ran into this issue and then Oracle provided a patch for 12.2.1.0; but I noticed that this issue is fixed in 12.2.1.2 version.

- 4 svgonugu October 4, 2017 at 12:23 PM
  
  I too will check thanks for the information now 12.2.1.3 released so will check with that directly
  
5 sandeep July 5, 2017 at 2:41 PM

No fix till now, I am facing slimier issue

- 6 svgonugu July 5, 2017 at 3:01 PM
  
  seems to be yes. Think have to go through oracle support.
  
7 Rakesh November 23, 2016 at 8:15 PM

Hi,

I am facing he same issue while trying to convert from XML to JSON.

By any chance did you figure out whats wrong?

Thanks

Rakesh

- 8 Rakesh November 23, 2016 at 11:38 PM
  
  Just to let you know that I have tried in 12.2.1 and it doesn’t look fixed.
  
  I found a patch for a similar issue but it was for 12.1.3, tried to apply in 12.2.1 but it wont apply as 12.2.1 is higher version.
  
  Thanks
  
  - 9 Vinodh Kumar Mohanam November 24, 2016 at 8:16 PM
    
    Thanks for your information Rakesh.
    
10 Vinod November 23, 2016 at 5:23 PM

Hi Siva,

Thanks for the details on this.

Is this issue fixed by Oracle?

I am currently using nxsdTranslate to convert XML to JSON but the output is coming as binary content. Do you have any information on this?

You inputs are really appreciated.

-Vinod

- 11 svgonugu November 23, 2016 at 9:45 PM
  
  What’s the SOA version you are using..12.1.3? it seems to be its fixed in later releases but i am trying to confirm in version 12.2.1.2
  
  - 12 Vinodh Kumar Mohanam November 24, 2016 at 8:19 PM
    
    I am using version 12.2.1.
    
    I will be great if you can further information on this. Thanks again!
    
    - 13 Sayani Sarkar August 24, 2017 at 5:38 PM
      
      Hi,
      
      I am also using 12.2.1 and still getting the error. please let me know how can i rectify.
      
      Thanks in advance !!
      
      - 14 Anonymous March 31, 2021 at 12:51 PM
        
        Hi
        Not fixed yet.
        
        It is also giving me binary content in version 12.2.1.4.

Siva's Blog