Character replacement in Web Services

bbrown

I know about using an underscore (_) to replace a space. But what do you do about commas (,) and periods (.)? As an example, the US demo company is "CRONUS USA, Inc.". All the documentation is based on the worldwide database that does not have this issue. I know I could just rename the demo company but I'd like to find the solution in case I see this issue in a client system.

freddy.dk

First - answering the question first - a comma becomes _x002c_ - meaning that the US company will be

CRONUS_USA_x002c__Inc

Haven't tested it right now - but I am 99% sure.
You can always connect a infopoint to the System Service and get the list of companies from that.

Second - I think I will write a blog post about name mangling in Web Services, URL handling and in properties in WS - stay tuned.

bbrown

Thanks for the reply. That did not work for the comma. (I assume those are zeros)

I sent "CRONUS USA, Inc" as "CRONUS_USA_x002c_Inc". Is that what you meant? I've renamed the company for now so I can keep moving, but I know I run into this again. And in a live company I may not have the option of renaming.

freddy.dk

You need two underscores after x002c - since the comma is _x002c_ and the following space is _

CRONUS_USA_x002C__Inc

should be correct (just double checked an answer made to another guy for whom it worked).

mbj

From C# you can use the SystemService to show all companies converted

ws3.UseDefaultCredentials = true;
ws3.Url = "http://10.55.140.122:7047/DynamicsNAV/WS/SystemService"; //Remember
string[] companies = ws3.Companies();

foreach (string company in companies)
{
lstCompanies.Items.Add(company.ToString()); //ListBox
}