Hi,
I'm using SAP HANA XS Advanced. I created a calculation view with a mandatory input parameter called "ID".
In the Filter Expressions tab from the calculation view I used the parameter like so:
"ID"=$$ID$$
My xsodata service looks like this:
service { "MyApp.Database::employeebyid" as "employeeById" keys generate local "localID" parameters via entity "InputParams"; }
Now I wanted to try the service using the browser. Without Parameter it all works fine when using this URL:
https://myhanainstance:51036/employeeById.xsodata/employeeById?$format=json
But how do I get my parameters into that? For XS Classic I found this:
http://myserver:80xx/path/to/myService.xsodata/myViewParameters(KUNNR='12345')
So I tried:
https://myhanainstance:51036/employeeById.xsodata/employeeByIdInputParams(ID=1)?$format=json
But it just says:
"Resource not found for the segment 'employeeByIdInputParams' at position 0."
What I expected because it is called employeeById and not employeeByIdInputParams but it seemed to work here. Or did I get that wrong?
I think that overall my service is working and I only have a wrong request URL because without Parameters I get the output:
column store error: search table error: [34023] Instantiation of calculation model failed;exception 306106: Undefined variable: $$ID$$. Variable is marked as required but not set in the query\n
Hope someone knows which URL I have to use. Seems to be a marginal problem but I can't solve it using Google or the Dev Guide.
Kind regards,
Philipp