Skip to Content
2
Aug 24, 2021 at 06:24 AM

Call stored procedure from CAP with parameters or payload

1054 Views Last edit Aug 25, 2021 at 01:21 PM 4 rev

Hi,

I have created one CAP project from template and having stored procedures in that to create entry in hana table. Requirement is to get values from request (CreatedBy, CreatedOn, Remarks) and pass it to procedure instead of generating random values as per below link (To post request payload is {} in this link)

https://www.youtube.com/watch?v=wdfJ4ZP4aQs

1. Issue - While doing "cds build' procedure is not saved into gen folder .

2. While calling action from .http getting error as "addlog not an entity set , singleton , an action import , or a function import" 404 not found error

Is there any relation between 1st issue and 2nd one.

Thanks

Saranya

Attachments

actionissue.jpg (19.9 kB)
issue1.png (7.7 kB)