Convert JSON to String Oracle Integration

This video will help you to convert the JSON payload to string.

[firnnauriel]

Hi. Thanks for this great tutorial! May I know what's the content of the "opaque.xsd" used during ReadFile Stage File Action?

[jayalakshmisampath]

Hi Ankur,
Thanks for the videos!
What is the opaque.xsd file contains?

[pipideluxe]

Good content!! I do however have a question. Would these steps work if you want the end format in xml? I.e json to xml?

[Bhavishas]

Hi Ankur,
Thanks for the video. Its super helpful

Also I have an use case to read an entire xml fragment and send the entire fragment to the target system in an single output attribute. Is it possible to do this stage action?

[rajaselvammarimuthu]

Hi Ankur, I need to design one Oracle Integration (App Driven Orchestration) flow endpoint to receive JSON messages through POST for multiple functionalities.
So JSON structure will be different for each functionality. In this case what kind of sample JSON to upload it.

Can I mention empty JSON like this { }?

[brianoverton]

Hi Ankur,
Nice write up.
How would you go about doing the opposite? Say I have a string text called "payload" which is a string that should be handled and mapped as json. How would this be done?
For Example, I want to convert this:
{
"messages": [
{
"action": "UPDATEPERSON",
"payload": "{\"personId\":\"1234\", \"firstName\":\"Some\", \"lastName\":\"One\":[]}"
}
]
}
into this:
{
"messages": [{
"action": "UPDATEPERSON",
"payload": [{
"personId": "1234",
"firstName": "Some",
"lastName": "One"
}
]
}
]
}

[Krishna-mhes]

Hi Sir, in response also i need to get same json format, how can i get it

[sudharshanreddy]

Hi Ankur,
Could you please make a video on certificates and what need to do when certificates expire.

[corvindeus]

Thanks for posting this. It was helpful!!! I wish there was an easier/dynamic way to copy the raw JSON response instead of having to re-map the JSON to itself. My JSON has over 30 elements. If anyone has a way to do that please message me.

[corvindeus]

After some more research, I found a way to post the WHOLE raw JSON string/response without doing the stage file mapping. I had a very large JSON structure that sometimes changes and hard to map each element. I needed to post the whole JSON sting to the database. So in the (webservice response to database post) mapper, It would not allow me to drag and drop the mapping – giving me an error. But if I put the whole “Response Wrapper” code (i.e. NOT in the mapping, it would pass the whole JSON string. Hope this make sense, if not, email me so I can share a better example. Ankur, maybe this would be a good video to add to your nice collection.

[FlightEnroute]

How can we get proper format In output
{
"data" : "{"firstname" : "ankur", "lastname" : "jain"}"
}