cancel
Showing results for 
Search instead for 
Did you mean: 

Not able to save value to excel sheet using data sink

SOLVED
Highlighted
New Contributor

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 3

 

only Value from the data sink 3 is saving the value into excel sheet the remaining 2 data sink values are not saving to excel. we tried to disable the data sink of "Data sink 3"  and execute the script with Data sink 1 & Data Sink 2 and at that time Data sink 2 values is getting stored in Excel sheet. only the latest value is getting stored to excel sheet.

 

please provide the solution for the same.

 

Thanks in Advance

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Manager

Re: Not able to save value to excel sheet using data sink

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


Sonya Mihaljova
Community and Education Specialist

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️

View solution in original post

5 REPLIES 5
Highlighted
Community Hero

Re: Not able to save value to excel sheet using data sink

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
if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the Subject header field of the post to something more descriptive? This will help people when searching for problems. Ta
Highlighted
New Contributor

Re: Not able to save value to excel sheet using data sink

@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.

Highlighted
New Contributor

Re: Not able to save value to excel sheet using data sink

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

Highlighted
Community Hero

Re: Not able to save value to excel sheet using data sink

@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

if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the Subject header field of the post to something more descriptive? This will help people when searching for problems. Ta
Highlighted
Community Manager

Re: Not able to save value to excel sheet using data sink

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


Sonya Mihaljova
Community and Education Specialist

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️

View solution in original post

New Here?
Join us and watch the welcome video:
Announcements
Top Kudoed Authors