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

using System;
using System.IO;
using System.Collections;
using System.Collections.Generic;
using System.Runtime.Serialization;
using ServiceStack;
using ServiceStack.DataAnnotations;
using digitaluapi.ServiceModel;
using digitaluapi.ServiceModel.Types;

namespace digitaluapi.ServiceModel
{
    public partial class GetTableRecordsRequest
    {
        ///<summary>
        ///Table id
        ///</summary>
        [ApiMember(Description="Table id", IsRequired=true)]
        public virtual int TablesId { get; set; }

        ///<summary>
        ///Query id
        ///</summary>
        [ApiMember(Description="Query id")]
        public virtual int? QueryId { get; set; }

        ///<summary>
        ///Parameter list
        ///</summary>
        [ApiMember(Description="Parameter list")]
        public virtual Dictionary<string, Object> ParameterList { get; set; }

        ///<summary>
        ///Filter list
        ///</summary>
        [ApiMember(Description="Filter list")]
        public virtual Dictionary<string, Object> FilterList { get; set; }

        public virtual List<Filter> Filter { get; set; }
        ///<summary>
        ///Number of items to be returned per page
        ///</summary>
        [ApiMember(Description="Number of items to be returned per page")]
        public virtual Paging Paging { get; set; }

        ///<summary>
        ///Drill down filter list
        ///</summary>
        [ApiMember(Description="Drill down filter list")]
        public virtual Dictionary<string, Object> DrillDownFilterList { get; set; }

        ///<summary>
        ///Global parameter list
        ///</summary>
        [ApiMember(Description="Global parameter list")]
        public virtual Dictionary<string, Object> GlobalParamList { get; set; }

        ///<summary>
        ///View id
        ///</summary>
        [ApiMember(Description="View id")]
        public virtual int? ViewId { get; set; }

        ///<summary>
        ///Whether or not to refresh the cache
        ///</summary>
        [ApiMember(Description="Whether or not to refresh the cache")]
        public virtual bool RefreshCache { get; set; }
    }

}

namespace digitaluapi.ServiceModel.Types
{
    public partial class Filter
    {
        public virtual string Column { get; set; }
        public virtual string Operator { get; set; }
        public virtual Object Value { get; set; }
        public virtual string FromVariable { get; set; }
        public virtual Object ToValue { get; set; }
        public virtual string ToVariable { get; set; }
    }

    public partial class Paging
    {
        public virtual int PageNumber { get; set; }
        public virtual int PageSize { get; set; }
    }

}

C# GetTableRecordsRequest DTOs

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

[
	{
		
	}
]