- Posts: 8
- Thank you received: 1
Ask the community, share ideas, and connect with other LimeSurvey users!
var listResponsesXLS = function (SURVEYID, SURVEYNAME){ options.body = JSON.stringify({method:'export_responses',params:{sSessionKey:SESSIONKEY,iSurveyID:SURVEYID, sDocumentType:'xls', sLanguageCode:'fr', sCompletionStatus:'complete', sHeadingType:'full', sResponseType:'long' },id:1}); request(options, function(error, response, body){ if(!error && response.statusCode==200){ body = JSON.parse(body); b64 = body.result; bin = atob(b64); fs.writeFileSync(DATEOFTHEDAY+"_"+SURVEYNAME+".xls", bin, "utf8"); } else console.log("ERROR -->"+body.result); }); }
{ request: { debugId: 3, uri: 'https://192.168.1.17/limesurvey/index.php/admin/remotecontrol', method: 'POST', headers: { 'user-agent': 'Apache-HttpClient/4.2.2 (java 1.5)', host: 'limesurvey.xxxxx.loc', path: '/index.php/admin/remotecontrol', connection: 'keep-alive', 'content-type': 'application/vnd.ms-excel', 'content-length': 236 }, body: '{"method":"export_responses","params":{"sSessionKey":"tn59w52pr2y3arc4gixe5tupphivbg82","iSurveyID":"565971","sDocumentType":"xls","sLanguageCode":"fr","sCompletionStatus":"complete","sHeadingType":"full","sResponseType":"long"},"id":1}' } }
{ response: { debugId: 3, headers: { date: 'Tue, 28 Jun 2016 16:25:05 GMT', server: 'Apache/2.4.7 (Ubuntu)', 'x-powered-by': 'PHP/5.5.9-1ubuntu4.13', 'set-cookie': [Object], expires: 'Thu, 19 Nov 1981 08:52:00 GMT', 'cache-control': 'no-store, no-cache, must-revalidate, post-check=0, pre-check=0', pragma: 'no-cache', 'content-length': '0', 'keep-alive': 'timeout=5, max=100', connection: 'Keep-Alive', 'content-type': 'text/html' }, statusCode: 200 } }
{ request: { debugId: 3, uri: 'https://192.168.1.17/limesurvey/index.php/admin/remotecontrol', method: 'POST', headers: { 'user-agent': 'Apache-HttpClient/4.2.2 (java 1.5)', host: '192.168.1.17', path: '/index.php/admin/remotecontrol', connection: 'keep-alive', 'content-type': 'application/vnd.ms-excel, charset=utf-8', 'Content-Disposition': 'attachment, filename=abc.xls', Expires: 0, 'Cache-Control': 'must-revalidate, post-check=0, pre-check=0', 'content-length': 236 }, body: '{"method":"export_responses","params":{"sSessionKey":"a5xssj2uvjjsbdvxyp8g9tb7sz92yuvd","iSurveyID":"565971","sDocumentType":"xls","sLanguageCode":"fr","sCompletionStatus":"complete","sHeadingType":"full","sResponseType":"long"},"id":1}' } } { response: { debugId: 3, headers: { date: 'Tue, 28 Jun 2016 16:54:02 GMT', server: 'Apache/2.4.7 (Ubuntu)', 'x-powered-by': 'PHP/5.5.9-1ubuntu4.13', 'set-cookie': [Object], expires: 'Thu, 19 Nov 1981 08:52:00 GMT', 'cache-control': 'no-store, no-cache, must-revalidate, post-check=0, pre-check=0', pragma: 'no-cache', 'content-length': '0', 'keep-alive': 'timeout=5, max=100', connection: 'Keep-Alive', 'content-type': 'text/html' }, statusCode: 200 } }
{ request: { debugId: 3, uri: 'https://192.168.1.17/limesurvey/index.php/admin/remotecontrol', method: 'POST', headers: { 'user-agent': 'Apache-HttpClient/4.2.2 (java 1.5)', host: '192.168.1.17', path: '/index.php/admin/remotecontrol', connection: 'keep-alive', 'content-type': 'application/json', 'content-length': 236 }, body: '{"method":"export_responses","params":{"sSessionKey":"fr5ihxqdpedzivgw7gi9qt6wpkrwmhwt","iSurveyID":"565971","sDocumentType":"xls","sLanguageCode":"fr","sCompletionStatus":"complete","sHeadingType":"full","sResponseType":"long"},"id":1}' } }
{ response: { debugId: 3, headers: { date: 'Wed, 29 Jun 2016 06:45:49 GMT', server: 'Apache/2.4.7 (Ubuntu)', 'x-powered-by': 'PHP/5.5.9-1ubuntu4.13', 'set-cookie': [Object], expires: 'Thu, 19 Nov 1981 08:52:00 GMT', 'cache-control': 'no-store, no-cache, must-revalidate, post-check=0, pre-check=0', pragma: 'no-cache', 'keep-alive': 'timeout=5, max=100', connection: 'Keep-Alive', 'transfer-encoding': 'chunked', 'content-type': 'text/javascript' }, statusCode: 200, body: '{"id":1, "result":"0M8R4KGxGuEAAAAAAAAAAAAAAAAAAAAAOwADAP7/CQAGAAAAAAAAAAAAAAABAAAAEQAAAAAAAAAAEAAAAAAAAAEAAAD+////AAAAABIAAAD////////[...........................]/////////////////w==", "error":null}' } }