java - SugarCRM访问被拒绝40号

我想从下面的活动中获取所有联系人，这是我对SugarCRM API v4的要求

{
   "session":"btcskfetq7sqshio3uv568d8c1",
   "module_name":"Contacts",
   "query":"contacts.id IN (
       SELECT opportunities_contacts.contact_id
       FROM opportunities_contacts
       JOIN opportunities
       ON opportunities_contacts.opportunity_id = opportunities.id
       WHERE opportunities.sales_stage
       NOT IN ('Closed Won','Closed Lost'))",
   "order_by":"",
   "offset":0,
   "select_fields":[
       "first_name",
       "last_name",
       "title",
       "phone_home",
       "phone_work",
       "status",
       "email"
   ],
  "link_name_to_fields_array":null,
  "max_results":0,
  "deleted":0,
  "favorites":false
}

我的查询在sugarCRM数据库的mysql工作台中工作正常，但API响应为：

{"name":"Access Denied","number":40,"description":"You do not have access"}

你能帮我吗？

最佳答案

为此，您需要在sugarcrm中编写自己的终点。

有关更多详细信息，请阅读：
Read me ...