Can we use openjson in SQL query builder in outsytems?
Application Type
Traditional Web, Reactive

Hi, Can any once suggest, How can we use openjson in SQL query builder in outsystems?

I have the sample query given below :

SET @json='{"name":"John","surname":"Doe","age":25,"Mdules":["ABC","LMN","OIO"]}';


got the exception:


Hi Mahesh,

I found this article that states the database needs to have compatability level 130 or up for OPENJSON to work. As far as I can check, Personal Environments have compatability level 120, and so do not recognize OPENJSON.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.