digitaluapi

<back to all web services

GetTableQueriesRequest

Requires Authentication
Requires any of the roles:Client, Admin, Partner
The following routes are available for this service:
GET/scadmeta/tables/{TablesId}/queriesGets table queries
import java.math.*;
import java.util.*;
import java.io.InputStream;
import net.servicestack.client.*;
import com.google.gson.annotations.*;
import com.google.gson.reflect.*;

public class dtos
{

    public static class GetTableQueriesRequest
    {
        /**
        * Table id
        */
        @ApiMember(Description="Table id", IsRequired=true)
        public Integer TablesId = null;

        /**
        * Parameter list
        */
        @ApiMember(Description="Parameter list")
        public HashMap<String,Object> ParameterList = null;

        /**
        * Filter list
        */
        @ApiMember(Description="Filter list")
        public HashMap<String,Object> FilterList = null;

        /**
        * Number of items to be returned per page
        */
        @ApiMember(Description="Number of items to be returned per page")
        public Paging Paging = null;

        public Integer FromId = null;
        /**
        * Drill down filter list
        */
        @ApiMember(Description="Drill down filter list")
        public HashMap<String,Object> DrillDownFilterList = null;

        /**
        * Global parameter list
        */
        @ApiMember(Description="Global parameter list")
        public HashMap<String,Object> GlobalParamList = null;

        /**
        * View id
        */
        @ApiMember(Description="View id")
        public Integer ViewId = null;

        /**
        * Whether or not to refresh the cache
        */
        @ApiMember(Description="Whether or not to refresh the cache")
        public Boolean RefreshCache = null;
        
        public Integer getTablesId() { return TablesId; }
        public GetTableQueriesRequest setTablesId(Integer value) { this.TablesId = value; return this; }
        public HashMap<String,Object> getParameterList() { return ParameterList; }
        public GetTableQueriesRequest setParameterList(HashMap<String,Object> value) { this.ParameterList = value; return this; }
        public HashMap<String,Object> getFilterList() { return FilterList; }
        public GetTableQueriesRequest setFilterList(HashMap<String,Object> value) { this.FilterList = value; return this; }
        public Paging getPaging() { return Paging; }
        public GetTableQueriesRequest setPaging(Paging value) { this.Paging = value; return this; }
        public Integer getFromId() { return FromId; }
        public GetTableQueriesRequest setFromId(Integer value) { this.FromId = value; return this; }
        public HashMap<String,Object> getDrillDownFilterList() { return DrillDownFilterList; }
        public GetTableQueriesRequest setDrillDownFilterList(HashMap<String,Object> value) { this.DrillDownFilterList = value; return this; }
        public HashMap<String,Object> getGlobalParamList() { return GlobalParamList; }
        public GetTableQueriesRequest setGlobalParamList(HashMap<String,Object> value) { this.GlobalParamList = value; return this; }
        public Integer getViewId() { return ViewId; }
        public GetTableQueriesRequest setViewId(Integer value) { this.ViewId = value; return this; }
        public Boolean isRefreshCache() { return RefreshCache; }
        public GetTableQueriesRequest setRefreshCache(Boolean value) { this.RefreshCache = value; return this; }
    }

    public static class Paging
    {
        public Integer PageNumber = null;
        public Integer PageSize = null;
        
        public Integer getPageNumber() { return PageNumber; }
        public Paging setPageNumber(Integer value) { this.PageNumber = value; return this; }
        public Integer getPageSize() { return PageSize; }
        public Paging setPageSize(Integer value) { this.PageSize = value; return this; }
    }

}

Java GetTableQueriesRequest DTOs

To override the Content-type in your clients, use the HTTP Accept Header, append the .xml suffix or ?format=xml

HTTP + XML

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

GET /scadmeta/tables/{TablesId}/queries HTTP/1.1 
Host: duengageapi.uat.scadsoftware.com 
Accept: application/xml
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<ArrayOfanyType xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
  <anyType />
</ArrayOfanyType>