如何通过 Sugar API 将行插入到 Accounts 表中
这是我尝试过的代码:
$result = $sugar['soapclient']->call(
'set_entry',
array(
'session'=>$sugar['session'],
'module_name'=>'Accounts',
array(
array("name" => 'id', "value" => $sugar_data['id']),
array("name" => 'name', "value" => $sugar_data['name']),
array("name" => 'description', "value" => $sugar_data['description']),
array("name" => 'team_id', "value" => $sugar_data['team_id']),
array("name" => 'team_set_id', "value" => $sugar_data['team_set_id']),
array("name" => 'phone_fax', "value" => $sugar_data['phone_fax']),
array("name" => 'billing_address_street', "value" => $sugar_data['address_street']),
array("name" => 'billing_address_city', "value" => $sugar_data['address_city']),
array("name" => 'billing_address_state', "value" => $sugar_data['address_state']),
array("name" => 'billing_address_postalcode', "value" => $sugar_data['address_postalcode']),
array("name" => 'billing_address_country', "value" => $sugar_data['address_country']),
array("name" => 'shipping_address_street', "value" => $sugar_data['address_street']),
array("name" => 'shipping_address_city', "value" => $sugar_data['address_city']),
array("name" => 'shipping_address_state', "value" => $sugar_data['address_state']),
array("name" => 'shipping_address_postalcode', "value" => $sugar_data['address_postalcode']),
array("name" => 'shipping_address_country', "value" => $sugar_data['address_country']),
array("name" => 'phone_office', "value" => $sugar_data['phone_work'])
)
)
);
但是,该行没有插入。我根据 ID 和 account_name 进行搜索,均返回 0 个结果。
谢谢!我真的很感谢您的帮助,因为这将在今天结束之前完成!
缺口
This is code I have tried:
$result = $sugar['soapclient']->call(
'set_entry',
array(
'session'=>$sugar['session'],
'module_name'=>'Accounts',
array(
array("name" => 'id', "value" => $sugar_data['id']),
array("name" => 'name', "value" => $sugar_data['name']),
array("name" => 'description', "value" => $sugar_data['description']),
array("name" => 'team_id', "value" => $sugar_data['team_id']),
array("name" => 'team_set_id', "value" => $sugar_data['team_set_id']),
array("name" => 'phone_fax', "value" => $sugar_data['phone_fax']),
array("name" => 'billing_address_street', "value" => $sugar_data['address_street']),
array("name" => 'billing_address_city', "value" => $sugar_data['address_city']),
array("name" => 'billing_address_state', "value" => $sugar_data['address_state']),
array("name" => 'billing_address_postalcode', "value" => $sugar_data['address_postalcode']),
array("name" => 'billing_address_country', "value" => $sugar_data['address_country']),
array("name" => 'shipping_address_street', "value" => $sugar_data['address_street']),
array("name" => 'shipping_address_city', "value" => $sugar_data['address_city']),
array("name" => 'shipping_address_state', "value" => $sugar_data['address_state']),
array("name" => 'shipping_address_postalcode', "value" => $sugar_data['address_postalcode']),
array("name" => 'shipping_address_country', "value" => $sugar_data['address_country']),
array("name" => 'phone_office', "value" => $sugar_data['phone_work'])
)
)
);
However, the row does not insert. I searched based on the ID and the account_name, and both returned 0 results.
Thanks! I really appreciate the help, as this is due for completion by the end of the day today!
Nick
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
我认为问题是您在数据中使用了“id”字段。在这种情况下,SugarCRM 尝试使用此特定 ID 更新帐户记录。如果您想使用自己的 id 创建帐户,您还应该在数组中添加此元素:
I think the problem is that you used "id" field in your data. In this case, SugarCRM try to update account record with this specific ID. If you want to create an account with you own id you should to add also this element in your array :
Web 服务的响应是什么?
尝试调试 Web 服务调用:
我还将尝试进行更简单的测试并验证其是否正常工作:
将自动创建 id。
What is the response from the web service?
Try to debug the web service call:
I would also try with a simpler test and verify it works properly:
The id will be created automatically.