Forum Discussion

jayagarw's avatar
jayagarw
New Contributor
8 years ago

How to Create a JSON Array from Results at JDBC Test Step in SOAPUI NG Pro

Hi Team   I have a Requirement to create a JSON payload from JDBC Test Step Values dynamically and send it as Request to my rest service. How Can I write the groovy script to fetch the values from ...
nmrao's avatar
nmrao
Champion Level 3
What is the expected output?
jayagarw's avatar
jayagarw
New Contributor
8 years ago

Hi Rao

 

I wanted to create the JSON as below as This is dynamic based on number of records fetched from the query. Reqyestpayload attribute is of type JSONArray

 

{
"requestPayload": [
       {
             "ORDERID": "H001",
             "LINEID": "L001",
             "HOLDID": "1",
             "HOLDNAME": "HOLDA",
             "RELEASED_FLAG": "N"
      },
      {
             "ORDERID": "H001",
             "LINEID": "L001",
             "HOLDID": "2",
             "HOLDNAME": "HOLDB",
             "RELEASED_FLAG": "N"
      },
      {
             "ORDERID": "H001",
             "LINEID": null,
             "HOLDID": "3",
             "HOLDNAME": "HOLDC",
             "RELEASED_FLAG": "N"
      }
   ]
}

 

Thanks

Jayant Agarwal