cancel
Showing results for 
Search instead for 
Did you mean: 

using JSON_VALUE in ReadyAPI

SOLVED
DietmarS
New Contributor

using JSON_VALUE in ReadyAPI

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?

1 ACCEPTED SOLUTION

Accepted Solutions
nmrao
Community Hero

Re: using JSON_VALUE in ReadyAPI

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.


Regards,
Rao.

View solution in original post

3 REPLIES 3
nmrao
Community Hero

Re: using JSON_VALUE in ReadyAPI

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


Regards,
Rao.
DietmarS
New Contributor

Re: using JSON_VALUE in ReadyAPI

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
Community Hero

Re: using JSON_VALUE in ReadyAPI

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.


Regards,
Rao.

View solution in original post

New Here?
Join us and watch the welcome video:
Top Kudoed Authors