Trendsic Platform Service

ReportRunRequest

**Requires Authentication**
Requires any of the roles:	Agent, Administrator

The following routes are available for this service:
POST,OPTIONS	/v1/report/run

"use strict";
export class ReportMeasure {
    /** @param {{FieldCode?:string,Agg?:string}} [init] */
    constructor(init) { Object.assign(this, init) }
    /** @type {string} */
    FieldCode;
    /** @type {string} */
    Agg;
}
export class ReportSort {
    /** @param {{FieldCode?:string,Dir?:string}} [init] */
    constructor(init) { Object.assign(this, init) }
    /** @type {string} */
    FieldCode;
    /** @type {string} */
    Dir;
}
export class ReportDefinition {
    /** @param {{DatasetCode?:string,Dimensions?:string[],Measures?:ReportMeasure[],Joins?:string[],Filters?:string,Sorts?:ReportSort[],Limit?:number}} [init] */
    constructor(init) { Object.assign(this, init) }
    /** @type {string} */
    DatasetCode;
    /** @type {string[]} */
    Dimensions = [];
    /** @type {ReportMeasure[]} */
    Measures = [];
    /** @type {string[]} */
    Joins = [];
    /** @type {string} */
    Filters;
    /** @type {ReportSort[]} */
    Sorts = [];
    /** @type {number} */
    Limit;
}
export class ReportColumnMeta {
    /** @param {{Code?:string,Name?:string,DataType?:string,FieldKind?:string,Agg?:string}} [init] */
    constructor(init) { Object.assign(this, init) }
    /** @type {string} */
    Code;
    /** @type {string} */
    Name;
    /** @type {string} */
    DataType;
    /** @type {string} */
    FieldKind;
    /** @type {string} */
    Agg;
}
export class ReportRunResult {
    /** @param {{Columns?:ReportColumnMeta[],Rows?:{ [index:string]: Object; }[],RowCount?:number,Truncated?:boolean,Notes?:string[]}} [init] */
    constructor(init) { Object.assign(this, init) }
    /** @type {ReportColumnMeta[]} */
    Columns = [];
    /** @type {{ [index:string]: Object; }[]} */
    Rows = [];
    /** @type {number} */
    RowCount;
    /** @type {boolean} */
    Truncated;
    /** @type {string[]} */
    Notes = [];
}
export class ReportRunResponse {
    /** @param {{ResponseStatus?:ResponseStatus,Result?:ReportRunResult}} [init] */
    constructor(init) { Object.assign(this, init) }
    /** @type {ResponseStatus} */
    ResponseStatus;
    /** @type {ReportRunResult} */
    Result;
}
export class ReportRunRequest extends ReportDefinition {
    /** @param {{DatasetCode?:string,Dimensions?:string[],Measures?:ReportMeasure[],Joins?:string[],Filters?:string,Sorts?:ReportSort[],Limit?:number}} [init] */
    constructor(init) { super(init); Object.assign(this, init) }
}

JavaScript ReportRunRequest 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.

POST /v1/report/run HTTP/1.1 
Host: api.dev.dynamics.trendsic.com 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<ReportRunRequest xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/CRM.AgencyPlatform.API.Internal">
  <DatasetCode>String</DatasetCode>
  <Dimensions xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Dimensions>
  <Filters>String</Filters>
  <Joins xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:string>String</d2p1:string>
  </Joins>
  <Limit>0</Limit>
  <Measures>
    <ReportMeasure>
      <Agg>String</Agg>
      <FieldCode>String</FieldCode>
    </ReportMeasure>
  </Measures>
  <Sorts>
    <ReportSort>
      <Dir>String</Dir>
      <FieldCode>String</FieldCode>
    </ReportSort>
  </Sorts>
</ReportRunRequest>

HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<ReportRunResponse xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/CRM.AgencyPlatform.API.Internal">
  <ResponseStatus xmlns:d2p1="http://schemas.servicestack.net/types">
    <d2p1:ErrorCode>String</d2p1:ErrorCode>
    <d2p1:Message>String</d2p1:Message>
    <d2p1:StackTrace>String</d2p1:StackTrace>
    <d2p1:Errors>
      <d2p1:ResponseError>
        <d2p1:ErrorCode>String</d2p1:ErrorCode>
        <d2p1:FieldName>String</d2p1:FieldName>
        <d2p1:Message>String</d2p1:Message>
        <d2p1:Meta xmlns:d5p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
          <d5p1:KeyValueOfstringstring>
            <d5p1:Key>String</d5p1:Key>
            <d5p1:Value>String</d5p1:Value>
          </d5p1:KeyValueOfstringstring>
        </d2p1:Meta>
      </d2p1:ResponseError>
    </d2p1:Errors>
    <d2p1:Meta xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
      <d3p1:KeyValueOfstringstring>
        <d3p1:Key>String</d3p1:Key>
        <d3p1:Value>String</d3p1:Value>
      </d3p1:KeyValueOfstringstring>
    </d2p1:Meta>
  </ResponseStatus>
  <Result>
    <Columns>
      <ReportColumnMeta>
        <Agg>String</Agg>
        <Code>String</Code>
        <DataType>String</DataType>
        <FieldKind>String</FieldKind>
        <Name>String</Name>
      </ReportColumnMeta>
    </Columns>
    <Notes xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
      <d3p1:string>String</d3p1:string>
    </Notes>
    <RowCount>0</RowCount>
    <Rows xmlns:d3p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
      <d3p1:ArrayOfKeyValueOfstringanyType>
        <d3p1:KeyValueOfstringanyType>
          <d3p1:Key>String</d3p1:Key>
          <d3p1:Value />
        </d3p1:KeyValueOfstringanyType>
      </d3p1:ArrayOfKeyValueOfstringanyType>
    </Rows>
    <Truncated>false</Truncated>
  </Result>
</ReportRunResponse>