/cgi/crm/v2/data/query{
"operation": {
"method": "none"
}
}| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | search_query_info | 查询对象 | object | Optional | 查询对象 | |
| 1.1 | offset | offset | string | _function 0 * 1 | Optional | offset |
| 1.2 | limit | limit | string | _function 20 * 1 | Optional | limit |
| 1.3 | filters | 过滤条件 | object | Optional | ||
| 1.3.1 | 条件1 | 条件1 | object | Optional | ||
| 1.3.1.1 | field_name | 字段名称 | string | last_modified_time | Optional | |
| 1.3.1.2 | field_values | 条件值 | string | {{LAST_SYNC_TIME}}000 | Optional | |
| 1.3.1.3 | operator | 操作符 | string | GTE | Optional | |
| 2 | dataObjectApiName | 对象的api_name | string | SalesOrderObj | Optional | 对象的api_name |
| No. | Field | Name | Type | Default | Required | Description |
|---|---|---|---|---|---|---|
| 1 | discount | discount | string | Optional | _autoFillResponse | |
| 2 | account_id__r | account_id__r | string | Optional | _autoFillResponse | |
| 3 | order_time | order_time | string | Optional | _autoFillResponse | |
| 4 | receivable_amount | receivable_amount | string | Optional | _autoFillResponse | |
| 5 | owner_department_id | owner_department_id | string | Optional | _autoFillResponse | |
| 6 | data_own_department__r | data_own_department__r | object | Optional | _autoFillResponse | |
| 6.1 | deptName | deptName | string | Optional | _autoFillResponse | |
| 6.2 | deptId | deptId | string | Optional | _autoFillResponse | |
| 6.3 | deptType | deptType | string | Optional | _autoFillResponse | |
| 6.4 | parentId | parentId | string | Optional | _autoFillResponse | |
| 6.5 | status | status | string | Optional | _autoFillResponse | |
| 7 | version | version | string | Optional | _autoFillResponse | |
| 8 | paid_amount | paid_amount | string | Optional | _autoFillResponse | |
| 9 | product_amount | product_amount | string | Optional | _autoFillResponse | |
| 10 | last_modified_time | last_modified_time | string | Optional | _autoFillResponse | |
| 11 | life_status | life_status | string | Optional | _autoFillResponse | |
| 12 | account_id | account_id | string | Optional | _autoFillResponse | |
| 13 | account_id__relation_ids | account_id__relation_ids | string | Optional | _autoFillResponse | |
| 14 | price_book_amount | price_book_amount | string | Optional | _autoFillResponse | |
| 15 | no_invoice_amount | no_invoice_amount | string | Optional | _autoFillResponse | |
| 16 | dynamic_amount | dynamic_amount | string | Optional | _autoFillResponse | |
| 17 | current_level | current_level | string | Optional | _autoFillResponse | |
| 18 | logistics_status | logistics_status | string | Optional | _autoFillResponse | |
| 19 | extend_obj_data_id | extend_obj_data_id | string | Optional | _autoFillResponse | |
| 20 | created_by__r | created_by__r | object | Optional | _autoFillResponse | |
| 20.1 | picAddr | picAddr | string | Optional | _autoFillResponse | |
| 20.2 | mobile | mobile | string | Optional | _autoFillResponse | |
| 20.3 | description | description | string | Optional | _autoFillResponse | |
| 20.4 | dept | dept | string | Optional | _autoFillResponse | |
| 20.5 | empNum | empNum | string | Optional | _autoFillResponse | |
| 20.6 | modifyTime | modifyTime | string | Optional | _autoFillResponse | |
| 20.7 | post | post | string | Optional | _autoFillResponse | |
| 20.8 | createTime | createTime | string | Optional | _autoFillResponse | |
| 20.9 | phone | phone | string | Optional | _autoFillResponse | |
| 20.10 | name | name | string | Optional | _autoFillResponse | |
| 20.11 | nickname | nickname | string | Optional | _autoFillResponse | |
| 20.12 | tenantId | tenantId | string | Optional | _autoFillResponse | |
| 20.13 | id | id | string | Optional | _autoFillResponse | |
| 20.14 | string | Optional | _autoFillResponse | |||
| 20.15 | status | status | string | Optional | _autoFillResponse | |
| 21 | order_amount | order_amount | string | Optional | _autoFillResponse | |
| 22 | owner_department | owner_department | string | Optional | _autoFillResponse | |
| 23 | sales_mode | sales_mode | string | Optional | _autoFillResponse | |
| 24 | lock_status | lock_status | string | Optional | _autoFillResponse | |
| 25 | create_time | create_time | string | Optional | _autoFillResponse | |
| 26 | submit_time | submit_time | string | Optional | _autoFillResponse | |
| 27 | resource | resource | string | Optional | _autoFillResponse | |
| 28 | name | name | string | Optional | _autoFillResponse | |
| 29 | bill_money_to_confirm | bill_money_to_confirm | string | Optional | _autoFillResponse | |
| 30 | _id | _id | string | Optional | _autoFillResponse | |
| 31 | payment_money_to_confirm | payment_money_to_confirm | string | Optional | _autoFillResponse | |
| 32 | invoice_status | invoice_status | string | Optional | _autoFillResponse | |
| 33 | is_deleted | is_deleted | string | Optional | _autoFillResponse | |
| 34 | relevant_team__r | relevant_team__r | string | Optional | _autoFillResponse | |
| 35 | owner__r | owner__r | object | Optional | _autoFillResponse | |
| 35.1 | picAddr | picAddr | string | Optional | _autoFillResponse | |
| 35.2 | mobile | mobile | string | Optional | _autoFillResponse | |
| 35.3 | description | description | string | Optional | _autoFillResponse | |
| 35.4 | dept | dept | string | Optional | _autoFillResponse | |
| 35.5 | empNum | empNum | string | Optional | _autoFillResponse | |
| 35.6 | modifyTime | modifyTime | string | Optional | _autoFillResponse | |
| 35.7 | post | post | string | Optional | _autoFillResponse | |
| 35.8 | createTime | createTime | string | Optional | _autoFillResponse | |
| 35.9 | phone | phone | string | Optional | _autoFillResponse | |
| 35.10 | name | name | string | Optional | _autoFillResponse | |
| 35.11 | nickname | nickname | string | Optional | _autoFillResponse | |
| 35.12 | tenantId | tenantId | string | Optional | _autoFillResponse | |
| 35.13 | id | id | string | Optional | _autoFillResponse | |
| 35.14 | string | Optional | _autoFillResponse | |||
| 35.15 | status | status | string | Optional | _autoFillResponse | |
| 36 | record_type | record_type | string | Optional | _autoFillResponse | |
| 37 | last_modified_by__r | last_modified_by__r | object | Optional | _autoFillResponse | |
| 37.1 | picAddr | picAddr | string | Optional | _autoFillResponse | |
| 37.2 | mobile | mobile | string | Optional | _autoFillResponse | |
| 37.3 | description | description | string | Optional | _autoFillResponse | |
| 37.4 | dept | dept | string | Optional | _autoFillResponse | |
| 37.5 | empNum | empNum | string | Optional | _autoFillResponse | |
| 37.6 | modifyTime | modifyTime | string | Optional | _autoFillResponse | |
| 37.7 | post | post | string | Optional | _autoFillResponse | |
| 37.8 | createTime | createTime | string | Optional | _autoFillResponse | |
| 37.9 | phone | phone | string | Optional | _autoFillResponse | |
| 37.10 | name | name | string | Optional | _autoFillResponse | |
| 37.11 | nickname | nickname | string | Optional | _autoFillResponse | |
| 37.12 | tenantId | tenantId | string | Optional | _autoFillResponse | |
| 37.13 | id | id | string | Optional | _autoFillResponse | |
| 37.14 | string | Optional | _autoFillResponse | |||
| 37.15 | status | status | string | Optional | _autoFillResponse | |
| 38 | field_320mG__c | field_320mG__c | string | Optional | _autoFillResponse |
The 查询销售订单列表+明细行 API (/cgi/crm/v2/data/query) of 纷享销客 is curated by the API asset management module of the Qeasy Cloud data integration platform and kept in sync with 纷享销客 version updates.
Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.