如何通过 Sugar API 将行插入到 Accounts 表中

发布于 2024-12-07 16:43:37 字数 1950 浏览 5 评论 0原文

这是我尝试过的代码:

$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 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(2

坏尐絯℡ 2024-12-14 16:43:37

我认为问题是您在数据中使用了“id”字段。在这种情况下,SugarCRM 尝试使用此特定 ID 更新帐户记录。如果您想使用自己的 id 创建帐户,您还应该在数组中添加此元素:

array( 
    'name' => 'new_with_id',
    'value' => 1,
), 

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 :

array( 
    'name' => 'new_with_id',
    'value' => 1,
), 
心碎的声音 2024-12-14 16:43:37

Web 服务的响应是什么?

尝试调试 Web 服务调用:

  • 查看 Web 服务器日志(调用是否通过)
  • 启用 SugarCRM 日志记录并将级别设置为调试
  • 启用 PHP 错误输出或使 PHP 将错误记录到日志文件
  • 使用例如 SoapUI 进行测试SOAP 调用
  • 请参阅 SugarFullTest_Version2.php 在哪里? (Sugar CRM 和 SOAP) 了解更全面的 SOAP 示例
  • 查看 SugarCRM SOAP 文档

我还将尝试进行更简单的测试并验证其是否正常工作:

$info = $soapClient->set_entry(
    $session,
    'Accounts',
    array(
        array('name' => 'name', 'value' => 'Test account'),
        array('name' => 'description', 'value' => 'This is a test account'),
        )
    );
}

将自动创建 id。

What is the response from the web service?

Try to debug the web service call:

  • Look in the web server log (Is the call getting through)
  • Enable the SugarCRM logging and set the level to debug
  • Either enable PHP error output or make PHP log errors to a log file
  • Use e.g. SoapUI to test SOAP call
  • See Where is SugarFullTest_Version2.php? (Sugar CRM and SOAP) for a more thorough SOAP example
  • Check the SugarCRM SOAP documentation

I would also try with a simpler test and verify it works properly:

$info = $soapClient->set_entry(
    $session,
    'Accounts',
    array(
        array('name' => 'name', 'value' => 'Test account'),
        array('name' => 'description', 'value' => 'This is a test account'),
        )
    );
}

The id will be created automatically.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文