Trendsic Platform Service

ReportManagerDataRequest

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

Imports System
Imports System.IO
Imports System.Collections
Imports System.Collections.Generic
Imports System.Runtime.Serialization
Imports ServiceStack
Imports ServiceStack.DataAnnotations
Imports CRM.AgencyPlatform.API.Internal
Imports CRM.AgencyPlatform.API.Internal.JsonToSqlQuery.Models
Imports Newtonsoft.Json.Linq

Namespace Global

    Namespace CRM.AgencyPlatform.API.Internal

        Public Partial Class ReportManagerDataBucket
            Public Overridable Property BucketColumn As String
            Public Overridable Property Options As List(Of ReportManagerDataBucketOption) = New List(Of ReportManagerDataBucketOption)
        End Class

        Public Partial Class ReportManagerDataBucketOption
            Public Overridable Property Id As String
            Public Overridable Property Values As List(Of Object) = New List(Of Object)
        End Class

        Public Partial Class ReportManagerDataJoin
            Public Overridable Property Source As String
            Public Overridable Property Target As String
            Public Overridable Property SourceField As String
            Public Overridable Property TargetField As String
            Public Overridable Property id As String
        End Class

        Public Partial Class ReportManagerDataRequest
            Public Overridable Property Table As String
            Public Overridable Property TableKey As String
            Public Overridable Property Query As String
            Public Overridable Property QueryCast As GetSqlResult
            Public Overridable Property Columns As List(Of String) = New List(Of String)
            Public Overridable Property Joins As String
            Public Overridable Property JoinsCast As List(Of ReportManagerDataJoin) = New List(Of ReportManagerDataJoin)
            Public Overridable Property Limit As String
            Public Overridable Property Sort As String
            Public Overridable Property SortCast As List(Of ReportManagerDataSort) = New List(Of ReportManagerDataSort)
            Public Overridable Property Group As List(Of String) = New List(Of String)
            Public Overridable Property Buckets As String
            Public Overridable Property BucketsCast As List(Of ReportManagerDataBucket) = New List(Of ReportManagerDataBucket)
        End Class

        Public Partial Class ReportManagerDataSort
            Public Overridable Property Field As String
            Public Overridable Property Direction As String
        End Class
    End Namespace

    Namespace CRM.AgencyPlatform.API.Internal.JsonToSqlQuery.Models

        Public Partial Class GetSqlResult
            Public Overridable Property Sql As String
            Public Overridable Property Values As IDictionary(Of String, JValue)
            Public Overridable Property [Error] As String
            Public Overridable Property HasError As Boolean
        End Class
    End Namespace

    Namespace Newtonsoft.Json.Linq

        Public Partial Class JToken
            Implements IJsonLineInfo
        End Class

        Public Partial Class JValue
            Inherits JToken
        End Class
    End Namespace
End Namespace

VB.NET 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":{}}]