New SHAREPoint Kompendium Magazin Article About ECS Web Service Designer For SharePoint

In the last issue of the SHAREPoint Kompendium Magazin (Band 6, 2014) I published an article in German about the brand new ECS Web Service Designer for SharePoint 2010/2013 from Theobald Software. The application is a desktop windows application allowing you to visually design SAP driven Web Services for SharePoint.

How To Design WCF Services For SharePoint 2013 Without Writing Code Using ECS Web Service Designer

Theobald Software just released the ECS Web Service Designer for SharePoint 2010/2013. The designer is part of the product suite ERPConnect Services, a suite which allow you the complete range of data integration between SharePoint and your SAP system.

The Web Service Designer is a fantastic way to visually design and deploy no-code SOAP or OData web services for SharePoint. Each service operation can be designed using a workflow designer (see screenshots). The designer provides a couple of base, flow and SAP-related activities the user can choose from to build it’s operation logic.

The base and flow group of activities consist of the following:

  • Check Condition Activity (IfElse)
  • Switch Cases Activity
  • For Each Activity
  • Do While Activity
  • Custom Code Activity
  • Assign Value Activity
  • Add Item (to collection) Activity

The SAP-related group of activities consist of the following:

  • Execute Table Activity (reads data from a SAP table)
  • Execute Function (execute a SAP BAPI function module)

A key feature of the ECS Web Service Designer is the option to use C# expressions for field/property mappings.

Other feature highlights are:

  • One-Click and direct solution deployment on SharePoint servers
  • One-Click SharePoint solution generation
  • One-Click Visual Studio exporting (the visually designed web service can be exported as VS solution)

For more information about this brand new product, see Theoabld Software product site.

Stock Quote Add-In for Excel 2013

I have developed a new version of the popular ‚MSN-like Stock Quotes Add-In For Excel 2007‘ for Excel 2013. The user defined function PSQ is exactly the same as in previous version, but it will retrieve stock data asynchronously. This makes the Excel user interface more responsive to user actions, especially if you have to query for a lot of stock symbols.

You may download source and binary files from the Codeplex site:

PMStockQuote-Screenshot-About PMStockQuote-Screenshot-Update

NOTE: I do not have the time to provide support for this tool. You should read carefully the README.txt with installtion instructions.

Nice HTML5 demos with SAP stock quantity and customer data using ERPConnect

A couple of weeks ago I have implemeted two HTML5 demos in C# using ASP.NET MVC, Web API and jQuery. The demos are displaying SAP customer and stock quantity data. The SAP/.NET connectivity is handled by the ERPConnect library from Theobald Software. The primary goal was to show how easily you can integrate good looking visual effects with jQuery.


The customer demo (CIS) adds hidden table rows with a horizontal silder showing an order quantity diagram. The stock quantity demo (SIS) displays mutliple table rows once the user clicks on the top row. In addition it will add an extra row showing a chart.

YouTube video of the stock quantity demo
YouTube video of the customer information demo

jQuery / CSS libraries or tools used in demos:
– Bootstrap (twitter)
– jQuery.Shadow
– jqBarGraph
– pagePeel
– progressbutton.jQuery
– liteAccordion

The samples are part of the ERPConnect library. You can download a trail version from Theobald Software. ERPConnect is a lean .NET assembly that lets you develop robust SAP interfaces without a great degree of effort and most of all, without an elaborate infrastructure or any additional middleware.


Fiddler and the 401 (Unauthorized) error with ASP.NET Web API using Integrated Windows Authentication (WIA)

A few days ago I had a real strange problem while using HttpClient in combination with ASP.NET Web API and integrated windows authentication (IIS Express). To keep it simple, I always got a 401 (Unauthorized) error returned from the localhost website, even though I was setting up the HttpClient correctly (see screenshots) and the HttpClient was sending the authorization header (negotiate).

In my code is was using the URI http://localhost.fiddler:51275/api/values to access the REST API. The .fiddler part in the URI allows Fiddler to monitor the HTTP traffic between the website and the console application. For more details about this setting take a look at Fiddler’s homepage:

After researching a while I found out, that exactly the .fiddler URI addition is part of the problem for the 401 error I always received. Microsoft changed the logic of the NTLM authentication for some of the security classes in .NET version 3.5 SP1 (see link below) in order to avoid relefection attacks. A reflection attack is a method of attacking a challenge-response authentication system. The HttpClient uses those changed classes internally to connect to the website.

So, the solution is quite simple. We just need to add the registry key BackConnectionHostNames (important: Multi-Value String) to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\ Control\Lsa\MSV1_0 section in the registry with the value localhost.fiddler. A full explanation about the security concepts in WIA you will find at Microsoft’s site: Changes to NTLM authentication for HTTPWebRequest in Version 3.5 SP1

You can easily reproduce this error by creating a standard MVC4 web application with a Web API controller using windows authentication (see screenshot for settings). Then you add a console application to the project from which access the REST API (ValuesController).