Trendsic Platform Service

<back to all web services

ReportManagerDataRequest

The following routes are available for this service:
GET,POST,OPTIONS/v1/ReportManager/api/Objects/{Table}/data
import java.math.*;
import java.util.*;
import java.io.InputStream;
import net.servicestack.client.*;

public class dtos
{

    public static class ReportManagerDataRequest
    {
        public String Table = null;
        public String TableKey = null;
        public String Query = null;
        public GetSqlResult QueryCast = null;
        public ArrayList<String> Columns = new ArrayList<String>();
        public String Joins = null;
        public ArrayList<ReportManagerDataJoin> JoinsCast = new ArrayList<ReportManagerDataJoin>();
        public String Limit = null;
        public String Sort = null;
        public ArrayList<ReportManagerDataSort> SortCast = new ArrayList<ReportManagerDataSort>();
        public ArrayList<String> Group = new ArrayList<String>();
        public String Buckets = null;
        public ArrayList<ReportManagerDataBucket> BucketsCast = new ArrayList<ReportManagerDataBucket>();
        
        public String getTable() { return Table; }
        public ReportManagerDataRequest setTable(String value) { this.Table = value; return this; }
        public String getTableKey() { return TableKey; }
        public ReportManagerDataRequest setTableKey(String value) { this.TableKey = value; return this; }
        public String getQuery() { return Query; }
        public ReportManagerDataRequest setQuery(String value) { this.Query = value; return this; }
        public GetSqlResult getQueryCast() { return QueryCast; }
        public ReportManagerDataRequest setQueryCast(GetSqlResult value) { this.QueryCast = value; return this; }
        public ArrayList<String> getColumns() { return Columns; }
        public ReportManagerDataRequest setColumns(ArrayList<String> value) { this.Columns = value; return this; }
        public String getJoins() { return Joins; }
        public ReportManagerDataRequest setJoins(String value) { this.Joins = value; return this; }
        public ArrayList<ReportManagerDataJoin> getJoinsCast() { return JoinsCast; }
        public ReportManagerDataRequest setJoinsCast(ArrayList<ReportManagerDataJoin> value) { this.JoinsCast = value; return this; }
        public String getLimit() { return Limit; }
        public ReportManagerDataRequest setLimit(String value) { this.Limit = value; return this; }
        public String getSort() { return Sort; }
        public ReportManagerDataRequest setSort(String value) { this.Sort = value; return this; }
        public ArrayList<ReportManagerDataSort> getSortCast() { return SortCast; }
        public ReportManagerDataRequest setSortCast(ArrayList<ReportManagerDataSort> value) { this.SortCast = value; return this; }
        public ArrayList<String> getGroup() { return Group; }
        public ReportManagerDataRequest setGroup(ArrayList<String> value) { this.Group = value; return this; }
        public String getBuckets() { return Buckets; }
        public ReportManagerDataRequest setBuckets(String value) { this.Buckets = value; return this; }
        public ArrayList<ReportManagerDataBucket> getBucketsCast() { return BucketsCast; }
        public ReportManagerDataRequest setBucketsCast(ArrayList<ReportManagerDataBucket> value) { this.BucketsCast = value; return this; }
    }

    public static class GetSqlResult
    {
        public String Sql = null;
        public HashMap<String,JValue> Values = null;
        public String Error = null;
        public Boolean HasError = null;
        
        public String getSql() { return Sql; }
        public GetSqlResult setSql(String value) { this.Sql = value; return this; }
        public HashMap<String,JValue> getValues() { return Values; }
        public GetSqlResult setValues(HashMap<String,JValue> value) { this.Values = value; return this; }
        public String getError() { return Error; }
        public GetSqlResult setError(String value) { this.Error = value; return this; }
        public Boolean isHasError() { return HasError; }
        public GetSqlResult setHasError(Boolean value) { this.HasError = value; return this; }
    }

    public static class JValue extends JToken
    {
        
    }

    public static class JToken implements IJsonLineInfo
    {
        
    }

    public static class ReportManagerDataJoin
    {
        public String Source = null;
        public String Target = null;
        public String SourceField = null;
        public String TargetField = null;
        public String id = null;
        
        public String getSource() { return Source; }
        public ReportManagerDataJoin setSource(String value) { this.Source = value; return this; }
        public String getTarget() { return Target; }
        public ReportManagerDataJoin setTarget(String value) { this.Target = value; return this; }
        public String getSourceField() { return SourceField; }
        public ReportManagerDataJoin setSourceField(String value) { this.SourceField = value; return this; }
        public String getTargetField() { return TargetField; }
        public ReportManagerDataJoin setTargetField(String value) { this.TargetField = value; return this; }
        public String getId() { return id; }
        public ReportManagerDataJoin setId(String value) { this.id = value; return this; }
    }

    public static class ReportManagerDataSort
    {
        public String Field = null;
        public String Direction = null;
        
        public String getField() { return Field; }
        public ReportManagerDataSort setField(String value) { this.Field = value; return this; }
        public String getDirection() { return Direction; }
        public ReportManagerDataSort setDirection(String value) { this.Direction = value; return this; }
    }

    public static class ReportManagerDataBucket
    {
        public String BucketColumn = null;
        public ArrayList<ReportManagerDataBucketOption> Options = new ArrayList<ReportManagerDataBucketOption>();
        
        public String getBucketColumn() { return BucketColumn; }
        public ReportManagerDataBucket setBucketColumn(String value) { this.BucketColumn = value; return this; }
        public ArrayList<ReportManagerDataBucketOption> getOptions() { return Options; }
        public ReportManagerDataBucket setOptions(ArrayList<ReportManagerDataBucketOption> value) { this.Options = value; return this; }
    }

    public static class ReportManagerDataBucketOption
    {
        public String Id = null;
        public ArrayList<Object> Values = new ArrayList<Object>();
        
        public String getId() { return Id; }
        public ReportManagerDataBucketOption setId(String value) { this.Id = value; return this; }
        public ArrayList<Object> getValues() { return Values; }
        public ReportManagerDataBucketOption setValues(ArrayList<Object> value) { this.Values = value; return this; }
    }

}

Java ReportManagerDataRequest DTOs

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

HTTP + OTHER

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

POST /v1/ReportManager/api/Objects/{Table}/data HTTP/1.1 
Host: api.dev.dynamics.trendsic.com 
Accept: text/jsonl
Content-Type: text/jsonl
Content-Length: length

{Unable to show example output for type 'ReportManagerDataRequest' using the custom 'other' filter}One or more errors occurred.
HTTP/1.1 200 OK
Content-Type: text/jsonl
Content-Length: length

[{"String":{}}]