digitaluapi

GetTableRecordsRequest

**Requires Authentication**
Requires any of the roles:	Client, Admin, Partner

The following routes are available for this service:
GET, POST	/scadmeta/tables/{TablesId}/data	Gets table records

**GetTableRecordsRequest** Parameters:
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

**Filter** Parameters:
Name	Parameter	Data Type	Required
Column	form	string	No
Operator	form	string	No
Value	form	Object	No
FromVariable	form	string	No
ToValue	form	Object	No
ToVariable	form	string	No

**Paging** Parameters:
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 .jsv suffix or ?format=jsv

HTTP + JSV

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: text/jsv
Content-Type: text/jsv
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: text/jsv
Content-Length: length

[
	{
		
	}
]