Regarding Data to JSON operator for proper JSON output

Hi,

this is the expected behaviour. In your case, you already have JSON data. Data to JSON doesn't know that, it handles your JSON attribute as a normal text attribute, and converts it *again* into standard JSON, which has to escape the "s with \. 

You could split up your example set: select all attributes but the JSON one into one table, keep the JSON attribute in another, keep a common ID (maybe create it with Generate ID if you don't have one) and join later for example.

Best regards,
Balázs

Hi, actually there is only 1 column in my example set that has the json data.. but I need the example set in json so how do I split up? Or how do I do it?

Hi!

So you already have JSON data? Why are you using "Data to JSON" then? 
I don't understand what you need by "I need the example set in json so how do I split up".
Either you need the JSON, you already have that.
Or you want so split up into different attributes. Use JSON to Data (from the Text Processing extension) for that, or the functionality in the database if that exists. There's also Extract Information where you can use JSONPath to access parts of your document.

Regards,
Balázs

Hello, 
Actually, what I meant is... I am getting whole JSON data in single column in Exampleset. But what I want is the actual JSON structure with JSON data as output. Not the JSON data present in table......

Can you provide examples? What you have, what you want?

Hi, 
For better understanding I am attaching a picture here, Please do take a look. Below picture is the output of Read database operator which is Exampleset. But What I am expecting is actual JSON structure with JSON format as output. 

You already have an actual JSON structure with JSON format in the syselement attribute. Please explain what problem you're trying to solve.

Hi, yes but I need to do data to json to that because the json is in example set format and in attribute syselement. I want it as a fresh only json like what we get when we do data to json 

Hi,

you can use "Data to Documents" to convert the example set format to a collection of documents, similarly to "Data to JSON". 
Use "Nominal to Text" to convert the JSON attribute to a text attribute, and "Data to Documents" will pick it up.

Regards,
Balázs

Thank you will try it out