根据条件查询序列号对象的列表
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": "CORP_ACCESS_TOKEN",
"corpId": "CORP_ID",
"currentOpenUserId": "FSUID_XXXXXX",
"data": {
"dataObjectApiName": "SerialNumberObj",
"search_query_info": {
"limit": 5,
"offset": 0,
"filters": [
{
"field_name": "owner",
"field_values": [
"FSUID_7B8A3925E40FA68630C0D7E9C3XXXXXX"
],
"operator": "IN"
}
],
"orders": [
{
"fieldName": "payment_amount",
"isAsc": false
}
],
"fieldProjection": ["_id","name"]
}
}
}'
响应示例响应示例
{
"errorDescription": "success",
"data": {
"total": 4,
"offset": 0,
"dataList": [
{
"tenant_id": "文本值",
"lock_rule": "",
"remark": "哈哈哈哈哈哈哈哈,我在这里呀",
"lock_user": "FSUID_XXXXXXXXXXXXXX",
"extend_obj_data_id": "文本值",
"is_deleted": true,
"manufacture_date": 1608263757480,
"life_status_before_invalid": "文本值",
"product_id": "5acc72c42848bddbe00193f4",
"object_describe_api_name": "文本值",
"owner_department": "文本值",
"out_owner": "FSUID_XXXXXXXXXXXXXX",
"owner": "FSUID_XXXXXXXXXXXXXX",
"lock_status": "KJdnsn",
"package": "文本值",
"last_modified_time": 1608263757480,
"is_using": true,
"create_time": 1608263757480,
"whether_used": true,
"life_status": "KJdnsn",
"last_modified_by": "FSUID_XXXXXXXXXXXXXX",
"out_tenant_id": "文本值",
"stock_id": "5acc72c42848bddbe00193f4",
"version": 11,
"created_by": "FSUID_XXXXXXXXXXXXXX",
"record_type": "default",
"relevant_team": "",
"unit": "5acc72c42848bddbe00193f4",
"data_own_department": 999999,
"name": "文本值",
"order_by": 11,
"_id": "5acc72c42848bddbe00193f4",
"warehouse_id": "5acc72c42848bddbe00193f4"
}
]
},
"errorMessage": "OK",
"errorCode": "0"
}
请求参数
Body 参数application/json