Gareth
New Contributor
Joined 9 years ago
User Profile
User Widgets
Contributions
Re: How to feed data from an excel to an array?
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.2.7KViews0likes0CommentsRe: How to feed data from an excel to an array?
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.2.7KViews1like4Comments