using JSON_VALUE in ReadyAPI
SOLVED- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-11-2021
03:22 AM
06-11-2021
03:22 AM
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?
Solved! Go to Solution.
Labels:
- Labels:
-
SOAP
3 REPLIES 3
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-11-2021
09:22 AM
06-11-2021
09:22 AM
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.
Here you find some samples, please see if that helps!
https://github.com/nmrao/soapUIGroovyScripts/blob/master/groovy/json/QueryDataFromJsonSample.groovy
Regards,
Rao.
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-14-2021
11:27 PM
06-14-2021
11:27 PM
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';
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-15-2021
03:37 PM
06-15-2021
03:37 PM
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.
In case still looking for a help, please reply for the question posted in the previous message.
Regards,
Rao.
