sqljsonadaptor

This class extends the %JSON.Adaptor class. It adds two SqlProc methods that allow return the same results as the original adaptor’s %JSONExportToStream and %JSONExportToString methods view SQL.

Classes that extend this class will be able to run an SQL query as follows:

select mytable_jsonstring(id,mapname) from mytable

where mytable is the table’s name, id is the row’s ID, and mapname is the name of a map defined for the %JSON.Adaptor (optional) and that will return a column containing the same contents you would expect from the %JSONExportToString method. The same is true for mytable_jsonstream if a stream is preferred.

Installation

This class is available via IPM.

install sqljsonadaptor