Forum Discussion

fredyjames0818's avatar
fredyjames0818
New Contributor
9 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
8 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
    8 years ago
  • LoundesM's avatar
    LoundesM
    Contributor
    8 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)