This is my first guest post and it couldn't come from a more competent source - so take it away Chris Peytier -
With Oracle Integration Cloud, the need to handle incoming JSON requests is rather common,
However, OIC will attempt to process these request, and will hence not maintain the original JSON format. What if we want to handle the request "as is", preserving its original structure? For example if we want to pass it down to, say, an ADW database instance, so that it can be processed there as JSON document? How can we avoid OIC to interpret and "de-structure" the JSON formatting? We can do this by using an "obfuscated" mode, In order to preserve the JSON structure of an incoming request. For this, we will write & read the file with 2 stage file actions in sequence.
Here are the steps that need to be performed:
a) Write your incoming JSON request into a file, via a Stage File action: You can choose the name of the directory, etc. as you wish.
b) Create a file on your laptop , of type .xsd, for example opaqueSchema.xsd, and enter the following lines in that file: Read the complete article here.
For regular information on Oracle PaaS become a member in the PaaS (Integration & Process) Partner Community please register here.