Does anyone know how/if you can pass parameters to a custom published storedProcedure over OData?
Iv'e tried various OData syntax's and keep getting a 400 error
Such as: (@P1 is the Sproc Parameter)
/_ODataTest(@P1='Test')
/_ODataTest(P1='Test')
_ODataTest?$filter=P1 eq 'Test'
/_ODataTest?$P1='Test'
/_ODataTest?$@P1='Test'
I tested and confirmed the the $filter works when running a view, so the OData service does accept URL parameters, just need to figure out what the format is for stored procedures.
Thanks!