| GET,POST,OPTIONS | /v1/ReportManager/api/Objects/{Table}/data |
|---|
export class JToken implements IJsonLineInfo
{
public constructor(init?: Partial<JToken>) { (Object as any).assign(this, init); }
}
export class JValue extends JToken
{
public constructor(init?: Partial<JValue>) { super(init); (Object as any).assign(this, init); }
}
export class GetSqlResult
{
public Sql: string;
public Values: { [index:string]: JValue; };
public Error: string;
public HasError: boolean;
public constructor(init?: Partial<GetSqlResult>) { (Object as any).assign(this, init); }
}
export class ReportManagerDataJoin
{
public Source: string;
public Target: string;
public SourceField: string;
public TargetField: string;
public id: string;
public constructor(init?: Partial<ReportManagerDataJoin>) { (Object as any).assign(this, init); }
}
export class ReportManagerDataSort
{
public Field: string;
public Direction: string;
public constructor(init?: Partial<ReportManagerDataSort>) { (Object as any).assign(this, init); }
}
export class ReportManagerDataBucketOption
{
public Id: string;
public Values: Object[] = [];
public constructor(init?: Partial<ReportManagerDataBucketOption>) { (Object as any).assign(this, init); }
}
export class ReportManagerDataBucket
{
public BucketColumn: string;
public Options: ReportManagerDataBucketOption[] = [];
public constructor(init?: Partial<ReportManagerDataBucket>) { (Object as any).assign(this, init); }
}
export class ReportManagerDataRequest
{
public Table: string;
public TableKey: string;
public Query: string;
public QueryCast: GetSqlResult;
public Columns: string[] = [];
public Joins: string;
public JoinsCast: ReportManagerDataJoin[] = [];
public Limit: string;
public Sort: string;
public SortCast: ReportManagerDataSort[] = [];
public Group: string[] = [];
public Buckets: string;
public BucketsCast: ReportManagerDataBucket[] = [];
public constructor(init?: Partial<ReportManagerDataRequest>) { (Object as any).assign(this, init); }
}
TypeScript ReportManagerDataRequest DTOs
To override the Content-type in your clients, use the HTTP Accept Header, append the .csv suffix or ?format=csv
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/csv
Content-Type: text/csv
Content-Length: length
{Unable to show example output for type 'ReportManagerDataRequest' using the custom 'csv' filter}One or more errors occurred.
HTTP/1.1 200 OK
Content-Type: text/csv
Content-Length: length
[{"String":{}}]