SAP Cloud Application Programming Model: Stored Procedure as Action

We were asked a recent question about how to create an Action within SAP Cloud Application Programming Model and using an SAP HANA Stored Procedure as the implementation of the action. This video was created in response and builds a small example application that does exactly that.

0:00 Introduction
1:02 Create new project
2:19 Add Entity
3:49 Create HDI service instance
7:31 CDS build and then deploy to HANA
9:27 Create HANA Stored Procedure
11:48 Create service with action
13:09 Create REST Client test
14:38 Create service handler for the action
17:08 Successfully test end to end
19:24 Closing

[roberteijpe]

Hi Thomas, again a very useful and great explained example

[sangeethak]

Hi Thomas, what if we are passing some payload from Test.http file, anything we have to add? because am getting error saying "addRandomBook" is not an entity set, a singleton, an action import or a function import.

[gautamkrishnan]

Is it compulsory to have a POST http request associated with an action in CAP? Can't it be a GET, PUT or any other http request? If so, why?

[manimanu]

every time i create project i get this error

C:\Users\muhammad:1

[isaacperez]

An excellent example. It has been very useful for me.

I would, however, like to see an example of how to call a procedure with parameters. That is, how are the parameters passed from the action handler in CAP, to the procedure?

(I've had a hard time with that)