Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Dynamics GP API

(0) ShareShare
ReportReport
Posted on by 75,730

Is there such a thing as an API for GP? I simply use SQL and stored procedure to query the database.

Categories:
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Dynamics GP API

    Where can I find documentation on how to use SOAP to access data in GP from an outside source?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Dynamics GP API

    Can you provide a link? Doing a generic search yields mostly Dynamics 365 stuff.

  • FisherF Profile Picture
    FisherF 20 on at
    RE: Dynamics GP API

    To access the Microsoft Dynamics Great Plains API Swagger documentation directly, navigate to Microsoft Dynamics Great Plains API Documentation.Direct2HR.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Dynamics GP API

    David, the client has outsourced the warehouse. The folks running the WMS that is running Oracle SX was asking if GP had an API. I think I will ask them what they need and decide which tool to use.

  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,957 Most Valuable Professional on at
    RE: Dynamics GP API

    Hi Richard

    There are many APIs for Microsoft Dynamics GP.

    eConnect, REST Web Services, SOAP Web Services, Dexterity APIs

    However, if you just want to read data you can use SQL directly.

    If you need to access data from outside the network, you can use Service Based Architecture with the SOAP based web services to read data. If there isn't a node for the data you want, GP Power Tools can create custom Web Services to perform any task, so you can use it to create additional nodes for any table in any product.

    Regards

    David

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,735 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans