Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

GP2016 OData Stored Procedures

Posted on by 106

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!

Categories:
  • Neal Santin Profile Picture
    Neal Santin 106 on at
    RE: GP2016 OData Stored Procedures

    Update: Response from Microsoft, this isn't supported at this time.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,556 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,625 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans