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"]}';

SELECT *
FROM OPENJSON(@json);

got the exception:


mvp_badge
MVP

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.