根据条件查询商机对象的列表
POST
https://open.fxiaoke.com/cgi/crm/v2/data/query
接口说明：根据条件查询商机对象的列表
operator参数说明
此接口对应的返回值即为对象相关字段，详情见关于商机对象字段的说明下列参数为本接口特有返回值 返回错误代码请参见。全局返回错误码
| 参数 | 参数含义 | 参数 | 参数含义 |
|---|---|---|---|
| EQ | = | GT | > |
| LT | < | GTE | >= |
| LTE | <= | N | <> |
| LIKE | LIKE | NLIKE | NOT LIKE |
| IS | IS | ISN | IS NOT |
| IN | IN | NIN | NOT IN |
| BETWEEN | BETWEEN | NBETWEEN | NOT BETWEEN |
| STARTWITH | LIKE% | ENDWITH | %LIKE |
| CONTAINS | Array 包含 |
请求示例请求示例
Shell
JavaScript
Java
Swift
curl --location --request POST 'https://open.fxiaoke.com/cgi/crm/v2/data/query' \
--header 'Content-Type: application/json' \
--data-raw '{
"corpAccessToken": "${corpAccessToken}",
"corpId": "${corpId}",
"currentOpenUserId": "${currentOpenUserId}",
"data": {
"search_query_info": {
"offset": 0,
"limit": 2,
"filters": []
},
"dataObjectApiName": "OpportunityObj"
}
}'响应示例响应示例
{
"traceId": "E-O.fktest188.1453-651be9884edc4a4f",
"data": {
"dataList": [
{
"sales_stg_changed_time": 1588040003479,
"before_sale_stage_count": 5,
"after_sale_stage_order": 0,
"account_id__r": "新建客户",
"UDAttach1__c": [],
"expected_deal_closed_date": 1585929600000,
"extend_obj_data_id": "o_t_590163_5ea6c76a442fcc00017ef9fe",
"created_by__r": {
"picAddr": "",
"description": "",
"dept": "1000",
"supervisorId": "1006",
"modifyTime": 1591759818876,
"post": "",
"createTime": 1587462141009,
"phone": "",
"name": "蒋小川1",
"nickname": "蒋小川1",
"tenantId": "590163",
"id": "1453",
"email": "",
"status": 0
},
"oppo_stage_id": "41a5807ad840477faa255bd50a65da5d",
"UDImg1__c": [],
"owner_department_id": "1000",
"owner_department": "董事会",
"UDSText2__c": "16",
"after_stage_stay_time": 0,
"source_sale_action_stage_name": "",
"sales_process_name": "销售流程带售后",
"target_sale_stage_order": 0,
"biz_status": "running",
"lock_status": "0",
"data_own_department__r": {
"deptName": "董事会",
"deptId": "1000",
"parentId": "999999",
"status": 0
},
"create_time": 1587988330715,
"probability": "30",
"UDCal1__c": "hello",
"is_start_after_sale": false,
"last_followed_time": 1588040003419,
"version": "14",
"created_by": [
"FSUID_CBF443F942C4ABE8A46BE859066A5CD1"
],
"relevant_team": [
{
"teamMemberEmployee": [
"FSUID_CBF443F942C4ABE8A46BE859066A5CD1"
],
"teamMemberRole": "1",
"teamMemberPermissionType": "2"
}
],
"data_own_department": [
"1000"
],
"name": "小川测试商机",
"_id": "5ea6c76a442fcc00017ef9fe",
"sales_process_id": "58a7245f994f4931a9486387129c7f98",
"data_own_department__l": [
{
"parentId": "999999",
"deptId": "1000",
"deptName": "董事会",
"status": 0
}
],
"after_sale_stage_count": 0,
"status": "1",
"source_sale_action_stage_id": "",
"after_sale_stage_status": "0",
"after_sale_stage_name": "未开启",
"source_sale_action_stage_order": 0,
"is_bind_after_sale": true,
"is_deleted": false,
"owner__l": [
{
"id": "1453",
"tenantId": "590163",
"name": "蒋小川1",
"picAddr": "",
"email": "",
"nickname": "蒋小川1",
"supervisorId": "1006",
"phone": "",
"description": "",
"status": 0,
"createTime": 1587462141009,
"modifyTime": 1591759818876,
"dept": "1000",
"post": ""
}
],
"relevant_team__r": "蒋小川1",
"probability_amount": "30.00",
"owner__r": {
"picAddr": "",
"description": "",
"dept": "1000",
"supervisorId": "1006",
"modifyTime": 1591759818876,
"post": "",
"createTime": 1587462141009,
"phone": "",
"name": "蒋小川1",
"nickname": "蒋小川1",
"tenantId": "590163",
"id": "1453",
"email": "",
"status": 0
},
"owner": [
"FSUID_CBF443F942C4ABE8A46BE859066A5CD1"
],
"expected_deal_amount": "100.00",
"last_modified_time": 1588040003776,
"oppo_after_stage_id": "daaf7977d1104421b9f0c38c25e55955",
"target_sale_action_stage_name": "",
"life_status": "normal",
"last_modified_by__l": [
{
"id": "-10000",
"name": "系统"
}
],
"target_sale_action_stage_id": "",
"created_by__l": [
{
"id": "1453",
"tenantId": "590163",
"name": "蒋小川1",
"picAddr": "",
"email": "",
"nickname": "蒋小川1",
"supervisorId": "1006",
"phone": "",
"description": "",
"status": 0,
"createTime": 1587462141009,
"modifyTime": 1591759818876,
"dept": "1000",
"post": ""
}
],
"last_modified_by": [
"-10000"
],
"record_type": "record_iVz20__c",
"before_sale_stage_order": 2,
"last_modified_by__r": {
"name": "系统",
"id": "-10000"
},
"account_id": "5e9f0cd09acb9c0001d7236e",
"account_id__relation_ids": "5e9f0cd09acb9c0001d7236e",
"before_sale_stage_name": "需求确定",
"target_opportunity_status": 0
},
{
"lock_rule": "default_lock_rule",
"sales_stg_changed_time": 1573482677279,
"before_sale_stage_count": 5,
"after_sale_stage_order": 0,
"account_id__r": "全字段测试",
"expected_deal_closed_date": 1559143400000,
"extend_obj_data_id": "o_t_590163_5d00e1263e5cc5000102dfd7",
"created_by__r": {
"picAddr": "",
"description": "",
"dept": "1523",
"modifyTime": 1597335697485,
"post": "",
"createTime": 1559271081900,
"phone": "",
"name": "徐超",
"nickname": "徐超",
"tenantId": "590163",
"id": "1006",
"email": "",
"status": 0
},
"oppo_stage_id": "b78db3ca578c403e9a6b8852ee3ecbaa",
"owner_department_id": "1523",
"owner_department": "李园园组",
"UDSText2__c": "10",
"after_stage_stay_time": 0,
"source_sale_action_stage_name": "",
"sales_process_name": "销售流程",
"target_sale_stage_order": 0,
"biz_status": "win",
"lock_status": "0",
"data_own_department__r": {
"deptName": "董事会",
"deptId": "1000",
"parentId": "999999",
"status": 0
},
"create_time": 1560338726797,
"probability": "100",
"UDCal1__c": "hello",
"is_start_after_sale": false,
"lock_user__l": [
{
"id": "-10000",
"name": "系统"
}
],
"last_followed_time": 1573482677192,
"version": "27",
"created_by": [
"FSUID_0871DA62082216ECE103C16683E2FCDF"
],
"relevant_team": [
{
"teamMemberEmployee": [
"FSUID_0871DA62082216ECE103C16683E2FCDF"
],
"teamMemberRole": "1",
"teamMemberPermissionType": "2"
}
],
"data_own_department": [
"1000"
],
"lock_user__r": {
"name": "系统",
"id": "-10000"
},
"name": "测试触发流程传true",
"_id": "5d00e1263e5cc5000102dfd7",
"sales_process_id": "4595686b883b49fe9f05ae748e268c88",
"data_own_department__l": [
{
"parentId": "999999",
"deptId": "1000",
"deptName": "董事会",
"status": 0
}
],
"after_sale_stage_count": 0,
"status": "2",
"source_sale_action_stage_id": "",
"after_sale_stage_status": "0",
"after_sale_stage_name": "未开启",
"source_sale_action_stage_order": 0,
"lock_user": [
"-10000"
],
"is_bind_after_sale": true,
"is_deleted": false,
"owner__l": [
{
"id": "1006",
"tenantId": "590163",
"name": "徐超",
"picAddr": "",
"email": "",
"nickname": "徐超",
"phone": "",
"description": "",
"status": 0,
"createTime": 1559271081900,
"modifyTime": 1597335697485,
"dept": "1523",
"post": ""
}
],
"relevant_team__r": "徐超",
"probability_amount": "80.00",
"owner__r": {
"picAddr": "",
"description": "",
"dept": "1523",
"modifyTime": 1597335697485,
"post": "",
"createTime": 1559271081900,
"phone": "",
"name": "徐超",
"nickname": "徐超",
"tenantId": "590163",
"id": "1006",
"email": "",
"status": 0
},
"owner": [
"FSUID_0871DA62082216ECE103C16683E2FCDF"
],
"expected_deal_amount": "80.00",
"last_modified_time": 1573482677337,
"oppo_after_stage_id": "32224b34404344a8a5bfc85fa0253acc",
"target_sale_action_stage_name": "",
"life_status": "normal",
"last_modified_by__l": [
{
"id": "-10000",
"name": "系统"
}
],
"target_sale_action_stage_id": "",
"created_by__l": [
{
"id": "1006",
"tenantId": "590163",
"name": "徐超",
"picAddr": "",
"email": "",
"nickname": "徐超",
"phone": "",
"description": "",
"status": 0,
"createTime": 1559271081900,
"modifyTime": 1597335697485,
"dept": "1523",
"post": ""
}
],
"last_modified_by": [
"-10000"
],
"record_type": "default__c",
"before_sale_stage_order": 5,
"last_modified_by__r": {
"name": "系统",
"id": "-10000"
},
"account_id": "8ca9c2c811054c13921c6bf2a137474e",
"account_id__relation_ids": "8ca9c2c811054c13921c6bf2a137474e",
"before_sale_stage_name": "赢单",
"target_opportunity_status": 0
}
],
"offset": 0,
"limit": 2,
"total": 18
},
"errorDescription": "success",
"errorMessage": "OK",
"errorCode": 0
}请求参数
Body 参数application/json
返回响应
扫码加入交流群