1 Reply Latest reply on Mar 3, 2017 6:01 PM by Ramesh Reddy

    Invoking a JDV Stored procedure with parameters with ODATA

    Rahman Oridedi Newbie

      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