Hello All ,
I am trying to create a XSJS (API) to provide data to chatbot in the form of http URL from SAP native HANA .
XSJS file is activated sucessfully but file out put is empty. Tried different ways but did not work out.
Please check below code and help me to correct the logic.
function POST() {
var attendanceID2 = $.request.body.asString();
var essai = attendanceID2.toString().replace("\r", "").replace("\n", "").replace("\t", "");
essai = JSON.parse(essai);
var PLANT= essai.PLANT;
var output;
var body;
var oresultSet = [];
var oresults = [];
var oresult;
var columnCount;
var columnName;
var dbQuery = 'SELECT *FROM ABCD."T001W"';
var oconnection = $.db.getConnection();
/*var statement = null;*/
var ostatement = oconnection.prepareStatement(dbQuery);
oStatement.execute();
var oresultSet = ostatement.getResultSet();
var result = {
records : [ ]
};
while (oresultSet.next()) {
result = {};
columnCount = oresultSet.getMetaData().getColumnCount();
}
for (var i = 0; i < columnCount; i++) {
columnName = resultSet.getMetaData().getColumnName(i + 1);
result[columnName] = resultSet.getNString(i + 1);
}
oResultSet.close();
oStatement.close();
oConnection.close();
$.response.contentType = "application/json; charset=UTF-8";
$.response.setBody(JSON.stringify(result));
$.response.status = $.net.http.OK;