Announcements
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!
*This post is locked for comments
Update: Response from Microsoft, this isn't supported at this time.
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156