using JSON_VALUE in ReadyAPI

Question

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_functionsIs there any possibility or solution to do that whithin ReadyAPI?

nmrao · Accepted Answer

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.

nmrao · Answer

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 · Answer

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';

Forum Discussion

using JSON_VALUE in ReadyAPI

3 Replies

Related Content

Using readyApi with Github Actions and Maven

ReadyAPI and TestEngine with Zephyr Scale

How to modify xml files using ReadyAPI

How to Generate Data correctly using datasource in readyAPI

Using smart card / CAC certificate with ReadyAPI

Recent Discussions

Parameterising JDBC Connection Settings..Can you do it?

How to remove (not clear) test case properties from SaveScript

Remove Properties of TestCase from Groovy.

MyFirstPlugin - button Project menu in Ready Api

Integrate ReadyApi with Devops Release pipelines