using JSON_VALUE in ReadyAPI
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?
Solved! Go to Solution.
Here you find some samples, please see if that helps!
I found the following solution which works fine for postgresSQL here:
SELECT info ->> 'customer' AS customer
WHERE info -> 'items' ->> 'product' = 'Diaper';
In case still looking for a help, please reply for the question posted in the previous message.