[Vtigercrm-developers] creating potentials through webservice gives database error

[lucia digirolamo]

Hi,

yes, they are correct: if I $client->doRetrieve('3x95460') I get the 
organization I want and if I $client->doRetrieve('4x97106') I get the 
correct contact info.

I retrieved an existing potential, got the assigned_user_id, and used 
the same id for my test but I get the same error message 
(DATABASE_QUERY_ERROR:LBL_DATABASE_QUERY_ERROR).

I noticed also a [creator_user_id]  with same id as the 
assigned_user_id, so I added this field to my test too. But 
unfortunately result is still the same.

On 30/03/2016 11:52, Alan Lord wrote:
> On 30/03/16 10:46, lucia digirolamo wrote:
>
>> $recorddata = array(
>>          'potentialname' => 'test',
>>          'related_to' => '3x95460', // (moduleId x recordId) such as
>> 3x95460
>>          'closingdate' => date('Y-m-d'),
>>          'sales_stage' => 'Closed Lost',
>>          'amount' => '2000',
>>          'contact_id'=>'4x97106',
>>      );
>
>
> Are your wsids correct? "3" in some of my systems is for the FAQ 
> module and "4" is for Quotes. Check your table vtiger_ws_entity - 
> these are *not* the same as the tabid.
>
>
> Also you have no assigned_user_id field - which is _always_ mandatory.
>
> Al
>
>
> _______________________________________________
> http://www.vtiger.com/
>