Skip to content



I, and I suspect most GP consultants, have had a slightly fuzzy idea what a web service is. To help clear this up I went straight to Wikipedia and got this definition:

“a software system designed to support interoperable machine-to-machine interaction over a network. It has an interface described in a machine-processable format (specifically WSDL). Other systems interact with the Web service in a manner prescribed by its description using SOAP-messages, typically conveyed using HTTP with an XML serialization in conjunction with other Web-related standards.”

I have interpreted this to mean “a piece of code, called remotely over the Internet, that does stuff”. I do not pretend any of this information to be technically sound but I do think it will help GP consultants to understand Web Services and in particular how to work with the SmartConnect Web service.

So a couple of points to make:
1. You do not need a LAN, VPN, CITRIX or Terminal Serve to execute a shared web service
2. You do need an Internet connection
3. You normally call a web service from some ‘code’ – unless you have SC do it for you
4. Web Services can do just about anything – they could execute some other code, could return data etc.

So our challenge was to open up GP by including Web Service technology within SmartConnect. Of course eOne wanted to make these services available to consultants and not just tools in the domain of developers. We have used Web services in a number of ways within SmartConnect:
1. Allow remote entry of data via Excel. You can be anywhere and hit send on an Excel sheet which will connect to the SC web service and push data into GP.
2. You can have your developers call the SC web service from their own code, to execute a map.
3. We use the CRM web services to write data to CRM tables. SmartConnect does not ever write data direct to tables in CRM but we pass data to the web service.
4. Connecting with CRM online. I had a consultant this week say ‘Wow, how did that SC map just execute and instantly update a CRM system hosted inside Microsoft, in Redmond’ – it was by calling a CRM web service.
5. Pulling data out of CRM is also done through the CRM web service. We ask the web service for data, and it sends it back to SmartConnect.

This leads to the question of whether SC works with the Web services that have been built for GP? The answer is that for the moment we have not connected to these web services, but instead are using eConnect. The main reason for this is that there is broader functionality within eConnect and by having a single SC web service we do not need to confuse you with multiple web services.

So to all the consultants out there, it is time to amaze your clients with the world of web services. The traditional boundaries of networks can be put aside and the world has become a much smaller place.


  1. pegasys on December 18, 2009 at 11:04 am

    Crm Services could really give aide to those people that have more tasks than everybody else. availing this CMS

    Solutions could get your life run a little smoother.Thanks for this very informative review. This seems to be very

    interesting, and very helpful for the readers.
    Keep on posting!
    Crm Services

  2. sathish on December 2, 2010 at 9:44 am

    Thanks for the sharing of such information.This is a great stuff of reading. I will pass it on to our audience. Thanking you,CRM Services

Leave a Comment


Tech Tuesday: Building My First Matrix Report
Overcoming the Top Challenges of Zendesk Integration
Accessing Historical Dynamics GP Data in NetSuite: Using Popdock
Popdock's Top 10 New Features
New Webinar: Getting Started with Matrix Reporting in Popdock


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder



Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release SalesForce SmartConnect SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.