Skip to main content
Microsoft Dynamics GP forum
Suggested answer

Dynamics GP API

editSubscribe (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.

  • 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,781 Super User 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

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,066 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,585 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans