MySQL 复杂msql查询示例-资产建模 API

Platform: MySQL
Type: WebAPI
Effect: QUERY
API Version: 1.0
Adapter: \Adapter\Mysql\MysqlQueryAdapter
Auth Mode: OTHER
Help Link: https://www.yuque.com/vincent-fm7eo/qeasy/tsxqzh
Doc Link: https://www.yuque.com/vincent-fm7eo/qeasy/tsxqzh
Updated At: 2023-05-25

复杂msql查询示例-资产建模

POSTselect

Factory

{
  "operation": {
    "method": "none"
  }
}

Request Parameters

No.	Field	Name	Type	Default	Required	Description
1	main_params	main_params	object	1	Required	111
1.1	created_at	创建时间	datetime	{{LAST_SYNC_TIME\|dateTime}}	Optional	创建时间
1.2	limit	limit	string	{{PAGINATION_PAGE_SIZE}}	Optional	limit
1.3	offset	offset	string	{{PAGINATION_START_ROW}}	Optional	offset
2	extend_params_1	主表ID	array	—	Optional	主表ID
2.1	api_id	api_id	string	api_id	Optional	api_id
3	extend_params_2	extend_params_1	array	—	Optional	extend_params_1
3.1	api_id	api_id	string	api_id	Optional	api_id
4	extend_params_3	extend_params_3	array	—	Optional	extend_params_3
4.1	api_id	api_id	string	api_id	Optional	api_id

Response Parameters

No.	Field	Name	Type	Required	Description
1	id	id	string	Optional	_autoFillResponse
2	name	name	string	Optional	_autoFillResponse
3	platform_name	platform_name	string	Optional	_autoFillResponse
4	effect	effect	string	Optional	_autoFillResponse
5	platform_id	platform_id	string	Optional	_autoFillResponse
6	api_id	api_id	string	Optional	_autoFillResponse
7	approval_name	approval_name	string	Optional	_autoFillResponse
8	created_at	created_at	string	Optional	_autoFillResponse
9	event	event	string	Optional	_autoFillResponse
10	extend_sql_3	extend_sql_3	object	Optional	_autoFillResponse

The 复杂msql查询示例-资产建模 API (select) of MySQL is curated by the API asset management module of the Qeasy Cloud data integration platform and kept in sync with MySQL version updates.

Need to integrate this API?

Qeasy ships with prebuilt adaptation for this API — contact us to start configuring data integration.