Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Dynamics GP API

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

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,584 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,864 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans