How to feed data from an excel to an array?

Question

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. Please help me to automate this scenario.Thanks,Chethan

gareth · Answer

Hi,&nbsp;I have the same problem but the solution proposed does not work.&nbsp;I get this error when running the Groovy script:&nbsp;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&nbsp;It seems the code is attempting to set a property with an array (java.util.ArrayList)&nbsp;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.&nbsp;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.

himanshutayal · Answer

Hi&nbsp;Rama16&nbsp;,
&nbsp;
You are replying on a very old post can you please submit new topic and also attach a snipet of your code where you are getting error.
&nbsp;

jkambli · Answer

Hi,You can add a DataSource test step, add excel file as DataSource and add a groovy script test step, add a loop.So lets assume that you have a DataSource property "number" which you want to add in array. Create a test case property "main_array".DataSourceGroovy Script test stepData Source loop (DataSource &gt; Groovy Script test step)In the groovy script test step add,if( context["array"] == null )  context["array"] = [] context["array"] &lt;&lt; context.expand( '${DataSource#Number}' )//log.info  context["array"]// Set the array in testcase property named main arraytestRunner.testCase.setPropertyValue( "main_array", context["array"])This should work!Thanks,Jeshtha

jkambli · Answer

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

gareth · Answer

Thanks for your response - however can you please provide a specific example of how to do this?&nbsp;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.&nbsp;i.e. I need this: &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; modelOptions: ["A3", "B2", "C5"]&nbsp;but what I always get is this &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;modelOptions: "["A3", "B2", "C5"]"&nbsp;...which is invalid JSON syntax.&nbsp;I have also tried returning&nbsp;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.&nbsp;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.&nbsp;Thanks.

Forum Discussion

How to feed data from an excel to an array?

Recent Discussions

Update API definition : Error with the json format

Test result Pass when data source times out

Run Test Case properties not populating for Data Source based items

Related Content

Ready array value from excel

Swagger Response In Array

Array functions