根据条件查询报价单明细对象的列表
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": "QuoteLinesObj"
}
}'
响应示例响应示例
{
"traceId": "E-O.fktest188.1453-e50236243b0b4ab8",
"data": {
"dataList": [
{
"price_book_product_id__r": "PBProdCode20190706000059",
"price_book_product_id": "5d1f8a80ea516c0001e8b955590163",
"created_by__r": {
"picAddr": "",
"description": "",
"dept": "1523",
"modifyTime": 1597335697485,
"post": "",
"createTime": 1559271081900,
"phone": "",
"name": "徐超",
"nickname": "徐超",
"tenantId": "590163",
"id": "1006",
"email": "",
"status": 0
},
"product_id": "5d1f8a80ea516c0001e8b955",
"owner_department_id": "1523",
"owner_department": "李园园组",
"quote_lines_unit": "打1",
"lock_status": "0",
"data_own_department__r": {
"deptName": "董事会",
"deptId": "1000",
"parentId": "999999",
"status": 0
},
"create_time": 1582614111978,
"quote_id": "5d2bfaade56abe00018947c1",
"quote_id__relation_ids": "5d2bfaade56abe00018947c1",
"version": "1",
"created_by": [
"FSUID_0871DA62082216ECE103C16683E2FCDF"
],
"data_own_department": [
"1000"
],
"quote_id__r": "201907150000000003",
"name": "QuoteLinesCode-20200225000026",
"_id": "5e54c65f98f016000163ff55",
"data_own_department__l": [
{
"parentId": "999999",
"deptId": "1000",
"deptName": "董事会",
"status": 0
}
],
"total_discount": "100.0000",
"quote_lines_specs": "",
"product_id__r": "004我是谁",
"quote_lines_unit__r": "打1",
"product_id__relation_ids": "5d1f8a80ea516c0001e8b955",
"is_deleted": false,
"quote_lines_unit__v": "47gGKOqL",
"owner__l": [
{
"id": "1006",
"tenantId": "590163",
"name": "徐超",
"picAddr": "",
"email": "",
"nickname": "徐超",
"phone": "",
"description": "",
"status": 0,
"createTime": 1559271081900,
"modifyTime": 1597335697485,
"dept": "1523",
"post": ""
}
],
"price_book_product_id__relation_ids": "5d1f8a80ea516c0001e8b955590163",
"owner__r": {
"picAddr": "",
"description": "",
"dept": "1523",
"modifyTime": 1597335697485,
"post": "",
"createTime": 1559271081900,
"phone": "",
"name": "徐超",
"nickname": "徐超",
"tenantId": "590163",
"id": "1006",
"email": "",
"status": 0
},
"owner": [
"FSUID_0871DA62082216ECE103C16683E2FCDF"
],
"quantity": "3",
"last_modified_time": 1582614111978,
"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
},
"sales_price": "22.00"
},
{
"price_book_product_id__r": "PBProdCode20191010000063",
"price_book_product_id": "5d9e09dc6a631000019e0c4d590163",
"created_by__r": {
"picAddr": "",
"description": "",
"dept": "1523",
"modifyTime": 1597335697485,
"post": "",
"createTime": 1559271081900,
"phone": "",
"name": "徐超",
"nickname": "徐超",
"tenantId": "590163",
"id": "1006",
"email": "",
"status": 0
},
"product_id": "5d9e09dc6a631000019e0c4d",
"owner_department_id": "1523",
"owner_department": "李园园组",
"quote_lines_unit": "看",
"lock_status": "0",
"data_own_department__r": {
"deptName": "董事会",
"deptId": "1000",
"parentId": "999999",
"status": 0
},
"create_time": 1582603894960,
"quote_id": "5d2bfaade56abe00018947c1",
"quote_id__relation_ids": "5d2bfaade56abe00018947c1",
"version": "1",
"created_by": [
"FSUID_0871DA62082216ECE103C16683E2FCDF"
],
"data_own_department": [
"1000"
],
"quote_id__r": "201907150000000003",
"name": "QuoteLinesCode-20200225000025",
"_id": "5e549e76ac18140001bc451c",
"data_own_department__l": [
{
"parentId": "999999",
"deptId": "1000",
"deptName": "董事会",
"status": 0
}
],
"total_discount": "100.0000",
"quote_lines_specs": "",
"product_id__r": "随机数据名称_1590567645468",
"quote_lines_unit__r": "看",
"product_id__relation_ids": "5d9e09dc6a631000019e0c4d",
"is_deleted": false,
"quote_lines_unit__v": "QZWX7oyr",
"owner__l": [
{
"id": "1006",
"tenantId": "590163",
"name": "徐超",
"picAddr": "",
"email": "",
"nickname": "徐超",
"phone": "",
"description": "",
"status": 0,
"createTime": 1559271081900,
"modifyTime": 1597335697485,
"dept": "1523",
"post": ""
}
],
"price_book_product_id__relation_ids": "5d9e09dc6a631000019e0c4d590163",
"owner__r": {
"picAddr": "",
"description": "",
"dept": "1523",
"modifyTime": 1597335697485,
"post": "",
"createTime": 1559271081900,
"phone": "",
"name": "徐超",
"nickname": "徐超",
"tenantId": "590163",
"id": "1006",
"email": "",
"status": 0
},
"owner": [
"FSUID_0871DA62082216ECE103C16683E2FCDF"
],
"quantity": "1",
"last_modified_time": 1582603894960,
"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
},
"sales_price": "22.00"
}
],
"offset": 0,
"limit": 2,
"total": 26
},
"errorDescription": "success",
"errorMessage": "OK",
"errorCode": 0
}
请求参数
Body 参数application/json