https://community.qlik.com/t5/Integration-Extension-APIs/QRS-POST-Node-js/m-p/1603219#M10986 <P>This is running for me:</P> <LI-CODE lang="javascript">var https = require('https'); var fs = require('fs'); const data = JSON.stringify({ schemaPath: "DataConnection", privileges: null, // Adjusted from "" to [] customProperties: [], // Changed ID for my sa_repository account owner: {"id":"5334b296-493b-46ee-b621-79ba238ceb2c","userId":"sa_repository","userDirectory":"INTERNAL","name":"sa_repository","privileges":null}, // Adjusted name to a unique name name: "QLogs1", connectionstring: "CUSTOM CONNECT TO \"provider=QvOdbcConnectorPackage.exe;driver=postgres;host=test-server;port=4432;db=QLogs;FetchTSWTZasTimestamp=1;MaxVarcharSize=262144;\"", type: "QvOdbcConnectorPackage.exe", engineObjectId: "a6261e01-302f-4e3f-8fb9-cb6a447c591a", username : "qlogs_reader", password : "Ql1k-ReaDeR+{20!%}", logOn : 0, architecture : 0, // Adjusted from "" to [] tags : [] }) var options = { "rejectUnauthorized": false, // Adjusted host hostname: 'usral-ltu2.qliktech.com', path: '/qrs/dataconnection?xrfkey=0123456789abcdef', method: 'POST', port:4242, headers: { 'x-qlik-xrfkey' : '0123456789abcdef', 'X-Qlik-User' : 'UserDirectory= Internal; UserId= sa_repository', 'Content-Type': 'application/json' }, // Adjusted path to cert key: fs.readFileSync("C:\\ProgramData\\Qlik\\Sense\\Repository\\Exported Certificates\\.Local Certificates\\client_key.pem"), cert: fs.readFileSync("C:\\ProgramData\\Qlik\\Sense\\Repository\\Exported Certificates\\.Local Certificates\\client.pem"), }; var req = https.request(options, function (res) { var responseString = ""; res.on("data", function (data) { responseString += data; }); res.on("end", function () { console.log(responseString); }); }); req.write(data); req.end();</LI-CODE> Wed, 17 Jul 2019 13:12:35 GMT Levi_Turner 2019-07-17T13:12:35Z https://community.qlik.com/t5/Integration-Extension-APIs/QRS-POST-Node-js/m-p/1602541#M10975 <P>I'm trying to call this post / app / content / table method in nodejs, but I get the error: Missing parameter value (s). What am I doing wrong?</P><P>&nbsp;</P><P>var https = require('https');<BR />var fs = require('fs');<BR />var options = {<BR />"rejectUnauthorized": false,<BR />hostname: 'test.test.com',<BR />path: '/qrs/app/content/table?xrfkey=0123456789abcdef&amp;name=FindLongLatImported',<BR />method: 'POST',<BR />port:4242,<BR />headers: {<BR />'x-qlik-xrfkey' : '0123456789abcdef',<BR />'X-Qlik-User' : 'UserDirectory= Internal; UserId= sa_repository',<BR />'Content-Type': 'application/json'<BR />},<BR />key: fs.readFileSync("C:\\Users\\myuser\\nodeJS\\certificates\\client_key.pem"),<BR />cert: fs.readFileSync("C:\\Users\\myuser\\nodeJS\\certificates\\client.pem"),<BR />ca: fs.readFileSync("C:\\Users\\myuser\\nodeJS\\certificates\\root.pem")<BR />};<BR />var req = https.request(options, function (res) {<BR />var responseString = "";<BR />res.on("data", function (data) {<BR />responseString += data;<BR />});<BR />res.on("end", function () {<BR />console.log(responseString);<BR />});<BR />});<BR />req.write('"41439c69-2091-4d5c-9dcc-a39431caa9d4"');<BR />req.end();</P><P>&nbsp;</P><P>Error:&nbsp;Missing parameter value(s)</P><P>&nbsp;</P> Sat, 16 Nov 2024 05:16:16 GMT https://community.qlik.com/t5/Integration-Extension-APIs/QRS-POST-Node-js/m-p/1602541#M10975 kassyernar 2024-11-16T05:16:16Z https://community.qlik.com/t5/Integration-Extension-APIs/QRS-POST-Node-js/m-p/1602887#M10981 <P>Here's an example that I have doing a POST:</P> <P>&nbsp;</P> <LI-CODE lang="javascript">var fs = require('fs'); var request = require('request'); fs.readFile('C:\\Scripts\\NodeJS\\foo.xml', function (err, data) { if (err) return console.error(err); options = { url: '<A href="https://usral-ltu2.qliktech.com:4242/qrs/contentlibrary/Default/uploadfile?externalpath=foo.xml&amp;overwrite=true&amp;xrfkey=abcdefghijklmnop" target="_blank">https://usral-ltu2.qliktech.com:4242/qrs/contentlibrary/Default/uploadfile?externalpath=foo.xml&amp;overwrite=true&amp;xrfkey=abcdefghijklmnop</A>', method: 'POST', headers: { 'x-qlik-xrfkey' : 'abcdefghijklmnop', 'X-Qlik-User' : 'UserDirectory= Internal; UserId= sa_repository ', 'Content-Type' : 'application/json' }, key: fs.readFileSync('C:\\ProgramData\\Qlik\\Sense\\Repository\\Exported Certificates\\.Local Certificates\\client_key.pem'), cert: fs.readFileSync("C:\\ProgramData\\Qlik\\Sense\\Repository\\Exported Certificates\\.Local Certificates\\client.pem"), ca: fs.readFileSync("C:\\ProgramData\\Qlik\\Sense\\Repository\\Exported Certificates\\.Local Certificates\\root.pem"), body: data }; // Needed for NodeJS 10.x: process.env.NODE_TLS_REJECT_UNAUTHORIZED = "0"; request.post(options, function (err, message, data) { if (err) return console.error(err); console.log(data) }); });</LI-CODE> <P>&nbsp;</P> <P>Obviously that has many hard-coded values which need adjusting, but feel free to use it as a base.</P> <P>Since the options &gt; url value is being truncated. Here it is:&nbsp;<A href="https://usral-ltu2.qliktech.com:4242/qrs/contentlibrary/Default/uploadfile?externalpath=foo.xml&amp;overwrite=true&amp;xrfkey=abcdefghijklmnop" target="_blank">https://usral-ltu2.qliktech.com:4242/qrs/contentlibrary/Default/uploadfile?externalpath=foo.xml&amp;overwrite=true&amp;xrfkey=abcdefghijklmnop</A></P> Tue, 16 Jul 2019 19:10:27 GMT https://community.qlik.com/t5/Integration-Extension-APIs/QRS-POST-Node-js/m-p/1602887#M10981 Levi_Turner 2019-07-16T19:10:27Z https://community.qlik.com/t5/Integration-Extension-APIs/QRS-POST-Node-js/m-p/1603088#M10983 <P>&nbsp;</P><LI-CODE lang="javascript">var https = require('https'); var fs = require('fs'); const data = JSON.stringify({ id: "a6261e01-302f-4e3f-8fb9-cb6a447c591a", createdDate: "2019-01-14T11:57:21.331Z", modifiedDate: "2019-01-14T11:57:21.331Z", modifiedByUserName: "INTERNAL\\sa_repository", schemaPath: "DataConnection", privileges: null, customProperties: "", owner: {"id":"a909e838-c99f-4f40-8976-382fd77f8f65","userId":"sa_repository","userDirectory":"INTERNAL","name":"sa_repository","privileges":null}, name: "QLogs", connectionstring: "CUSTOM CONNECT TO \"provider=QvOdbcConnectorPackage.exe;driver=postgres;host=test-server;port=4432;db=QLogs;FetchTSWTZasTimestamp=1;MaxVarcharSize=262144;\"", type: "QvOdbcConnectorPackage.exe", engineObjectId: "a6261e01-302f-4e3f-8fb9-cb6a447c591a", username : "qlogs_reader", password : "Ql1k-ReaDeR+{20!%}", logOn : 0, architecture : 0, tags : "" }) var options = { "rejectUnauthorized": false, hostname: 'test.test.kz', path: '/qrs/dataconnection?xrfkey=0123456789abcdef', method: 'POST', port:4242, headers: { 'x-qlik-xrfkey' : '0123456789abcdef', 'X-Qlik-User' : 'UserDirectory= Internal; UserId= sa_repository', 'Content-Type': 'application/json' }, key: fs.readFileSync("C:\\Users\\MyUser\\nodeJS\\certificates\\client_key.pem"), cert: fs.readFileSync("C:\\Users\\MyUser\\nodeJS\\certificates\\client.pem"), }; var req = https.request(options, function (res) { var responseString = ""; res.on("data", function (data) { responseString += data; }); res.on("end", function () { console.log(responseString); }); }); req.write(data); req.end();</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>I almost managed to call the POST-<A href="https://help.qlik.com/en-US/sense-developer/April2019/APIs/repositoryserviceapi/index.html?page=1120" target="_self">api</A>, but he does not accept my <A href="https://help.qlik.com/en-US/sense-developer/April2019/APIs/repositoryserviceapi/index.html?page=1601" target="_self">parameters</A> ...&nbsp;I get the error:&nbsp;Object reference does not indicate an object instance.<BR />You can get foo.xml to run your code</P> Wed, 17 Jul 2019 09:42:20 GMT https://community.qlik.com/t5/Integration-Extension-APIs/QRS-POST-Node-js/m-p/1603088#M10983 kassyernar 2019-07-17T09:42:20Z https://community.qlik.com/t5/Integration-Extension-APIs/QRS-POST-Node-js/m-p/1603219#M10986 <P>This is running for me:</P> <LI-CODE lang="javascript">var https = require('https'); var fs = require('fs'); const data = JSON.stringify({ schemaPath: "DataConnection", privileges: null, // Adjusted from "" to [] customProperties: [], // Changed ID for my sa_repository account owner: {"id":"5334b296-493b-46ee-b621-79ba238ceb2c","userId":"sa_repository","userDirectory":"INTERNAL","name":"sa_repository","privileges":null}, // Adjusted name to a unique name name: "QLogs1", connectionstring: "CUSTOM CONNECT TO \"provider=QvOdbcConnectorPackage.exe;driver=postgres;host=test-server;port=4432;db=QLogs;FetchTSWTZasTimestamp=1;MaxVarcharSize=262144;\"", type: "QvOdbcConnectorPackage.exe", engineObjectId: "a6261e01-302f-4e3f-8fb9-cb6a447c591a", username : "qlogs_reader", password : "Ql1k-ReaDeR+{20!%}", logOn : 0, architecture : 0, // Adjusted from "" to [] tags : [] }) var options = { "rejectUnauthorized": false, // Adjusted host hostname: 'usral-ltu2.qliktech.com', path: '/qrs/dataconnection?xrfkey=0123456789abcdef', method: 'POST', port:4242, headers: { 'x-qlik-xrfkey' : '0123456789abcdef', 'X-Qlik-User' : 'UserDirectory= Internal; UserId= sa_repository', 'Content-Type': 'application/json' }, // Adjusted path to cert key: fs.readFileSync("C:\\ProgramData\\Qlik\\Sense\\Repository\\Exported Certificates\\.Local Certificates\\client_key.pem"), cert: fs.readFileSync("C:\\ProgramData\\Qlik\\Sense\\Repository\\Exported Certificates\\.Local Certificates\\client.pem"), }; var req = https.request(options, function (res) { var responseString = ""; res.on("data", function (data) { responseString += data; }); res.on("end", function () { console.log(responseString); }); }); req.write(data); req.end();</LI-CODE> Wed, 17 Jul 2019 13:12:35 GMT https://community.qlik.com/t5/Integration-Extension-APIs/QRS-POST-Node-js/m-p/1603219#M10986 Levi_Turner 2019-07-17T13:12:35Z https://community.qlik.com/t5/Integration-Extension-APIs/QRS-POST-Node-js/m-p/1603434#M10988 <P>Try calling this method:</P><P>/qrs/app/content/table?xrfkey=0123456789abcdef</P> Thu, 18 Jul 2019 03:48:18 GMT https://community.qlik.com/t5/Integration-Extension-APIs/QRS-POST-Node-js/m-p/1603434#M10988 kassyernar 2019-07-18T03:48:18Z