Forum Discussion

_ivanovich_'s avatar
_ivanovich_
Frequent Contributor
5 years ago

How to send value from response into datasource ?

Hi,

say for example in the script assertion we get a value from a  response:

def nameId= context.expand( '${getPerson#Response#$[\'data\'][4][\'name\'][\'nameId\']}' )

Question:

suppose we have already a datasource step with an excel file.

How to send this value "nameId" into a cell named "nameId "in excel file?

without using datasink step.

 

 

 

  • nmrao's avatar
    nmrao
    5 years ago

    Thank you. Wanted to understand why value needs to be stored in excel?
    Would you please point that or post the error if you already tried in script assertion?

    Mostly the a script would work.in script assertion too if that works in groovy script with or without minimal changes

  • nmrao's avatar
    nmrao
    Champion Level 3
    5 years ago
    Can you please give a high level view of the problem trying to solve?
    • _ivanovich_'s avatar
      _ivanovich_
      Frequent Contributor
      5 years ago

      So i have a datasource step with an excel file.

      i have a request (using some data from excel file) which returns a response.

      i want to send a value from the response into the same excel file into a cell.

      I saw some groovy in the forum for this purpose but in my case i want to do it in a script assertion not as groovy step.

       

      • nmrao's avatar
        nmrao
        Champion Level 3
        5 years ago

        Thank you. Wanted to understand why value needs to be stored in excel?
        Would you please point that or post the error if you already tried in script assertion?

        Mostly the a script would work.in script assertion too if that works in groovy script with or without minimal changes