I am looking for a solution to search in a JSON-String as part of a SQL response, like "JSON-Funktion in standard-SQL"
Is there any possibility or solution to do that whithin ReadyAPI?
Go to Solution.
View solution in original post
I found the following solution which works fine for postgresSQL here:
SELECT info ->> 'customer' AS customerFROM ordersWHERE info -> 'items' ->> 'product' = 'Diaper';