RC2 API export_responses RPC routine returns empty responses

More
3 years 2 months ago - 3 years 2 months ago #121479 by johntopley
johntopley created the topic: RC2 API export_responses RPC routine returns empty responses
Hi,

I'm trying to use the RemoteControl 2 API to export my survey responses. I'm testing it using the Chrome Postman REST client extension. I get a valid response from LimeSurvey (i.e. no error), but when I Base64 decode the result I can see all my question heading codes but the responses are all empty strings.

I have verified that my survey responses are in the underlying PostgreSQL database and if I manually export the responses through the admin UI all the response data are present.

This is what my request looks like:
{
    "method": "export_responses",
    "params": {
        "sSessionKey": "x9stphdub277vu54qam4svg9g3anhfas",
        "iSurveyID": "944268",
        "sDocumentType": "csv",
        "sLanguageCode": "en",
        "sCompletionStatus": "all",
        "sHeadingType": "code",
        "sResponseType": "short",
        "iFromResponseID": "1",
        "iToResponseID": "10"
    },
    "id": 1
}

How can I debug this further? Thanks in advance for any help.
Last Edit: 3 years 2 months ago by johntopley.

Please Log in or Create an account to join the conversation.

More
3 years 2 months ago #121528 by johntopley
johntopley replied the topic: RC2 API export_responses RPC routine returns empty responses
It turns out my iFromResponseID and iToResponseID values were incorrect! :blush:

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!