using JSON_VALUE in ReadyAPI

[DietmarS]

Hi all,

I am looking for a solution to search in a JSON-String as part of a SQL response, like "JSON-Funktion in standard-SQL"

https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions

Is there any possibility or solution to do that whithin ReadyAPI?

[nmrao]

Would you please post a sample response that you receive (need not be exact) and what value you need to get out of it?

Here you find some samples, please see if that helps!
https://github.com/nmrao/soapUIGroovyScripts/blob/master/groovy/json/QueryDataFromJsonSample.groovy

[DietmarS]

I found the following solution which works fine for postgresSQL here: 

https://www.postgresqltutorial.com/postgresql-json/

SELECT info ->> 'customer' AS customer
FROM orders
WHERE info -> 'items' ->> 'product' = 'Diaper';

[nmrao · Accepted solution]

Didn't understand if you could proceed or not.
In case still looking for a help, please reply for the question posted in the previous message.