| Requires any of the roles: | Client, Admin, Partner |
| GET, POST | /scadmeta/tables/{TablesId}/data | Gets table records |
|---|
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| TablesId | path | int | Yes | Table id |
| QueryId | body | int? | No | Query id |
| ParameterList | body | Dictionary<string, Object> | No | Parameter list |
| FilterList | body | Dictionary<string, Object> | No | Filter list |
| Filter | body | List<Filter> | No | |
| Paging | body | Paging | No | Number of items to be returned per page |
| DrillDownFilterList | body | Dictionary<string, Object> | No | Drill down filter list |
| GlobalParamList | body | Dictionary<string, Object> | No | Global parameter list |
| ViewId | body | int? | No | View id |
| RefreshCache | body | bool | No | Whether or not to refresh the cache |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| Column | form | string | No | |
| Operator | form | string | No | |
| Value | form | Object | No | |
| FromVariable | form | string | No | |
| ToValue | form | Object | No | |
| ToVariable | form | string | No |
| Name | Parameter | Data Type | Required | Description |
|---|---|---|---|---|
| PageNumber | form | int | No | |
| PageSize | form | int | No |
To override the Content-type in your clients, use the HTTP Accept Header, append the .json suffix or ?format=json
To embed the response in a jsonp callback, append ?callback=myCallback
The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.
POST /scadmeta/tables/{TablesId}/data HTTP/1.1
Host: duengageapi.uat.scadsoftware.com
Accept: application/json
Content-Type: application/json
Content-Length: length
{"TablesId":0,"QueryId":0,"ParameterList":{"String":{}},"FilterList":{"String":{}},"Filter":[{"Column":"String","Operator":"String","Value":{},"FromVariable":"String","ToValue":{},"ToVariable":"String"}],"Paging":{"PageNumber":0,"PageSize":0},"DrillDownFilterList":{"String":{}},"GlobalParamList":{"String":{}},"ViewId":0,"RefreshCache":false}
HTTP/1.1 200 OK
Content-Type: application/json
Content-Length: length
[{}]