Results 1 to 1 of 1

Thread: set_entry for Accounts not working if use a number as id

  1. #1
    aroyzen is offline Sugar Community Member
    Join Date
    Mar 2008
    Posts
    15

    Default set_entry for Accounts not working if use a number as id

    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>
    Last edited by aroyzen; 2008-08-04 at 09:00 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 2008-05-29, 07:52 AM
  2. How to include the logged-in user's phone number in a module
    By philipmartinjones in forum Developer Help
    Replies: 2
    Last Post: 2008-03-07, 07:54 AM
  3. Replies: 3
    Last Post: 2008-01-20, 11:13 AM
  4. Replies: 1
    Last Post: 2006-11-10, 03:46 PM
  5. REQ: tracking number
    By Jeroen in forum General Discussion
    Replies: 3
    Last Post: 2005-03-31, 12:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •