Converting Table Data to JSON for SQL Server Data Element Input

You have (papering over some minor technicalities) a JSON structure - specifically, a json array/list containing JSON objects already; your property tree.
I don't see why you think you need to convert it into a PyDataset. You should be able to convert your Perspective property structure into a JSON string to insert in your query using system.util.jsonEncode.

1 Like