Have an up-to-date copy of all incoming responses in your own system by receiving responses from Quicksearch.
There is an option to continuously export response data and background information for surveys from Analytics to your systems. This is done by setting up an export in Analytics.
Export can be done via webservice or SFTP. In both cases, you can choose the format between JSON or CSV. The format of the export and its content are controlled by export templates in Analytics.
Exports can be either complete, a complete list of all responses, or incremental transfer, where responses that have been added or changed since the last export are sent.
We advise against exporting all responses if you have many responses, for example, over 20,000 respondents or individuals, as it affects export, transfer, and import on both sides.
Receive via SFTP
When exporting via SFTP, an export is performed automatically daily, weekly, or monthly, and the export can either be incremental (changes since the last export) or complete (all responses in the result).
Receive via API
If you have the ability to set up a Webservice API on your side, we can trigger this API continuously with information that a new export is ready for retrieval. The exports can be CSV formatted or JSON. Quicksearch has sample code for such an API written in several different programming languages.
Contact Quicksearch for more information.
Important for ongoing exports of survey responses
Surveys differ slightly from many other types of transactions because a survey can start one day and then finish on another day, for example, after a reminder. If you only export completely finished surveys, this is not a problem, but since it is common for about 10% of surveys to be started but never completed, the first part of the response can come one day and then the second part of the response on another day.
Quicksearch's solution to this is that we always include a unique ID number for each survey, and we always include all the information we have at the time of export. This makes it easy for you to be sure that you do not receive duplicates on the receiving end even if we send the response multiple times.
To avoid duplicates, you first delete any old copies of a survey based on the ID that comes and then insert the new value completely. This is usually called UPSERT or DELETE+INSERT.
Warning emails
We can automatically send a warning email to you if we are unable to generate a raw data file or if we are unable to transfer a created raw data file to you. To do this, we need one or more email addresses that can receive these warnings.