GetMasterDataTableRows
>=4.9.5
Interface Function
Get Master Data table rows by paging
Request Parameter
| Parameter | Type | Remarks |
|---|---|---|
| TableName | string | Master Data table name |
| pageIndex | int | page index for paging query, starts from 1, default value is 1 |
| pageSize | int | page size for paging query, default value is 100 |
Return Data Type
public List<Dictionary<string, object>> RecordDatas { get; set; }
public int Pages { get; set; }
public int Rows { get; set; }
Input Sample
{
"TableName": "TestTable",
"PageIndex": 1,
"PageSize": 100
}
Return Sample
{
"StatusCode": 200,
"Info": "Request (or process) succeeded",
"Data": {
"RecordDatas": [
{
"_id": "616fce96bc33de9c3ce5d299",
"ColName1": "row1",
"OrganizationCode": "DCTwo",
"CategoryName": "TestTable"
},
{
"_id": "616fcea4bc33de9c3ce5ddf2",
"ColName1": "row2",
"OrganizationCode": "DCTwo",
"CategoryName": "TestTable"
},
{
"_id": "616fceb2bc33de9c3ce5e7a4",
"ColName1": "row3",
"OrganizationCode": "DCTwo",
"CategoryName": "TestTable"
},
{
"_id": "616fcebfbc33de9c3ce5f089",
"ColName1": "row4",
"OrganizationCode": "DCTwo",
"CategoryName": "TestTable"
}
],
"Pages": 1,
"Rows": 4
}
}