Forum Discussion

Markus_F's avatar
Markus_F
Occasional Contributor
7 years ago

Extract certain strings from JSON data strucure

Hello community,   I have the following JSON formatted data: {    "interfaces" : {       "interface" : [          {             "interface-name" : "eth0"          },          {          ...
  • TNeuschwanger's avatar
    TNeuschwanger
    7 years ago

    Hello Markus,

    Given that you have a list of values that can vary between 0 and infinity, you can set properties from it easily enough, but now you have to give the property a name for each of those values. For each value a unique name must be created unless you don't care about how many values are in a list. The following builds on prior examples in this thread:

     

    filteredInterfaceNameList = [];
    interfaceNameList.each { name ->
       if (name.contains('cons')) {
          filteredInterfaceNameList.add (name)
       };
    };


    filteredInterfaceNameList.eachWithIndex { interfaceName, idx ->
       propName = "somePropertyNameValue" + idx.toString();
       propValue = interfaceName;
       testRunner.testCase.testSteps["Properties"].setPropertyValue( propName, propValue);
    };

    .

    .

    .
    You have never stated how you would use this dynamically, so I can only imagine... The above code allows you to dynamically write properties from 0 to infinity (or however many Smartbear will allow). :)

Markus_F's avatar
Markus_F
Occasional Contributor

Hi rich,

 

thank you you for your input.

Forgot to say that the data is queried from a server with REST GET request.

The number of "interface-name" instances and the values in the REST response are varying. So, the easy way to just do a transfer from a fixed position into a property is not working.

 

I was thinking about parsing all "interface-name" instances in the REST response with a filter string to store only a certain subset of values for further use.

 

Any ideas how to do that in SOAPUI pro?

 

BR

Markus

richie's avatar
richie
Community Hero
7 years ago
Hey

I think you've a couple of choices here and I don't think my knowledge will do it as i think it'll probably be easier and more robust to rely on groovy (which is outside my skillset).

I've had similar issues before and how i handled this using the GUI was to add in additional parms to my GET query to retrieve a specific number or set of records. In my scenario i filtered my GET so that a specific number of recorda were returned nd passed these to a property step. I then used a datasource (GRID) type to build an array of records which sourced the values from the Properties step. My test needed 6 records (so i setup 6 instances of the repeated attribute values into properties) and i got this working but it failed if the GET request returned less than 6 records.....so my solution wasnt very robust, but it got the job done....but as i say, it wasnt pretty nor robust.

Perhaps one of the other lads can help out with a groovyscript option thats more robust than my approach? Or maybe there's a way of using the embedded functionality that I'm not aware of?

Cheers,

richie