Converting the values of a dataset to a JSON string in WebDev

[Noah_Steele]

Hi there! I have a query tag that is querying a DB table and putting the values into a dataset, and I need to be able to convert this dataset to a JSON string so that I can make it accessible through WebDev via http doGet. Is there a way to convert this dataset to a JSON string within the WebDev python resource, or do I need to set up some other script to convert it first?
Thanks!

[nicoli.liedtke]

You can put your own custom python into the WebDev module. You will want to return from the python resource a dictionary in the following format:

return {"json": <JSON String>}

You can make your own script for the Dataset to Json conversion or I found the following forum post with a solution.

Dataset to simplified Json

We need to have a dataset converted to simplified JSON and the JSON must be written to a tag in the tag database. Also need to update the unicode to quotations. I was trying to save to a document tag. the code I have so far. tagpath = ("[default]path/memorytag") data1 = system.tag.readBlocking(["[default]path/table"])[0].value # convert the incoming value data pyDataset = system.dataset.toPyDataSet(data1) columns = system.dataset.getColumnHeaders(pyDataset) data = [] for row i…