Ask a Question

How to send value from response into datasource ?

Frequent Contributor

How to send value from response into datasource ?


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

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


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.




Community Hero

Can you please give a high level view of the problem trying to solve?

Frequent Contributor

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.


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 script assertion too if that works in groovy script with or without minimal changes


@_ivanovich_ :


Could you please share any screenshot or dummy script where you are getting error, it would be usefull to solve your issue.


Click "Accept as Solution" if my answer has helped,
Remember to give "Kudos" 🙂 ↓↓↓↓↓

Thanks and Regards,
Himanshu Tayal
SmartBear Alumni (Retired)

Thank you nmrao, HimanshuTayal!


@_ivanovich_ were you able to solve this? Please share the results with usSmiley Happy

Otherwise, we can continue the investigation here if you provide the info Himanshu and Rao are asking of you above.

Sonya Mihaljova
Community and Education Specialist

Showing results for 
Search instead for 
Did you mean: