Trendsic Platform Service

ReportManagerDataRequest

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

import java.math.*
import java.util.*
import java.io.InputStream
import net.servicestack.client.*


open class ReportManagerDataRequest
{
    open var Table:String? = null
    open var TableKey:String? = null
    open var Query:String? = null
    open var QueryCast:GetSqlResult? = null
    open var Columns:ArrayList<String> = ArrayList<String>()
    open var Joins:String? = null
    open var JoinsCast:ArrayList<ReportManagerDataJoin> = ArrayList<ReportManagerDataJoin>()
    open var Limit:String? = null
    open var Sort:String? = null
    open var SortCast:ArrayList<ReportManagerDataSort> = ArrayList<ReportManagerDataSort>()
    open var Group:ArrayList<String> = ArrayList<String>()
    open var Buckets:String? = null
    open var BucketsCast:ArrayList<ReportManagerDataBucket> = ArrayList<ReportManagerDataBucket>()
}

open class GetSqlResult
{
    open var Sql:String? = null
    open var Values:HashMap<String,JValue>? = null
    open var Error:String? = null
    open var HasError:Boolean? = null
}

open class JValue : JToken()
{
}

open class JToken : IJsonLineInfo
{
}

open class ReportManagerDataJoin
{
    open var Source:String? = null
    open var Target:String? = null
    open var SourceField:String? = null
    open var TargetField:String? = null
    open var id:String? = null
}

open class ReportManagerDataSort
{
    open var Field:String? = null
    open var Direction:String? = null
}

open class ReportManagerDataBucket
{
    open var BucketColumn:String? = null
    open var Options:ArrayList<ReportManagerDataBucketOption> = ArrayList<ReportManagerDataBucketOption>()
}

open class ReportManagerDataBucketOption
{
    open var Id:String? = null
    open var Values:ArrayList<Object> = ArrayList<Object>()
}

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