Forum Discussion
tonaortega
Occasional Contributor
Hello,
Did you solve your problem? I'm trying to get values from excel datasource but I'm unable to get it using my script dispatcher. I don't know how to get them, it sounds like is similar to your question.
LoundesM
8 years agoContributor
Hi
not sure how you're trying to get the data from the data source but here's how I've done it
// define datasource to use def virtDS = mockRequest.getContext().getMockService().dataSources.getVirtDataSource("DataSourceName") // reset DataSource to top record and get 1st row of data virtDS.prepare(requestContext.getMockRunner(), requestContext) def strmapDS = virtDS.next(requestContext.getMockRunner(), requestContext) // get data - These will reference the column names in your DS def dsHeader = strmapDS.get("Header", "value") def dsValue = strmapDS.get("Value", "value") //................... //get next row values by using strmapDS = virtDS.next(requestContext.getMockRunner(), requestContext)
Related Content
- 4 years ago
Recent Discussions
- 2 days ago