Forum Discussion

fredyjames0818's avatar
fredyjames0818
New Contributor
10 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 value using get PropertyValue

 

context.getMockResponse().getPropertyValue(ApplicationId)

 

Kindly help

  • tonaortega's avatar
    tonaortega
    Occasional Contributor
    9 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
      9 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)