Trendsic Platform Service

ReportManagerDataRequest

The following routes are available for this service:
GET,POST,OPTIONS	/v1/ReportManager/api/Objects/{Table}/data

"use strict";
export class JToken {
    constructor(init) { Object.assign(this, init) }
}
export class JValue extends JToken {
    constructor(init) { super(init); Object.assign(this, init) }
}
export class GetSqlResult {
    /** @param {{Sql?:string,Values?:{ [index:string]: JValue; },Error?:string,HasError?:boolean}} [init] */
    constructor(init) { Object.assign(this, init) }
    /** @type {string} */
    Sql;
    /** @type {{ [index:string]: JValue; }} */
    Values;
    /** @type {string} */
    Error;
    /** @type {boolean} */
    HasError;
}
export class ReportManagerDataJoin {
    /** @param {{Source?:string,Target?:string,SourceField?:string,TargetField?:string,id?:string}} [init] */
    constructor(init) { Object.assign(this, init) }
    /** @type {string} */
    Source;
    /** @type {string} */
    Target;
    /** @type {string} */
    SourceField;
    /** @type {string} */
    TargetField;
    /** @type {string} */
    id;
}
export class ReportManagerDataSort {
    /** @param {{Field?:string,Direction?:string}} [init] */
    constructor(init) { Object.assign(this, init) }
    /** @type {string} */
    Field;
    /** @type {string} */
    Direction;
}
export class ReportManagerDataBucketOption {
    /** @param {{Id?:string,Values?:Object[]}} [init] */
    constructor(init) { Object.assign(this, init) }
    /** @type {string} */
    Id;
    /** @type {Object[]} */
    Values = [];
}
export class ReportManagerDataBucket {
    /** @param {{BucketColumn?:string,Options?:ReportManagerDataBucketOption[]}} [init] */
    constructor(init) { Object.assign(this, init) }
    /** @type {string} */
    BucketColumn;
    /** @type {ReportManagerDataBucketOption[]} */
    Options = [];
}
export class ReportManagerDataRequest {
    /** @param {{Table?:string,TableKey?:string,Query?:string,QueryCast?:GetSqlResult,Columns?:string[],Joins?:string,JoinsCast?:ReportManagerDataJoin[],Limit?:string,Sort?:string,SortCast?:ReportManagerDataSort[],Group?:string[],Buckets?:string,BucketsCast?:ReportManagerDataBucket[]}} [init] */
    constructor(init) { Object.assign(this, init) }
    /** @type {string} */
    Table;
    /** @type {string} */
    TableKey;
    /** @type {string} */
    Query;
    /** @type {GetSqlResult} */
    QueryCast;
    /** @type {string[]} */
    Columns = [];
    /** @type {string} */
    Joins;
    /** @type {ReportManagerDataJoin[]} */
    JoinsCast = [];
    /** @type {string} */
    Limit;
    /** @type {string} */
    Sort;
    /** @type {ReportManagerDataSort[]} */
    SortCast = [];
    /** @type {string[]} */
    Group = [];
    /** @type {string} */
    Buckets;
    /** @type {ReportManagerDataBucket[]} */
    BucketsCast = [];
}

JavaScript 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":{}}]