Databases
StackOverflow2013
Postsdbo
POUnable to insert Dynamics CRM record via SOAP request for datatype "Money"
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUnable to insert Dynamics CRM record via SOAP request for datatype "Money"
    text
    copied!<p>I am trying to send an XML SOAP request(given below) to my Microsoft Dynamics crm . However its throwing me error. I realized that it goes through if I avoid </p> <p><code>&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;new_grantprojecttotalcost&lt;/c:key&gt; &lt;c:value i:type='a:Money'&gt;&lt;b:Value&gt;1234.00&lt;/b:Value&gt;&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;new_grantprojectfundingrequired&lt;/c:key&gt; &lt;c:value i:type='a:Money'&gt;&lt;b:Value&gt;123.00&lt;/b:Value&gt;&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;</code></p> <p>which is of datatype Money.<br> The complete request looks like this</p> <pre><code> &lt;s:Envelope xmlns:s="http://www.w3.org/2003/05/soap-envelope" xmlns:a="http://www.w3.org/2005/08/addressing" xmlns:u="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd"&gt; &lt;s:Header&gt; &lt;a:Action s:mustUnderstand="1"&gt; http://schemas.microsoft.com/xrm/2011/Contracts/Services/IOrganizationService/Create&lt;/a:Action&gt; &lt;a:MessageID&gt; urn:uuid:6511f419-3d6d-446f-852e-ffd1169d1d14&lt;/a:MessageID&gt; &lt;a:ReplyTo&gt; &lt;a:Address&gt; http://www.w3.org/2005/08/addressing/anonymous&lt;/a:Address&gt; &lt;/a:ReplyTo&gt; &lt;VsDebuggerCausalityData xmlns="http://schemas.microsoft.com/vstudio/diagnostics/servicemodelsink"&gt; uIDPozJEz+P/wJdOhoN2XNauvYcAAAAAK0Y6fOjvMEqbgs9ivCmFPaZlxcAnCJ1GiX+Rpi09nSYACQAA&lt;/VsDebuggerCausalityData&gt; &lt;a:To s:mustUnderstand="1"&gt; https://scy.crm4.dynamics.com/XRMServices/2011/Organization.svc&lt;/a:To&gt; &lt;o:Security s:mustUnderstand="1" xmlns:o="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd"&gt; &lt;u:Timestamp u:Id="_0"&gt; &lt;u:Created&gt;2013-09-19T05:27:01.35Z&lt;/u:Created&gt; &lt;u:Expires&gt;2013-09-19T05:32:01.35Z&lt;/u:Expires&gt; &lt;/u:Timestamp&gt; &lt;EncryptedData Id="Assertion0" Type="http://www.w3.org/2001/04/xmlenc#Element" xmlns="http://www.w3.org/2001/04/xmlenc#"&gt; &lt;EncryptionMethod Algorithm="http://www.w3.org/2001/04/xmlenc#tripledes-cbc"&gt; &lt;/EncryptionMethod&gt; &lt;ds:KeyInfo xmlns:ds="http://www.w3.org/2000/09/xmldsig#"&gt; &lt;EncryptedKey&gt; &lt;EncryptionMethod Algorithm="http://www.w3.org/2001/04/xmlenc#rsa-oaep-mgf1p"&gt; &lt;/EncryptionMethod&gt; &lt;ds:KeyInfo Id="keyinfo"&gt; &lt;wsse:SecurityTokenReference xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd"&gt; &lt;wsse:KeyIdentifier EncodingType="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-soap-message-security-1.0#Base64Binary" ValueType="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-x509-token-profile-1.0#X509SubjectKeyIdentifier"&gt; &lt;/wsse:KeyIdentifier&gt; &lt;/wsse:SecurityTokenReference&gt; &lt;/ds:KeyInfo&gt; &lt;CipherData&gt; &lt;CipherValue&gt; &lt;/CipherValue&gt; &lt;/CipherData&gt; &lt;/EncryptedKey&gt; &lt;/ds:KeyInfo&gt; &lt;CipherData&gt; &lt;CipherValue&gt; &lt;/CipherValue&gt; &lt;/CipherData&gt; &lt;/EncryptedData&gt; &lt;/o:Security&gt; &lt;/s:Header&gt; &lt;s:Body&gt; &lt;Create xmlns='http://schemas.microsoft.com/xrm/2011/Contracts/Services'&gt; &lt;entity xmlns:b='http://schemas.microsoft.com/xrm/2011/Contracts' xmlns:i='http://www.w3.org/2001/XMLSchema-instance'&gt; &lt;b:Attributes xmlns:c='http://schemas.datacontract.org/2004/07/System.Collections.Generic'&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;scy_name&lt;/c:key&gt; &lt;c:value i:type='d:string' xmlns:d='http://www.w3.org/2001/XMLSchema'&gt;Business Grant Programme Application&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;new_fullname&lt;/c:key&gt; &lt;c:value i:type='d:string' xmlns:d='http://www.w3.org/2001/XMLSchema'&gt;Aboo Tafadar4&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;new_jobtitle&lt;/c:key&gt; &lt;c:value i:type='d:string' xmlns:d='http://www.w3.org/2001/XMLSchema'&gt;Iquara&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;scy_accountname&lt;/c:key&gt; &lt;c:value i:type='d:string' xmlns:d='http://www.w3.org/2001/XMLSchema'&gt;Iquara&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;scy_emailaddress&lt;/c:key&gt; &lt;c:value i:type='d:string' xmlns:d='http://www.w3.org/2001/XMLSchema'&gt;soyeed2004@gmail.com&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;scy_contactphone&lt;/c:key&gt; &lt;c:value i:type='d:string' xmlns:d='http://www.w3.org/2001/XMLSchema'&gt;913642225808&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;scy_addressline1&lt;/c:key&gt; &lt;c:value i:type='d:string' xmlns:d='http://www.w3.org/2001/XMLSchema'&gt;Bivar Road&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;scy_addressline2&lt;/c:key&gt; &lt;c:value i:type='d:string' xmlns:d='http://www.w3.org/2001/XMLSchema'&gt;aaaa&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;scy_addressline3&lt;/c:key&gt; &lt;c:value i:type='d:string' xmlns:d='http://www.w3.org/2001/XMLSchema'&gt;Iquara Ltd, Catalyst&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;scy_city&lt;/c:key&gt; &lt;c:value i:type='d:string' xmlns:d='http://www.w3.org/2001/XMLSchema'&gt;York&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;scy_postcode&lt;/c:key&gt; &lt;c:value i:type='d:string' xmlns:d='http://www.w3.org/2001/XMLSchema'&gt;yo103jy&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;new_registeredaddress1&lt;/c:key&gt; &lt;c:value i:type='d:string' xmlns:d='http://www.w3.org/2001/XMLSchema'&gt;Iquara Ltd, Catalyst&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;new_registeredaddress2&lt;/c:key&gt; &lt;c:value i:type='d:string' xmlns:d='http://www.w3.org/2001/XMLSchema'&gt;University of York&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;new_registeredaddress3&lt;/c:key&gt; &lt;c:value i:type='d:string' xmlns:d='http://www.w3.org/2001/XMLSchema'&gt;Iquara Ltd, Catalyst&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;new_registeredcity&lt;/c:key&gt; &lt;c:value i:type='d:string' xmlns:d='http://www.w3.org/2001/XMLSchema'&gt;York&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;new_registeredpostcode&lt;/c:key&gt; &lt;c:value i:type='d:string' xmlns:d='http://www.w3.org/2001/XMLSchema'&gt;yo103jy&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;scy_websiteurl&lt;/c:key&gt; &lt;c:value i:type='d:string' xmlns:d='http://www.w3.org/2001/XMLSchema'&gt;iquara&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;scy_companynumber&lt;/c:key&gt; &lt;c:value i:type='d:string' xmlns:d='http://www.w3.org/2001/XMLSchema'&gt;1787686&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;new_yearstartedtrading&lt;/c:key&gt; &lt;c:value i:type='d:string' xmlns:d='http://www.w3.org/2001/XMLSchema'&gt;1980&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;scy_description&lt;/c:key&gt; &lt;c:value i:type='d:string' xmlns:d='http://www.w3.org/2001/XMLSchema'&gt;hghghjg&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;new_grantprojectdescription&lt;/c:key&gt; &lt;c:value i:type='d:string' xmlns:d='http://www.w3.org/2001/XMLSchema'&gt;khkkjh&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;new_grantprojecttotalcost&lt;/c:key&gt; &lt;c:value i:type='a:Money'&gt;&lt;b:Value&gt;1234.00&lt;/b:Value&gt;&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;new_grantprojectfundingrequired&lt;/c:key&gt; &lt;c:value i:type='a:Money'&gt;&lt;b:Value&gt;123.00&lt;/b:Value&gt;&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;scy_leadsource&lt;/c:key&gt; &lt;c:value i:type='b:OptionSetValue'&gt;&lt;b:Value&gt;798110007&lt;/b:Value&gt;&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;new_sendmarketinginfo&lt;/c:key&gt; &lt;c:value i:type='b:OptionSetValue'&gt;&lt;b:Value&gt;100000001&lt;/b:Value&gt;&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;b:KeyValuePairOfstringanyType&gt; &lt;c:key&gt;new_grantprojecteligibility&lt;/c:key&gt; &lt;c:value i:type='b:OptionSetValue'&gt;&lt;b:Value&gt;100000000&lt;/b:Value&gt;&lt;/c:value&gt; &lt;/b:KeyValuePairOfstringanyType&gt;&lt;/b:Attributes&gt; &lt;b:EntityState i:nil='true'/&gt; &lt;b:FormattedValues xmlns:c='http://schemas.datacontract.org/2004/07/System.Collections.Generic'/&gt; &lt;b:Id&gt;00000000-0000-0000-0000-000000000000&lt;/b:Id&gt; &lt;b:LogicalName&gt;scy_webformrecord&lt;/b:LogicalName&gt; &lt;b:RelatedEntities xmlns:c='http://schemas.datacontract.org/2004/07/System.Collections.Generic'/&gt; &lt;/entity&gt; &lt;/Create&gt; &lt;/s:Body&gt; &lt;/s:Envelope&gt; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload