Skip to Content

How to post sql queries using http calls in HANA

Hello,

I recently came across below xsjs applications in HANA through which one can post sql commands using http calls. But unable to find any SAP reference/documentation on these. Could anyone give me a hint please? I believe it helps us in automations.

/sap/hana/xs/ide/server/net.xsjs

/sap/hana/ide/common/remote/server/net.xsjs

Thanks

Vinod

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 29 at 12:21 PM

    Bodapati,

    there is no direct way to send sql commands via http calls, instead, you could call an odata service to GET/POST/PUT/DELETE records into a table (exposed by the service).

    Another option would be to consume a REST service via a server side call on XS (xsjs / nodejs) and let the web service do the call to a stored procedure (consequently the sql commands). here is the official documentation https://help.sap.com/doc/3de842783af24336b6305a3c0223a369/2.0.01/en-US/index.html?index.html

    According to Lucia Subatin the XS engine (classic) is now deprecated, however, there are a lot of customers with it, so you may need to refer to the XSA (advanced architecture) to see if that is a better fit your scenario. I am sure internally to SAP, you may have a better direction.

    Add comment
    10|10000 characters needed characters exceeded

  • May 29 at 12:43 PM

    Do NOT call either of those xsjs services directly. They aren't for external consumption. They are part of the Web-based Development Workbench. As Sergio said, you should code your own XSJS services or use XSODATA.

    Add comment
    10|10000 characters needed characters exceeded