Invoking a JDV Stored procedure with parameters with ODATA

Latest response

Hi All,
I created a stored procedure that that has several parameters. What i need clarity on is with is the correct syntax for the odata url when adding parameters.

My current URL looks like:
"localhost:8080/odata/MyStoredProcedure/SchemaName.StoredProcedureName?$SchemaName.StoredProcedureName.ParameterNameOfTypeDate=2014-01-01"

The response i get back is
TEIID30089 Required parameter 'SchemaName.StoredProcedureName.ParameterNameOfTypeDate has no value was set or is an invalid parameter.

I also tried appending a ?$filter= and i recieve thesame error.

I am currently using JDV 6.2.9

RO

Responses