根据条件查询预存款对象的列表
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": "PrepayDetailObj"
}
}'响应示例响应示例
{
"errorCode": 0,
"errorMessage": "OK",
"errorDescription": "success",
"data": {
"total": 2,
"offset": 0,
"dataList": [
{
"lock_rule": "default_lock_rule",
"created_by__r": {
"picAddr": "",
"description": "",
"dept": "999998",
"modifyTime": 1610363068293,
"post": "",
"createTime": 1595316415220,
"phone": "",
"name": "a11",
"nickname": "a11",
"tenantId": "80736",
"id": "1000",
"email": "",
"status": 0
},
"owner_department_id": "999998",
"owner_department": "待分配",
"lock_status": "1",
"data_own_department__r": {
"deptName": "待分配",
"deptId": "999998",
"parentId": "999999",
"status": 0
},
"create_time": 1614758242468,
"lock_user__l": [
{
"id": "-10000",
"name": "系统"
}
],
"version": "3",
"created_by": [
"FSUID_D6F7B32923488D997590E93B8F47CA10"
],
"relevant_team": [
{
"teamMemberEmployee": [
"FSUID_D6F7B32923488D997590E93B8F47CA10"
],
"teamMemberRole": "1",
"teamMemberPermissionType": "2"
}
],
"data_own_department": [
"999998"
],
"lock_user__r": {
"name": "系统",
"id": "-10000"
},
"name": "PT2021-03-03_0002",
"outcome_type": "1",
"_id": "603f4162d549680001718355",
"customer_account_id": "5fa4efa7b78ec500011d405f",
"data_own_department__l": [
{
"parentId": "999999",
"deptId": "999998",
"deptName": "待分配",
"status": 0
}
],
"lock_user": [
"-10000"
],
"is_deleted": false,
"customer_account_id__relation_ids": "5fa4efa7b78ec500011d405f",
"income_type": "8",
"owner__l": [
{
"id": "1000",
"tenantId": "80736",
"name": "a11",
"picAddr": "",
"email": "",
"nickname": "a11",
"phone": "",
"description": "",
"status": 0,
"createTime": 1595316415220,
"modifyTime": 1610363068293,
"dept": "999998",
"post": ""
}
],
"transaction_time": 1614700800000,
"relevant_team__r": "a11",
"customer_account_id__r": "CA2020-11-06_0002",
"owner__r": {
"picAddr": "",
"description": "",
"dept": "999998",
"modifyTime": 1610363068293,
"post": "",
"createTime": 1595316415220,
"phone": "",
"name": "a11",
"nickname": "a11",
"tenantId": "80736",
"id": "1000",
"email": "",
"status": 0
},
"owner": [
"FSUID_D6F7B32923488D997590E93B8F47CA10"
],
"amount": "0.00",
"last_modified_time": 1614758244839,
"life_status": "under_review",
"last_modified_by__l": [
{
"id": "-10000",
"name": "系统"
}
],
"created_by__l": [
{
"id": "1000",
"tenantId": "80736",
"name": "a11",
"picAddr": "",
"email": "",
"nickname": "a11",
"phone": "",
"description": "",
"status": 0,
"createTime": 1595316415220,
"modifyTime": 1610363068293,
"dept": "999998",
"post": ""
}
],
"last_modified_by": [
"-10000"
],
"record_type": "default__c",
"last_modified_by__r": {
"name": "系统",
"id": "-10000"
},
"customer_id__r": "wsh",
"customer_id__relation_ids": "5fa4efa6d6c0d90001ddf905",
"customer_id": "5fa4efa6d6c0d90001ddf905"
},
{
"lock_rule": "default_lock_rule",
"created_by__r": {
"picAddr": "",
"description": "",
"dept": "999998",
"modifyTime": 1610363068293,
"post": "",
"createTime": 1595316415220,
"phone": "",
"name": "a11",
"nickname": "a11",
"tenantId": "80736",
"id": "1000",
"email": "",
"status": 0
},
"owner_department_id": "999998",
"owner_department": "待分配",
"lock_status": "1",
"data_own_department__r": {
"deptName": "待分配",
"deptId": "999998",
"parentId": "999999",
"status": 0
},
"create_time": 1614758218910,
"lock_user__l": [
{
"id": "-10000",
"name": "系统"
}
],
"version": "3",
"created_by": [
"FSUID_D6F7B32923488D997590E93B8F47CA10"
],
"relevant_team": [
{
"teamMemberEmployee": [
"FSUID_D6F7B32923488D997590E93B8F47CA10"
],
"teamMemberRole": "1",
"teamMemberPermissionType": "2"
}
],
"data_own_department": [
"999998"
],
"lock_user__r": {
"name": "系统",
"id": "-10000"
},
"name": "PT2021-03-03_0001",
"outcome_type": "1",
"_id": "603f414ad549680001718184",
"customer_account_id": "5fa4efa7b78ec500011d405f",
"data_own_department__l": [
{
"parentId": "999999",
"deptId": "999998",
"deptName": "待分配",
"status": 0
}
],
"lock_user": [
"-10000"
],
"is_deleted": false,
"customer_account_id__relation_ids": "5fa4efa7b78ec500011d405f",
"income_type": "8",
"owner__l": [
{
"id": "1000",
"tenantId": "80736",
"name": "a11",
"picAddr": "",
"email": "",
"nickname": "a11",
"phone": "",
"description": "",
"status": 0,
"createTime": 1595316415220,
"modifyTime": 1610363068293,
"dept": "999998",
"post": ""
}
],
"transaction_time": 1614700800000,
"relevant_team__r": "a11",
"customer_account_id__r": "CA2020-11-06_0002",
"owner__r": {
"picAddr": "",
"description": "",
"dept": "999998",
"modifyTime": 1610363068293,
"post": "",
"createTime": 1595316415220,
"phone": "",
"name": "a11",
"nickname": "a11",
"tenantId": "80736",
"id": "1000",
"email": "",
"status": 0
},
"owner": [
"FSUID_D6F7B32923488D997590E93B8F47CA10"
],
"amount": "0.00",
"last_modified_time": 1614758222178,
"life_status": "under_review",
"last_modified_by__l": [
{
"id": "-10000",
"name": "系统"
}
],
"created_by__l": [
{
"id": "1000",
"tenantId": "80736",
"name": "a11",
"picAddr": "",
"email": "",
"nickname": "a11",
"phone": "",
"description": "",
"status": 0,
"createTime": 1595316415220,
"modifyTime": 1610363068293,
"dept": "999998",
"post": ""
}
],
"last_modified_by": [
"-10000"
],
"record_type": "default__c",
"last_modified_by__r": {
"name": "系统",
"id": "-10000"
},
"customer_id__r": "wsh",
"customer_id__relation_ids": "5fa4efa6d6c0d90001ddf905",
"customer_id": "5fa4efa6d6c0d90001ddf905"
}
],
"limit": 2
},
"traceId": "E-O.80736.1000-5e65170f45814490-00303"
}请求参数
Body 参数application/json
返回响应
扫码加入交流群