Create a custom API from a view

[mario_galeano]

In the SQL version of the Service Layer, how could I create a custom API like in SAP Hana?

[former_member197733 · Accepted solution]

To clarify, your script is an XSJS(Server Side JavaScript) which has no relation whatsoever with Service Layer.

If you are looking for just querying the DB and having the results as sa rest service using Service Layer you can use the query service.

Other approach would be to have the query encapsulated on a SQL view and have the view exposed.

Both are detailed in the Working with SAP Business One Service Layer official guide