Hi all
I am trying to create an account in CRM 2015 using the OrganizationService from BizTalk. It almost works - I have issues getting values into fields that are of the "Money"-type. In order to test, I have created a small .NET application to simulate
creating the XML BizTalk will be creating and in this small .NET application I cannot get values into Money-fields either.
My sample code is as this:
void CreateAccount()
{
OrganizationServiceClient client = new OrganizationServiceClient();
client.ClientCredentials.Windows.ClientCredential = CredentialCache.DefaultNetworkCredentials;
Entity entity = new Entity() { LogicalName = "account" };
AttributeCollection att = new AttributeCollection();
att.Add(new KeyValuePair<string, object>("accountnumber", "98269828"));
att.Add(new KeyValuePair<string, object>("creditlimit", 1000.00));
att.Add(new KeyValuePair<string, object>("name", "Jan Eliasen Dummy Corp"));
entity.Attributes = att;
Guid g = client.Create(entity);
}
I do not get any exceptions, but the value for "creditlimit" is null in the AccountBase-table in the database, whereas other fields, such as name, telephone number and so on are added just fine. I have researched and found that I probably need
to set a currency for the amount in order to let CRM know how to understand the amount. I have tried setting it in two ways:
att.Add(new KeyValuePair<string, object>("transactioncurrencyidname", "DKK"));
att.Add(new KeyValuePair<string, object>("transactioncurrencyid", new Guid("A9CFECC5-0970-E511-80CB-005056814687")));
where the guid-value is the one I found for the DKK-currency in the "TransactionCurrency"-table in the CRM-database.
Neither seem to work, as the value for TransactionCurrencyId stays null in the created row in the AccountBase-table.
I cannot use the SDK-classes and the Money-class because this is not supported by BizTalk - I need to create the XML for the OrganizationService my self.
As a test, I tried setting the creditlimit like this:
att.Add(new KeyValuePair<string, object>("creditlimit", new Money() { Value = (Decimal)1000.00 }));
but that gave me this exception:
There was an error while trying to serialize parameter
schemas.microsoft.com/.../Services:entity. The InnerException message was 'Type 'TestCRM.crmref.Money' with data contract name 'Money:schemas.microsoft.com/.../Contracts' is not expected. Consider
using a DataContractResolver or add any types not known statically to the list of known types - for example, by using the KnownTypeAttribute attribute or by adding them to the list of known types passed to DataContractSerializer.'. Please see InnerException
for more details.
Does anyone know how I can specify the currency? Or get Money-fields to work in another way?
Thanks!
eliasen, representing himself and not the company he works for.
Five times MVP and four times MCTS in BizTalk.
Blog: http://blogs.eliasen.dk/technical/
