Joffm wrote:

Hi,
if you use SGQA syntax I do not see an issue.

I admit this is php (I have not the least knowledge of python), but I assume that your python code is correct.

Code:

$surveyResponses = $myJSONRPCClient->export_responses(
    $sessionKey,
    $survey_id,
    'json', // Document type : pdf,csv,xls,doc,json
    null, // Language code : null : default from survey
    'complete', // Stautus complete|incomplete|all
    NULL, // Heading : code|full|abbreviated : question text, default code
    NULL, // answer : short|long , default : long
    1,    // From Response ID
    30000,   // To Response ID   
['id', 'submitdate', 'lastpage', 'startlanguage', 'seed', 'startdate', 'datestamp', '758878X3477X42341', '758878X3477X42342SQ001', '758878X3477X42342SQ002', '758878X3477X42342SQ003', '758878X3478X42343', 'interviewtime', '758878X3477time', '758878X3478time']
);

Here the data of the last participant and everything displayed as table

Joffm

 

Thank you very much for your explanation! With this I managed to figure out my problem. This was three fold:

1. I was trying to retrieve group timings on answer/child question level
2. I didn't realise I also needed to retrieve answers with the SGQA code, I couldn't use the field name from the json or csv output.
3. For retrieving answers for sub-questions (like in multiple choice or matrix questions) I couldn't use the qid from the sub-question, but needed to use the qid of the parent question and the "title" of the sub-question.

Thank you a lot. This resolved my issue!

So in my case to retrieve the timings for a group I needed the following parameters survey id and group id. I need to put them together in a code like this:
[sid]X[gid]time -> 758878X3478time

If I want to retrieve the answers i.E. a text answer or a single choice question (both are questions without child questions) I need the parameters survey id, group id, question id. I need to to put them together like this:
[sid]X[gid]X[qid] -> 758878X3477X42341

If I want to retrieve the answers for something like a multiple choice or matrix question (questions with child questions). I need the parameters survey id, group id, parent question id, child question title. I need to put them together like this:
[sid]X[gid]X[parent qid][child title] -> 758878X3477X42342SQ003

Again thanks a lot for your help, I was really blocked here.

In case someone is googling this in the future. You can get the IDs for all fields with the API method"get_fieldmap()":  api.limesurvey.org/classes/remotecontrol...#method_get_fieldmap

I'Ve pulled an example from the survey I'm working on.

If you exported via the GUI this would be the column/variable: "SA02[x]"
"title" is the "Code" you know from the GUI when creating a new question. "aid" is the "Code" from subquestions:
 

I may be feeling like an idiot right now, because I build something like this fieldmap from exporting single questions and merging them together to get all the relevant data.

Anyway, maybe this will save some future API users a lot of time.