Screenshots Speak thousand Words ( with one Code Snippet ) !

Create your First XSJS Webservice in HANA Studio

1. Table TEST1PROD.

2. Test data in table.

3. Create Product.xsjs file

4. Code Snippet in Product.xsjs

function readEntry( rs ) {
return {
“PRODUCT_ID” : rs.getString(1),
“PRODUCT_NAME” : rs.getString(2),
“PRODUCT_DETAIL” : rs.getString(3)};
}
$.response.contentType = “text/atom+xml”;
var conn = $.db.getConnection();
var pstmt = conn.prepareStatement( “select * from TEST1PROD where product_detail=?” );
pstmt.setString(1, $.request.parameters.get(“id”));
//var pstmt = conn.prepareStatement( “select * from TEST1PROD” );
var rs = pstmt.executeQuery();
var output=“”;
var list = [];
while(rs.next()) {
list.push(readEntry(rs)); }
output = JSON.stringify( {“entries”: list } );
$.response.setBody(output);
rs.close();
pstmt.close();
conn.close();

URL for test

http://<hanaserver>:8000/MyPackage/Product.xsjs?id=DRINKS

Output Screenshot :

3 Comments

You must be Logged on to comment or reply to a post.

Raman Korrapati

July 23, 2013 at 11:47 am

Seems like image was broken, please fix it.

Former Member

July 23, 2013 at 11:58 am

Fixed 🙂 Some issue with my cache ... Fixed and updated let me know , if you see any issues ?

Raman Korrapati

July 23, 2013 at 12:00 pm

Thanks ravi, its looks fine.

Thanks for sharing and making useful blog.

Thank you