I have community edition SugarCE patch 5.0.0a and I try to add an account using SOAP API set_entry method. We added some custom fields to the Accounts module. When I use my request without an id both accounts and and accounts_cstm tables are populated, also if I provide an existing id the records in both files are updated, only if I use a number as an id and try to create an account using the same request having the id as a number, only accounts_cstm table is populated. I would like to use as an id for accounts a number that would represent our customers from an ERP system .
I test the SOAP API using SOAPUI and operations that I tryed work fine, this one is the only problem I have so far.
Here is a copy of my SOAP request:
<soapenv:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:sug="http://www.sugarcrm.com/sugarcrm" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/">
<soapenv:Header/>
<soapenv:Body>
<sug:set_entry soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<session xsi:type="xsd:string">e3jmbk2q52t24aru8trtsnc143</session>
<module_name xsi:type="xsd:string">Accounts</module_name>
<name_value_list xsi:type="SOAP-ENC:Array" SOAP-ENC:arrayType="tns:name_value[13]">
<item xsi:type="tns:name_value">
<name xsi:type="xsd:string">modified_by_name</name>
<value xsi:type="xsd:string">admin</value>
</item>
<item xsi:type="tns:name_value">
<name xsi:type="xsd:string">created_by_name</name>
<value xsi:type="xsd:string">admin</value>
</item>
<item xsi:type="tns:name_value">
<name xsi:type="xsd:string">id</name>
<value xsi:type="xsd:string">60331</value>
</item>
<item xsi:type="tns:name_value">
<name xsi:type="xsd:string">name</name>
<value xsi:type="xsd:string">Marsh Jean</value>
</item>
<item xsi:type="tns:name_value">
<name xsi:type="xsd:string">date_entered</name>
<value xsi:type="xsd:string">2008-06-11 17:22:33</value>
</item>
<item xsi:type="tns:name_value">
<name xsi:type="xsd:string">date_modified</name>
<value xsi:type="xsd:string">2008-06-11 17:22:33</value>
</item>
<item xsi:type="tns:name_value">
<name xsi:type="xsd:string">modified_user_id</name>
<value xsi:type="xsd:string">admin</value>
</item>
<item xsi:type="tns:name_value">
<name xsi:type="xsd:string">created_by</name>
<value xsi:type="xsd:string">admin</value>
</item>
<item xsi:type="tns:name_value">
<name xsi:type="xsd:string">deleted</name>
<value xsi:type="xsd:string">0</value>
</item>
<item xsi:type="tns:name_value">
<name xsi:type="xsd:string">membershipno_c</name>
<value xsi:type="xsd:string">00T999999</value>
</item>
<item xsi:type="tns:name_value">
<name xsi:type="xsd:string">firstname_c</name>
<value xsi:type="xsd:string">Marsh</value>
</item>
<item xsi:type="tns:name_value">
<name xsi:type="xsd:string">lastname_c</name>
<value xsi:type="xsd:string">Jean</value>
</item>
<item xsi:type="tns:name_value">
<name xsi:type="xsd:string">ptysgt_c</name>
<value xsi:type="xsd:string">99999</value>
</item>
</name_value_list>
</sug:set_entry>
</soapenv:Body>
</soapenv:Envelope>


LinkBack URL
About LinkBacks



Reply With Quote
Bookmarks