Open Forum

Expand all | Collapse all

GP OData v4 or GP Web Services

  • 1.  GP OData v4 or GP Web Services

    Posted Jun 11, 2019 09:46 AM
    Our software architect would like to get some thoughts on using odata v4 vs web services for writing applications.  He stated
    "It looks like connecting with Power BI or other BI tools is best done via odata, but for writing applications that are creating and updating entities like sales orders, the web service API would be more appropriate."

    Any thoughts or insights would be appreciated.  Thank you.

    Jim

    ------------------------------
    James Delmonte
    Dynamics GP Manager
    Groupe Stahl
    Mentor MI
    ------------------------------


  • 2.  RE: GP OData v4 or GP Web Services

    GPUG ALL STAR
    Posted Jun 11, 2019 04:17 PM
    Edited by Beat Bucher Jun 11, 2019 04:23 PM
    Hi James,
    Your software architect is right.. oData was primarily intend to 'consume' data from GP for PowerBI dashboard for example, whereas the Web Services are a full API interface to use eConnect and create transactions in GP.
    https://community.dynamics.com/gp/b/dynamicsgp/archive/2016/07/13/microsoft-dynamics-gp-2016-odata-service

    Though technically the oData v4 protocol states that you should also be able to create data, I've not seen anything close related to this with Dynamics GP.
    Ian Grieve has several blog posts about oData setup & security configuration too
    https://www.azurecurve.co.uk/2018/01/hands-on-with-mdgp-2018-rtm-install-gp-odata-service/

    This blog post (non GP related) goes into the details about what oData should really be, and which Microsoft seems to have only integrated to some extend.
    http://www.bizcoder.com/2009/11/30/oh-data/

    PS: GPUG Allstar Shawn Dorward has published a blog post on oData with GP


    ------------------------------
    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    @GP_Beat http://www.gp-geek.com
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)
    All-Star 2013
    ------------------------------



  • 3.  RE: GP OData v4 or GP Web Services

    Posted Jun 13, 2019 04:22 AM
    Beat,

    Thanks for the info.  It was just what he needed to move forward.  We can now start planning and designing our next generation of API's.

    ------------------------------
    James Delmonte
    Dynamics GP Manager
    Groupe Stahl
    Mentor MI
    ------------------------------



  • 4.  RE: GP OData v4 or GP Web Services

    TOP CONTRIBUTOR
    Posted Jun 14, 2019 10:53 AM
    Edited by Steve Endow Jun 14, 2019 11:10 AM
    Hi @James Delmonte,

    If you haven't yet used or tested GP Web Services, I would strongly recommend researching and prototyping it before fully committing to it and investing in it, just to make sure you know what you are getting into.

    While GP Web Services does technically work, there are some downsides. The installation and configuration can be a hassle, it is SOAP based with a few Microsoft quirks, and the API design is nothing like current modern REST style web APIs.  If you are only developing against GP Web Services internally using .NET, it may work well for you. But if you need to interface with external providers or SaaS platforms that expect REST APIs, you will be limited.  If you find that GP Web Services does not have an endpoint that you need, you will need to invest in extending or customizing Web Services, which is not trivial, and would be an investment in old technology and architecture.

    If you have development resources, another option to consider is to develop a modern web API using ASP.NET Core.  It's incredibly powerful, flexible, fast, and lightweight.  It would require investment to develop, but would then provide you with full control over your API endpoints and functionality, allowing you to call eConnect, SQL, or just about any other on-prem or SaaS resource.

    I presented a session at the GP Tech conference last year on ASP.NET Core, as well as using Azure Functions and Flow for smaller scale limited APIs:

    https://gptech2018conference.sched.com/event/EyRv/creating-restful-web-apis-for-dynamics-gp-with-aspnet-core

    ------------------------------
    Steve Endow, Microsoft MVP
    Precipio Services
    Los Angeles, CA
    steveendow (at) gmail (dot) com
    ------------------------------



  • 5.  RE: GP OData v4 or GP Web Services

    Posted Jun 14, 2019 11:45 AM
    Thank you Steve.  Very informative
    I passed it on.

    ------------------------------
    James Delmonte
    Dynamics GP Manager
    Groupe Stahl
    Mentor MI
    ------------------------------



  • 6.  RE: GP OData v4 or GP Web Services

    TOP CONTRIBUTOR
    Posted Jun 17, 2019 10:02 AM
    To use OData for Great Plains you need to upgrade to GP 2018 SP2

    ------------------------------
    Bruce Strom
    Programmer Analyst
    Associated Grocers of Florida / Supervalu
    Sunrise FL
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role