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
5 years ago
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.

  • yerra16's avatar
    yerra16
    New Contributor
    5 years ago

    we are still waiting for the reply from ur team, we did not get any response after we provide the screenshot

    • richie's avatar
      richie
      Community Hero
      5 years ago

      yerra16 

       

      sorry - I lost the post cos so many others were responded.

       

      I wanted the screenshot to understand about your object hierarchy in your test - the .png you sent - that isn't one testcase is it, or is it?

       

      One of the reasons I wanted the object hierarchy (as well as to see the flow if you're using looping as well, cos I know this can mess things up) was to replicate the issue on my ReadyAPI! instance - there's no way I'm doing that considering the content of the test!

       

      in your post you state "I am not sure why my data sinks are not working i added these because need to send store values in different API under loopI 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.. 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."  Can you just rephrase this - I don't understand what "i added these because need to send store values in different API under loop" means

       

      also - looking at your screenshot - can you confirm what executable steps (REST steps) the Datasinks relate to please?

       

      cheers

       

      rich

      • sonya_m's avatar
        sonya_m
        SmartBear Alumni (Retired)
        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.