web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Dynamics GP API

(0) ShareShare
ReportReport
Posted on by 75,852 Moderator

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

Categories:
I have the same question (0)
  • Suggested answer
    David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    14,151 Most Valuable Professional on at

    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

  • Richard Wheeler Profile Picture
    75,852 Moderator on at

    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.

  • FisherF Profile Picture
    20 on at

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

  • Richard Wheeler Profile Picture
    75,852 Moderator on at

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

  • Richard Wheeler Profile Picture
    75,852 Moderator on at

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

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 797

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 610 Super User 2026 Season 1

#3
Subra Profile Picture

Subra 534

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans