I have seen a few good posts on updating BDC data columns from workflows utilizing web service tasks but haven’t seen any that are straight to the point and work well for all situations.  The specific situation in the scenario I wanted to solve was updating a BDC list item based on a part number entered into the title column so that users could reference associated data.  I did this by passing the site, list id and row id as a parameter to a ASP.Net web service from a Nintex Workflow.  Here is the webservice code to find the list row and update the BDC data column without using the _ID hidden fields. Read more >>

Here is a quick note on how to generate a proxy class for inclusion in your applications so you can consume and utilize the methods in a web service.

1. Locate WSDL.exe (Typically in the Visual Studio Install Folder’s VC directory).
2. Run the command wsdl.exe /out:<output file location> /l:<CS or VB) <web service location
3. Example wsdl.ext /out:C:myProxyClass.cs /l:CS https://websericeurl.com/webservicename.asmx?WSDL
4. In order to compile this into a dll just run the command csc /t:library /out:C:myProxyClass.dll C:MyProxyClass.cs

Take the resultant dll and include it in your projects to access the web methods of the target web service.  If the structure (not implementation) of the web service changes you will need to generate a new proxy class to take advantage of the new web methods or continue using methods whose structure has changed.

The QuickBooks SDK Web Connector is a great tool for exchanging data between your QuickBooks installation and web services.  Here is an overview of how to implement a skeleton Web Connector so that you can access your QuickBooks data using QBXML. 

Read more >>