Trendsic Platform Service

<back to all web services

ReportRunRequest

Requires Authentication
Requires any of the roles:Agent, Administrator
The following routes are available for this service:
POST,OPTIONS/v1/report/run
import java.math.*;
import java.util.*;
import java.io.InputStream;
import net.servicestack.client.*;

public class dtos
{

    public static class ReportRunRequest extends ReportDefinition
    {
        
    }

    public static class ReportDefinition
    {
        public String DatasetCode = null;
        public ArrayList<String> Dimensions = new ArrayList<String>();
        public ArrayList<ReportMeasure> Measures = new ArrayList<ReportMeasure>();
        public ArrayList<String> Joins = new ArrayList<String>();
        public String Filters = null;
        public ArrayList<ReportSort> Sorts = new ArrayList<ReportSort>();
        public Integer Limit = null;
        
        public String getDatasetCode() { return DatasetCode; }
        public ReportDefinition setDatasetCode(String value) { this.DatasetCode = value; return this; }
        public ArrayList<String> getDimensions() { return Dimensions; }
        public ReportDefinition setDimensions(ArrayList<String> value) { this.Dimensions = value; return this; }
        public ArrayList<ReportMeasure> getMeasures() { return Measures; }
        public ReportDefinition setMeasures(ArrayList<ReportMeasure> value) { this.Measures = value; return this; }
        public ArrayList<String> getJoins() { return Joins; }
        public ReportDefinition setJoins(ArrayList<String> value) { this.Joins = value; return this; }
        public String getFilters() { return Filters; }
        public ReportDefinition setFilters(String value) { this.Filters = value; return this; }
        public ArrayList<ReportSort> getSorts() { return Sorts; }
        public ReportDefinition setSorts(ArrayList<ReportSort> value) { this.Sorts = value; return this; }
        public Integer getLimit() { return Limit; }
        public ReportDefinition setLimit(Integer value) { this.Limit = value; return this; }
    }

    public static class ReportMeasure
    {
        public String FieldCode = null;
        public String Agg = null;
        
        public String getFieldCode() { return FieldCode; }
        public ReportMeasure setFieldCode(String value) { this.FieldCode = value; return this; }
        public String getAgg() { return Agg; }
        public ReportMeasure setAgg(String value) { this.Agg = value; return this; }
    }

    public static class ReportSort
    {
        public String FieldCode = null;
        public String Dir = null;
        
        public String getFieldCode() { return FieldCode; }
        public ReportSort setFieldCode(String value) { this.FieldCode = value; return this; }
        public String getDir() { return Dir; }
        public ReportSort setDir(String value) { this.Dir = value; return this; }
    }

    public static class ReportRunResponse
    {
        public ResponseStatus ResponseStatus = null;
        public ReportRunResult Result = null;
        
        public ResponseStatus getResponseStatus() { return ResponseStatus; }
        public ReportRunResponse setResponseStatus(ResponseStatus value) { this.ResponseStatus = value; return this; }
        public ReportRunResult getResult() { return Result; }
        public ReportRunResponse setResult(ReportRunResult value) { this.Result = value; return this; }
    }

    public static class ReportRunResult
    {
        public ArrayList<ReportColumnMeta> Columns = new ArrayList<ReportColumnMeta>();
        public ArrayList<HashMap<String,Object>> Rows = new ArrayList<HashMap<String,Object>>();
        public Integer RowCount = null;
        public Boolean Truncated = null;
        public ArrayList<String> Notes = new ArrayList<String>();
        
        public ArrayList<ReportColumnMeta> getColumns() { return Columns; }
        public ReportRunResult setColumns(ArrayList<ReportColumnMeta> value) { this.Columns = value; return this; }
        public ArrayList<HashMap<String,Object>> getRows() { return Rows; }
        public ReportRunResult setRows(ArrayList<HashMap<String,Object>> value) { this.Rows = value; return this; }
        public Integer getRowCount() { return RowCount; }
        public ReportRunResult setRowCount(Integer value) { this.RowCount = value; return this; }
        public Boolean isTruncated() { return Truncated; }
        public ReportRunResult setTruncated(Boolean value) { this.Truncated = value; return this; }
        public ArrayList<String> getNotes() { return Notes; }
        public ReportRunResult setNotes(ArrayList<String> value) { this.Notes = value; return this; }
    }

    public static class ReportColumnMeta
    {
        public String Code = null;
        public String Name = null;
        public String DataType = null;
        public String FieldKind = null;
        public String Agg = null;
        
        public String getCode() { return Code; }
        public ReportColumnMeta setCode(String value) { this.Code = value; return this; }
        public String getName() { return Name; }
        public ReportColumnMeta setName(String value) { this.Name = value; return this; }
        public String getDataType() { return DataType; }
        public ReportColumnMeta setDataType(String value) { this.DataType = value; return this; }
        public String getFieldKind() { return FieldKind; }
        public ReportColumnMeta setFieldKind(String value) { this.FieldKind = value; return this; }
        public String getAgg() { return Agg; }
        public ReportColumnMeta setAgg(String value) { this.Agg = value; return this; }
    }

}

Java ReportRunRequest 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 /v1/report/run HTTP/1.1 
Host: api.dev.dynamics.trendsic.com 
Accept: text/jsv
Content-Type: text/jsv
Content-Length: length

{
	DatasetCode: String,
	Dimensions: 
	[
		String
	],
	Measures: 
	[
		{
			FieldCode: String,
			Agg: String
		}
	],
	Joins: 
	[
		String
	],
	Filters: String,
	Sorts: 
	[
		{
			FieldCode: String,
			Dir: String
		}
	],
	Limit: 0
}
HTTP/1.1 200 OK
Content-Type: text/jsv
Content-Length: length

{
	ResponseStatus: 
	{
		ErrorCode: String,
		Message: String,
		StackTrace: String,
		Errors: 
		[
			{
				ErrorCode: String,
				FieldName: String,
				Message: String,
				Meta: 
				{
					String: String
				}
			}
		],
		Meta: 
		{
			String: String
		}
	},
	Result: 
	{
		Columns: 
		[
			{
				Code: String,
				Name: String,
				DataType: String,
				FieldKind: String,
				Agg: String
			}
		],
		Rows: 
		[
			{
				String: {}
			}
		],
		RowCount: 0,
		Truncated: False,
		Notes: 
		[
			String
		]
	}
}