Trendsic Platform Service

ReportManagerDataRequest

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

namespace CRM.AgencyPlatform.API.Internal

open System
open System.IO
open System.Collections
open System.Collections.Generic
open System.Runtime.Serialization
open ServiceStack
open ServiceStack.DataAnnotations

    [<AllowNullLiteral>]
    type JToken() = 
        class end

    [<AllowNullLiteral>]
    type JValue() = 
        inherit JToken()

    [<AllowNullLiteral>]
    type GetSqlResult() = 
        member val Sql:String = null with get,set
        member val Values:IDictionary<String, JValue> = new IDictionary<String, JValue>() with get,set
        member val Error:String = null with get,set
        member val HasError:Boolean = new Boolean() with get,set

    [<AllowNullLiteral>]
    type ReportManagerDataJoin() = 
        member val Source:String = null with get,set
        member val Target:String = null with get,set
        member val SourceField:String = null with get,set
        member val TargetField:String = null with get,set
        member val id:String = null with get,set

    [<AllowNullLiteral>]
    type ReportManagerDataSort() = 
        member val Field:String = null with get,set
        member val Direction:String = null with get,set

    [<AllowNullLiteral>]
    type ReportManagerDataBucketOption() = 
        member val Id:String = null with get,set
        member val Values:ResizeArray<Object> = new ResizeArray<Object>() with get,set

    [<AllowNullLiteral>]
    type ReportManagerDataBucket() = 
        member val BucketColumn:String = null with get,set
        member val Options:ResizeArray<ReportManagerDataBucketOption> = new ResizeArray<ReportManagerDataBucketOption>() with get,set

    [<AllowNullLiteral>]
    type ReportManagerDataRequest() = 
        member val Table:String = null with get,set
        member val TableKey:String = null with get,set
        member val Query:String = null with get,set
        member val QueryCast:GetSqlResult = null with get,set
        member val Columns:ResizeArray<String> = new ResizeArray<String>() with get,set
        member val Joins:String = null with get,set
        member val JoinsCast:ResizeArray<ReportManagerDataJoin> = new ResizeArray<ReportManagerDataJoin>() with get,set
        member val Limit:String = null with get,set
        member val Sort:String = null with get,set
        member val SortCast:ResizeArray<ReportManagerDataSort> = new ResizeArray<ReportManagerDataSort>() with get,set
        member val Group:ResizeArray<String> = new ResizeArray<String>() with get,set
        member val Buckets:String = null with get,set
        member val BucketsCast:ResizeArray<ReportManagerDataBucket> = new ResizeArray<ReportManagerDataBucket>() with get,set

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