根据条件查询行为记录对象的列表
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": {
"dataObjectApiName": "BehaviorRecordObj",
"search_query_info": {
"limit": 100,
"offset": 0,
"filters": [
{
"field_name": "name",
"field_values": [
"ccccxxxxx"
],
"operator": "EQ"
}
],
"orders": [
{
"fieldName": "create_time",
"isAsc": false
}
]
}
}
}'响应示例响应示例
{
"traceId": "E-O.fktest188.1453-047a9a6d9e9642f8",
"data": {
"dataList": [
{
"account_no": "的撒打算",
"life_status_before_invalid": "normal",
"owner_department_id": "1000",
"UDSText2__c": "135",
"UDAgg1__c": "0",
"biz_status": "allocated",
"data_own_department__r": {
"deptName": "董事会",
"deptId": "1000",
"parentId": "999999",
"status": 0
},
"version": "6",
"is_duplicated": false,
"data_own_department__l": [
{
"parentId": "999999",
"deptId": "1000",
"deptName": "董事会",
"status": 0
}
],
"is_er_enterprise": false,
"deal_status": "2",
"address": "实打实打算",
"last_modified_time": 1597283098732,
"life_status": "invalid",
"transfer_count": "1",
"biz_reg_name": false,
"field_Eaml1__c": "CRM",
"account_status": "99",
"last_deal_closed_time": 1595815254900,
"completed_field_quantity": "39",
"extend_obj_data_id": "cus_590163_5f197321d5935a0001497394",
"created_by__r": {
"picAddr": "N_202103_09_48d7a353b35c41fd9a55d34c1863d84d",
"description": "",
"dept": "1000",
"supervisorId": "1006",
"modifyTime": 1615281111732,
"post": "",
"createTime": 1587462141009,
"phone": "",
"name": "文本值",
"nickname": "文本值",
"tenantId": "590163",
"id": "1453",
"email": "",
"status": 0
},
"pin_yin": "ccccxxxxx",
"owner_department": "董事会",
"lock_status": "0",
"create_time": 1595503393771,
"UDCal1__c": "88.00",
"last_followed_time": 1597220601805,
"created_by": [
"FSUID_CBF443F942C4ABE8A46BE859066A5CD1"
],
"relevant_team": [
{
"teamMemberEmployee": [
"FSUID_CBF443F942C4ABE8A46BE859066A5CD1"
],
"teamMemberRole": "1",
"teamMemberPermissionType": "2"
}
],
"remaining_time": "",
"data_own_department": [
"1000"
],
"name": "ccccxxxxx",
"_id": "5f197321d5935a0001497394",
"account_level": "1",
"is_deleted": true,
"owner__l": [
{
"id": "1453",
"tenantId": "590163",
"name": "文本值",
"picAddr": "N_202103_09_48d7a353b35c41fd9a55d34c1863d84d",
"email": "",
"nickname": "文本值",
"supervisorId": "1006",
"phone": "",
"description": "",
"status": 0,
"createTime": 1587462141009,
"modifyTime": 1615281111732,
"dept": "1000",
"post": ""
}
],
"relevant_team__r": "文本值",
"owner__r": {
"picAddr": "N_202103_09_48d7a353b35c41fd9a55d34c1863d84d",
"description": "",
"dept": "1000",
"supervisorId": "1006",
"modifyTime": 1615281111732,
"post": "",
"createTime": 1587462141009,
"phone": "",
"name": "文本值",
"nickname": "文本值",
"tenantId": "590163",
"id": "1453",
"email": "",
"status": 0
},
"owner": [
"FSUID_CBF443F942C4ABE8A46BE859066A5CD1"
],
"last_modified_by__l": [
{
"id": "1453",
"tenantId": "590163",
"name": "文本值",
"picAddr": "N_202103_09_48d7a353b35c41fd9a55d34c1863d84d",
"email": "",
"nickname": "文本值",
"supervisorId": "1006",
"phone": "",
"description": "",
"status": 0,
"createTime": 1587462141009,
"modifyTime": 1615281111732,
"dept": "1000",
"post": ""
}
],
"created_by__l": [
{
"id": "1453",
"tenantId": "590163",
"name": "文本值",
"picAddr": "N_202103_09_48d7a353b35c41fd9a55d34c1863d84d",
"email": "",
"nickname": "文本值",
"supervisorId": "1006",
"phone": "",
"description": "",
"status": 0,
"createTime": 1587462141009,
"modifyTime": 1615281111732,
"dept": "1000",
"post": ""
}
],
"last_modified_by": [
"FSUID_CBF443F942C4ABE8A46BE859066A5CD1"
],
"record_type": "default__c",
"last_modified_by__r": {
"picAddr": "N_202103_09_48d7a353b35c41fd9a55d34c1863d84d",
"description": "",
"dept": "1000",
"supervisorId": "1006",
"modifyTime": 1615281111732,
"post": "",
"createTime": 1587462141009,
"phone": "",
"name": "文本值",
"nickname": "文本值",
"tenantId": "590163",
"id": "1453",
"email": "",
"status": 0
},
"owner_modified_time": 1595503393640
}
],
"offset": 0,
"limit": 100,
"total": 1
},
"errorDescription": "success",
"errorMessage": "OK",
"errorCode": 0
}请求参数
Body 参数application/json
返回响应
扫码加入交流群