Hi,
I would like to use LimeSurvey to provide surveys and use the results to elaborate results, making personalized graph and reports.

I am able to connect to the server via API and get data of a specific survey and token, using the export_responses_by_token call.

What I would like to obtain, is the list of surveys completed in a timerange (eg. the last 24 hours). Is there a way to use the API and get this list ?

Many thanks,
Nicola.

Assuming the survey is non-anonymous and you are recording the date stamp, you can can use the API export_responses() method with something like this as the $aFields argument:


Then you should be able to filter the results by the submitdate to get the relevant tokens.

Hi Tony,
thanks for the reply, unfortunately, this is not what I am looking for.

I have a survey that runs for many days, with many participants. I am developing statistics pages in which I show some data about all the responses received. I would like to be able to update the data each day with the responses of the previous day.

Handling it the way you suggest, will force the system to download all the responses every day and discard all those that are not from a specific day.

I am wondering if there is a way to receive only the responses from a specific day.

Thanks,
Nicola.

Maybe it's best to use export_responses
with iFromResponseID by parameters ?

Since there are no filter in export response or export_response by token : you can create your own function : extensions.sondages.pro/development-and-...i/documentation.html

Handling it the way you suggest, will force the system to download all the responses every day and discard all those that are not from a specific day.

My suggestion would not get all of the response data, it would only get the token and submitdate values - a considerably smaller returned result.

If that doesn't suit you could do it with a direct SQL query.

Hi Nicola -- did you end up finding a solution? I'm facing a similar challenge... I have a survey to be completed by individuals from different groups and, for report purposes, I'd like to selectively retrieve responses filtered by group ids (which are captured by a hidden variable).

Hi,
as there is no range of responseIDs you want to export, it is not possible to use the two parameters
"$iFromResponseID" and "$iToResponseID"
and Tony's two step approach.

So, you may export all responses and filter by groups in your script, or you may do it by direct access to the database.
Depends on the amount of records.

Because I am not so very familiar with the API I always prefer the direct access where I can query the database according to my needs.

Joffm