Please help us help you and fill where relevant:
Your LimeSurvey version: 5.3.18+220530
Own server or LimeSurvey hosting: Own server
Survey theme/template: Fruity
==================
Hi,

I am trying to export specific questions from a survey via the remote control API (in R with the limer package). As there has been no answer on the limer github page, I wanted to ask here for some guidance.
My issue is that regardless of wheter I call the the API with or without questions specified (parameter "$aFields"), it always returns the full survey data (please note that I could ofc just select the questions after the export directly in R, but I want to understand the API call and the issue here). I am also posting here b/c my problems could be related to the API/json and less to R/limer.

The following json call is sent to the API (ofc with a valid sessionkey): {"method":"export_responses","id":" ","params":{"sSessionKey":"<my_session_key>","iSurveyID":8698I53,"sDocumentType":"csv","sLanguageCode":{},"sCompletionStatus":"complete","sHeadingType":"code","sResponseType":"long","aFields":["869853X191X2006","869853X191X2009"]}}

Is there anything that looks wrong?

Cheers,
Michael
P.S. Interestingly, when I specify only one question in "aFields", only the last three characters of the whole base64 enc string are returned.

 

Hi, Michael,

I do not see an issue using this
Here shown as table


Joffm

Thank you for sharing your code example. As always, it helped solving my issue.
The problem was that I did not specify "iFromResponseID" and "iToResponseID" (in my R call). Though being optional, it seems it is needed that the "aFields" argument is evaluated.
It works now.
Just out of curiosity: How do you get your questioncodes (e.g. "159677X490X9219SQ001")? I either inspect the questionnaire (and leave out the "java" part of the input ID or I combine survey ID, group ID, qid and answercode by looking them up in the question overview in the GUI. Is there a smarter way?

Best,
Michael