Hello everyone,

I'd like to export the responses from a survey to another DB. This should happen once a day and I need the submit date, responses by questions and first and last name. I'm on 3.1.0.

I assume that I have to use the API functions list_participants to filter for the current date and then use export_responses_by_token for the answers and submit date. I tested with Postman, however I can't seem to filter for the date correctly. This is my request:

{"method":"list_participants",
"params":{
"sSessionKey":"XXX",
"iSurveyID":XXX,
"iStart":0,
"iLimit":-1,
"bUnused":false,
"aAttributes":false,
"aConditions":{"submitdate":"2018-02-16"}
},
"id":1}

This just returns all participants. Filtering for other stuff like email works. Am I doing something wrong?

Also, what would be the best way to automate this?

Might be a bug. Instead of submitdate you might try:
"completed": "2018-02-17 00:00"
I haven't used the API for a longer time and I'm not using Postman.