SQL Server 查询数据-2.0(Offset-Fetch分页)_v1 API

Platform: SQL Server
Type: WebAPI
Effect: QUERY
API Version: 0.1
Adapter: \Adapter\MSSQL\MSSQLQueryAdapter
Auth Mode: OTHER
Help Link: https://www.yuque.com/vincent-fm7eo/qeasy/mssql
Doc Link: https://www.yuque.com/vincent-fm7eo/qeasy/mssql
Updated At: 2022-04-05

查询数据-2.0(Offset-Fetch分页)_v1

POSTselect

Factory

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

Request Parameters

No.	Field	Name	Type	Default	Required	Description
1	main_params	main_params	object	1	Required	111
2	offset	offset	string	_function {{PAGINATION_START_ROW}} * 1	Required	111
3	fetch	fetch	string	_function {{PAGINATION_PAGE_SIZE}} * 1	Required	111
4	extend_params_1	extend_params_1	object	1	Optional	111
5	id	id	string	:id	Optional	111
6	extend_params_2	extend_params_2	array	1	Optional	111
7	id	id	string	:id	Optional	111
8	maxid	maxid	string	_function {{MAX_DATA_ID}} * 1	Optional	111

Response Parameters

No parameter reference available

The 查询数据-2.0(Offset-Fetch分页)_v1 API (select) of SQL Server is curated by the API asset management module of the Qeasy Cloud data integration platform and kept in sync with SQL Server version updates.

Need to integrate this API?

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