Forum Discussion

fredyjames0818's avatar
fredyjames0818
New Contributor
11 years ago

how to get datasource property value and assign it to a variable from Virt editor

Hi Team,   Currently we have created a datasource property for a Virt (ApplicationId) We are looking to save the property value in a variable. But  facing issues while accessing the property valu...
tonaortega's avatar
tonaortega
Occasional Contributor
10 years ago

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's avatar
    LoundesM
    Contributor
    10 years ago
  • LoundesM's avatar
    LoundesM
    Contributor
    10 years ago

    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)