根据条件查询退货单对象的列表
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": "ReturnedGoodsInvoiceObj"
}
}'响应示例响应示例
{
"traceId": "E-O.fktest188.1453-e2fc27b4198944ff",
"data": {
"dataList": [
{
"current_level": "0",
"account_id__r": "最少字段",
"UDAttach1__c": [],
"extend_obj_data_id": "r_o_590163_5cf767a71ed4a6000111cca5",
"created_by__r": {
"picAddr": "",
"description": "",
"dept": "1523",
"modifyTime": 1597335697485,
"post": "",
"createTime": 1559271081900,
"phone": "",
"name": "徐超",
"nickname": "徐超",
"tenantId": "590163",
"id": "1006",
"email": "",
"status": 0
},
"UDImg1__c": [],
"owner_department_id": "1000",
"owner_department": "董事会",
"UDSText2__c": "02",
"lock_status": "0",
"data_own_department__r": {
"deptName": "董事会",
"deptId": "1000",
"parentId": "999999",
"status": 0
},
"create_time": 1559717799679,
"submit_time": 1559717799511,
"UDCal1__c": "9.88",
"version": "18",
"created_by": [
"FSUID_0871DA62082216ECE103C16683E2FCDF"
],
"returned_goods_inv_amount": "0.00",
"relevant_team": [
{
"teamMemberEmployee": [
"FSUID_59F52A7BA9AA9FA8BAA6E59677EE4742"
],
"teamMemberRole": "1",
"teamMemberPermissionType": "2"
}
],
"data_own_department": [
"1000"
],
"name": "20190605-000002",
"_id": "5cf767a71ed4a6000111cca5",
"order_id": "5cf766ae7d30a7000183e1cc",
"data_own_department__l": [
{
"parentId": "999999",
"deptId": "1000",
"deptName": "董事会",
"status": 0
}
],
"status": "7",
"remark": "002测试",
"is_deleted": false,
"owner__l": [
{
"id": "1007",
"tenantId": "590163",
"name": "郑素兰",
"picAddr": "",
"email": "",
"nickname": "郑素兰",
"phone": "",
"description": "",
"status": 0,
"createTime": 1559530502800,
"modifyTime": 1573424747879,
"dept": "1000",
"post": ""
}
],
"order_id__relation_ids": "5cf766ae7d30a7000183e1cc",
"relevant_team__r": "郑素兰",
"UDMSel1__c": [],
"owner__r": {
"picAddr": "",
"description": "",
"dept": "1000",
"modifyTime": 1573424747879,
"post": "",
"createTime": 1559530502800,
"phone": "",
"name": "郑素兰",
"nickname": "郑素兰",
"tenantId": "590163",
"id": "1007",
"email": "",
"status": 0
},
"owner": [
"FSUID_59F52A7BA9AA9FA8BAA6E59677EE4742"
],
"last_modified_time": 1575268663615,
"life_status": "normal",
"last_modified_by__l": [
{
"id": "1006",
"tenantId": "590163",
"name": "徐超",
"picAddr": "",
"email": "",
"nickname": "徐超",
"phone": "",
"description": "",
"status": 0,
"createTime": 1559271081900,
"modifyTime": 1597335697485,
"dept": "1523",
"post": ""
}
],
"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": [
"FSUID_0871DA62082216ECE103C16683E2FCDF"
],
"record_type": "default__c",
"last_modified_by__r": {
"picAddr": "",
"description": "",
"dept": "1523",
"modifyTime": 1597335697485,
"post": "",
"createTime": 1559271081900,
"phone": "",
"name": "徐超",
"nickname": "徐超",
"tenantId": "590163",
"id": "1006",
"email": "",
"status": 0
},
"order_id__r": "20190605-000006",
"account_id": "ea163edf9d164625b7e319bd3f1519e9",
"account_id__relation_ids": "ea163edf9d164625b7e319bd3f1519e9",
"returned_goods_time": 1559717603000
},
{
"current_level": "0",
"account_id__r": "全字段测试",
"UDAttach1__c": [
{
"ext": "png",
"path": "98073dd7-691d-4739-ba0f-47f706f86ff6",
"filename": "微信截图_20190531174043.png",
"create_time": 1559303579397,
"size": 127577
}
],
"extend_obj_data_id": "r_o_590163_95c0d56ba1ea4d639514481a4a1f06f3",
"UDMoney1__c": "18.08",
"created_by__r": {
"picAddr": "",
"description": "",
"dept": "1523",
"modifyTime": 1597335697485,
"post": "",
"createTime": 1559271081900,
"phone": "",
"name": "徐超",
"nickname": "徐超",
"tenantId": "590163",
"id": "1006",
"email": "",
"status": 0
},
"UDImg1__c": [
{
"ext": "jpg",
"path": "25f99f29-2941-4b58-b821-7fd54f0c5e95"
}
],
"owner_department_id": "1523",
"owner_department": "李园园组",
"UDSText2__c": "04",
"lock_status": "0",
"data_own_department__r": {
"deptName": "董事会",
"deptId": "1000",
"parentId": "999999",
"status": 0
},
"create_time": 1559303424507,
"submit_time": 1559303424507,
"UDMail1__c": "57395789@qq.com",
"UDCal1__c": "9.88",
"UDCSSel1__c": "2",
"version": "2",
"created_by": [
"FSUID_0871DA62082216ECE103C16683E2FCDF"
],
"returned_goods_inv_amount": "2.05",
"relevant_team": [
{
"teamMemberEmployee": [
"FSUID_0871DA62082216ECE103C16683E2FCDF"
],
"teamMemberRole": "1",
"teamMemberPermissionType": "2"
}
],
"UDDec1__c": "12.08",
"returned_goods_reason": [
"2",
"3"
],
"data_own_department": [
"1000"
],
"name": "20190531-000004",
"UDSText1__c": "单行",
"UDDate1__c": 1556640000000,
"_id": "95c0d56ba1ea4d639514481a4a1f06f3",
"order_id": "73d2ec2bc95a4dd28cf816f4d6d1680f",
"data_own_department__l": [
{
"parentId": "999999",
"deptId": "1000",
"deptName": "董事会",
"status": 0
}
],
"status": "7",
"UDTel1__c": "18211565695",
"remark": "备注",
"lock_user": [
"0"
],
"UDInt1__c": "12",
"L1_UDCSSel1__c": "1",
"UDSSel1__c": "1",
"is_deleted": false,
"owner__l": [
{
"id": "1006",
"tenantId": "590163",
"name": "徐超",
"picAddr": "",
"email": "",
"nickname": "徐超",
"phone": "",
"description": "",
"status": 0,
"createTime": 1559271081900,
"modifyTime": 1597335697485,
"dept": "1523",
"post": ""
}
],
"order_id__relation_ids": "73d2ec2bc95a4dd28cf816f4d6d1680f",
"relevant_team__r": "徐超",
"UDMSel1__c": [
"1",
"2"
],
"owner__r": {
"picAddr": "",
"description": "",
"dept": "1523",
"modifyTime": 1597335697485,
"post": "",
"createTime": 1559271081900,
"phone": "",
"name": "徐超",
"nickname": "徐超",
"tenantId": "590163",
"id": "1006",
"email": "",
"status": 0
},
"owner": [
"FSUID_0871DA62082216ECE103C16683E2FCDF"
],
"last_modified_time": 1559303579127,
"UDMText1__c": "多行",
"life_status": "normal",
"last_modified_by__l": [
{
"id": "1006",
"tenantId": "590163",
"name": "徐超",
"picAddr": "",
"email": "",
"nickname": "徐超",
"phone": "",
"description": "",
"status": 0,
"createTime": 1559271081900,
"modifyTime": 1597335697485,
"dept": "1523",
"post": ""
}
],
"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": [
"FSUID_0871DA62082216ECE103C16683E2FCDF"
],
"record_type": "default__c",
"last_modified_by__r": {
"picAddr": "",
"description": "",
"dept": "1523",
"modifyTime": 1597335697485,
"post": "",
"createTime": 1559271081900,
"phone": "",
"name": "徐超",
"nickname": "徐超",
"tenantId": "590163",
"id": "1006",
"email": "",
"status": 0
},
"order_id__r": "20190531-000008",
"account_id": "8ca9c2c811054c13921c6bf2a137474e",
"account_id__relation_ids": "8ca9c2c811054c13921c6bf2a137474e"
}
],
"offset": 0,
"limit": 2,
"total": 3
},
"errorDescription": "success",
"errorMessage": "OK",
"errorCode": 0
}请求参数
Body 参数application/json
返回响应
扫码加入交流群