Forum Discussion

ChethanMS's avatar
ChethanMS
11 years ago

How to feed data from an excel to an array?

Hi, Can anyone please let me know how can I pass values to an array? I have a requirement where a set of values occur more than once. The number of times the set occur differs for each request. Pl...
Gareth's avatar
Gareth
New Contributor

Hi,

 

I have the same problem but the solution proposed does not work.

 

I get this error when running the Groovy script:

 

groovy.lang.MissingMethodException: No signature of method: com.eviware.soapui.impl.wsdl.WsdlTestCasePro.setPropertyValue() is applicable for argument types: (java.lang.String, java.util.ArrayList) values: [modelOptions, [W5]] Possible solutions: setPropertyValue(java.lang.String, java.lang.String), getPropertyValue(java.lang.String) error at line: 7

 

It seems the code is attempting to set a property with an array (java.util.ArrayList) but the method only works setting a string (java.lang.String). I have searched the forums for a solution to this i.e. setting a property with an array - but have not found it.

 

Can you please advise how to take a list of values (e.g. in Excel) and then convert that to an array (JSON in this case) to set in a Request.

JKambli's avatar
JKambli
Staff
9 years ago

Convert the array to string since testCase properties can only save strings, you can reconvert it to array when you wish to reuse it.

 

Thanks

  • Gareth's avatar
    Gareth
    New Contributor
    9 years ago

    Thanks for your response - however can you please provide a specific example of how to do this?

     

    I have a REST service with a JSON payload. Whenever I refer to the Property, it formats its as a String rather than an Array.

     

    i.e. I need this:                                   modelOptions: ["A3", "B2", "C5"]

     

    but what I always get is this              modelOptions: "["A3", "B2", "C5"]"

     

    ...which is invalid JSON syntax.

     

    I have also tried returning the "result" of the Groovy script directly rather than using a Property. I return an array, however, this is still converted to a String as above.

     

    So, can you please provide some specific step by step approach to set a JSON array programatically (based on Excel data or any data source). Asserting that something can be done is not sufficient for someone asking how it can be done.

     

    Thanks.