This is possible! You have to create a filter in the Data & Analytics section of the survey program you are trying to export nightly. 

You can create the condition you would like to have. Below I used the Finished metadata set as True.

Once you have this filter added, it will appear in the Extract Survey Responses task in the Workflow. 

Hope this helps! 

Thanks,

But no luck:(

I did that, but when running this WF one time after the other, no files were exported, i  want the entire responses to be exported every time its running….

Very strange. Sorry it didn’t work for you. I tried something similar but instead of a SFTP was loading the data into an Import Data Project and it worked as expected.

A couple troubleshooting questions:

1. The second image in your post - is that referencing the SFTP task or the Extract responses from survey task? I ask because when I view the latter task in my workflow, I can see the csv file that was created. 
2. Were you able to use the Extract task as the option for the file to upload to the SFTP? 
3. Have you looked at the API documentation to see if there is a call that might be able to create this solution? 

Hi

Is this one of the issues wht i get an error?

i want to export every day all the last year survey data

Hi @David_Rod,

You can try with this approach, define the actions you want the workflow to perform. For generating a full data export, you'll need to specify the export settings such as file format (e.g., CSV, Excel). 

https://api.qualtrics.com/6b00592b9c013-start-response-export

Thank you!

Dear @Nanditha MM , In the API do we have an option to provide the path in which the file needs to be exported to ?

And if I can provide the selective columns of Survey that i want to download.

Thanks in advance.

Regards,

Neha Tank

Thought I would weigh in here on OPs original question about getting a workflow setup, not going down the API route as an alternative.

I am experiencing similar failures though what I’ve discovered is that after I create a workflow and run it immediately the first time it performs as expected and dumps a CSV file into an S3 bucket. However, every time it runs after the initial run it indicates it succeeds but it never actually sends a file. I can create a new Workflow with the exact same settings and same thing every time: runs perfectly the first time, never sends file ever again.

Any thought on what I might be doing wrong or why this is not out of the ordinary? I doubt it’s an S3 error since if I delete the file it sends and then run the workflow again it still won’t send the file.