GP Web Services and Invalid Character Errors


Chris Roehrich - Click for blog homepageThis is a reposting of an article Chris Roehrich originally wrote on my Developing for Dynamics GP blog.

I am going to go over the steps to find and resolve invalid data characters in Dynamics GP that cause GP Web Services exceptions.   A common process of “copying and pasting” a block of text from an external program into the Note window for a Dynamics GP record or an import routine directly to the SQL tables can cause Dynamics GP Web Service to throw an error.   When using a .Net application that does a GetSalesOrderByKey error, you may see something like this:

“The application encountered an unhandled system exception.  Contact your system administrator for details.”

Continue reading

Using a GP Web Service Extension in the Connector for Microsoft Dynamics GP


Chris Roehrich - Click for blog homepageThis is a reposting of an article Chris Roehrich originally wrote on my Developing for Dynamics GP blog.

The Connector for Microsoft Dynamics provides a powerful integration platform that can be customized and extended with the CRM Connector SDK and Web Services for Microsoft Dynamics GP SDK tool sets.  The CRM Connector for Microsoft Dynamics GP page in PartnerSource has various downloads to get you started with the CRM Connector including the SDK download.   You can find the GP Web Services SDK download here.  Additionally, the Dynamics GP Web Services SDK page on MSDN contains the same reference information found in the download page and is available to those without accessing PartnerSource or CustomerSource and can be helpful for quick access.

Continue reading

Choosing between eConnect for Microsoft Dynamics GP and Web Services for Microsoft Dynamics GP


Chris Roehrich - Click for blog homepageThis is a reposting of an article Chris Roehrich originally wrote on my Developing for Dynamics GP blog.

Should I write this integration using eConnect or Web Services for Microsoft Dynamics GP?   This is often a question we receive at conferences like Convergence or in support cases from both Customers and Partners.  Like most questions in our field, there really is no concrete answer to this one.  The answer is usually the dreaded “Well, it depends on…”.   What I hope to do here with this post is point out some of the differences of the two integration platforms, give you my opinion on what I like about them, and then you can decide how you would leverage them in your own projects.

Continue reading

Leveraging the changes in eConnect for Microsoft Dynamics GP 2010


Chris Roehrich - Click for blog homepageThis is a reposting of an article Chris Roehrich originally wrote on my Developing for Dynamics GP blog.

In this post I will talk about the changes made to the API for eConnect for Microsoft Dynamics GP 2010 and how developers can take advantage of these changes to affect their custom application.   If you have been using eConnect 2010 you have already realized that there is a new Windows service running called the eConnect for Microsoft Dynamics GP 2010 Integration Service.   This is a change from the version 9 and 10 days where there was a COM+ application for eConnect that appeared under Component Services.  Like the eConnect COM+ application, the eConnect 2010 service runs under a Windows user that requires DYNGRP role access in the DYNAMICS and company databases.  I will breakdown some of the other changes in the following sections.

Continue reading

Creating a Custom Serialization Assembly for eConnect for Microsoft Dynamics GP 2010


Chris Roehrich - Click for blog homepageThis is a reposting of an article Chris Roehrich originally wrote on my Developing for Dynamics GP blog.

The eConnect Programmer’s guide discusses creating a custom XML node and stored procedure so developers can process new types of data.   For example, a custom or 3rd party table could be updated when integrating a master record like a Customer or a transaction like a Sales Invoice using eConnect.   The strategy that I will discuss below is for developers out there that would like to go one step further by referencing their own custom assembly.  This assembly can be referenced in their Visual Studio project which would allow them to serialize the eConnect XML document with the custom node.

Continue reading

Retrieve more than 1000 Records using Web Services for Microsoft Dynamics GP 2010


Chris Roehrich - Click for blog homepageThis is a reposting of an article Chris Roehrich originally wrote on my Developing for Dynamics GP blog.

A question we have received in the past in Developer Support is how to retrieve more than 1000 records using Web Services.   The maximum number of records a GetList method will return is 1000 records.  This is by design as this value is coded into the call to eConnect and it cannot be changed with a configuration file.

Continue reading

Serializing CDATA tags in eConnect XML Documents


Chris Roehrich - Click for blog homepageThis is a reposting of an article Chris Roehrich originally wrote on my Developing for Dynamics GP blog.

I had a recent support incident where the customer was trying to update a field to a blank value using the eConnect serialization assembly and the value was not being removed.  Specifically, they were attempting to remove the existing value in the ADDRESS2 column of the RM00101 table by setting the string value to a blank value.  The reason why this was happening was really by design with the eConnect stored procedures.   If you do not pass a value, eConnect will use the setup in Dynamics GP to default the value if one exists.   This works great because then as a developer you do not have to worry about passing everything in with the XML document.   That would be painful to have to pass everything in the XML document for being fearful of having data being removed.

Continue reading