Forum Discussion

yerra16's avatar
yerra16
New Contributor
5 years ago

Not able to save value to excel sheet using data sink

I have created the Data sink in my script in multiple places to save the values from different API's, the values are not getting saved.   Here is the scenario: Data sink 1 Data Sink 2 Data sink ...
  • sonya_m's avatar
    sonya_m
    5 years ago

    Thank you for helping Richie!

     

    Hi yerra16 ! Were you able to solve this?

    Looks like the Community needs more clarifications to keep the investigation going.

     

    However, I feel like this might require a deeper insight into the problem. Please consider opening a support ticket. 

richie's avatar
richie
Community Hero
Hey yerra16,

Are you using datasource test steps as well? Are you using the datasource loop step at all?
Are all 3 datasink steps using the excel type?

Actually, could you please provide a screenshot of the complete testcase so we can see the complete teststep object hierarchy so we can understand the relationship between the executable steps and the datasink steps please?

Thanks

Rich
yerra16's avatar
yerra16
New Contributor
5 years ago

richie 

Thanks for taking interest in my issue.

Below is my project hierarchy  in which i used many data source and data source loop as well. In this suite i used only single excel sheet. Here i took 3 data sink steps to store values of response in same excel but in different sheet.

As of now in screenshot all data sink are disabled. You can view my project hierarchy and get an idea what i am trying to do here. 

I am not sure why my data sinks are not working i added these because need to send store values in different API under loop. But the thing is that when i ran suite only the last data sink values are  getting saved in excel not for all data sink.

Please help me out in this issue as i have been  trying to solve since last week.