Trendsic Platform Service

<back to all web services

ExecutiveDashboardRequest

Requires Authentication
The following routes are available for this service:
GET,OPTIONS/v1/dashboards/executive
import datetime
import decimal
from marshmallow.fields import *
from servicestack import *
from typing import *
from dataclasses import dataclass, field
from dataclasses_json import dataclass_json, LetterCase, Undefined, config
from enum import Enum, IntEnum


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class ExecKpi:
    key: Optional[str] = None
    label: Optional[str] = None
    value: Optional[str] = None
    sub_: Optional[str] = field(metadata=config(field_name='sub'), default=None)
    delta: Optional[str] = None
    delta_up: bool = False
    has_delta: bool = False
    good: bool = False


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class ExecCostCategory:
    name: Optional[str] = None
    cost_u_s_d: float = 0.0
    billed_u_s_d: float = 0.0


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class ExecMonthPoint:
    month: Optional[str] = None
    revenue_u_s_d: float = 0.0
    cost_u_s_d: float = 0.0


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class ExecBacklogYear:
    year: Optional[str] = None
    value_u_s_d: float = 0.0


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class ExecBacklog:
    total_u_s_d: float = 0.0
    months_ahead: float = 0.0
    awards_ytd_u_s_d: float = 0.0
    burn_ytd_u_s_d: float = 0.0
    by_year: List[ExecBacklogYear] = field(default_factory=list)


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class ExecWipRow:
    contract_id: int = 0
    name: Optional[str] = None
    owner: Optional[str] = None
    value_u_s_d: float = 0.0
    pct_complete: float = 0.0
    billed_u_s_d: float = 0.0
    over_under_u_s_d: float = 0.0
    margin_pct: float = 0.0
    fade_pts: float = 0.0


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class ExecPipelineStage:
    stage: Optional[str] = None
    value_u_s_d: float = 0.0
    count: int = 0


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class ExecAgingBucket:
    bucket: Optional[str] = None
    amount_u_s_d: float = 0.0
    is_retainage: bool = False


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class ExecSafetyMetric:
    label: Optional[str] = None
    value: Optional[str] = None
    sub_: Optional[str] = field(metadata=config(field_name='sub'), default=None)
    good: bool = False


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class ExecutiveDashboard:
    period: Optional[str] = None
    from_date: datetime.datetime = datetime.datetime(1, 1, 1)
    to_date: datetime.datetime = datetime.datetime(1, 1, 1)
    fy: int = 0
    kpis: List[ExecKpi] = field(default_factory=list)
    cost_vs_billing: List[ExecCostCategory] = field(default_factory=list)
    monthly: List[ExecMonthPoint] = field(default_factory=list)
    backlog: Optional[ExecBacklog] = None
    wip: List[ExecWipRow] = field(default_factory=list)
    pipeline: List[ExecPipelineStage] = field(default_factory=list)
    win_rate_pct: float = 0.0
    receivables: List[ExecAgingBucket] = field(default_factory=list)
    retainage_u_s_d: float = 0.0
    dso_days: int = 0
    safety: List[ExecSafetyMetric] = field(default_factory=list)


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class ExecutiveDashboardResponse:
    response_status: Optional[ResponseStatus] = None
    dashboard: Optional[ExecutiveDashboard] = None


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class ExecutiveDashboardRequest:
    period: Optional[str] = None
    region: Optional[str] = None
    fy: Optional[int] = None

Python ExecutiveDashboardRequest 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.

GET /v1/dashboards/executive HTTP/1.1 
Host: api.dev.dynamics.trendsic.com 
Accept: text/jsonl
HTTP/1.1 200 OK
Content-Type: text/jsonl
Content-Length: length

{"ResponseStatus":{"ErrorCode":"String","Message":"String","StackTrace":"String","Errors":[{"ErrorCode":"String","FieldName":"String","Message":"String","Meta":{"String":"String"}}],"Meta":{"String":"String"}},"Dashboard":{"Period":"String","FromDate":"0001-01-01T00:00:00.0000000","ToDate":"0001-01-01T00:00:00.0000000","Fy":0,"Kpis":[{"Key":"String","Label":"String","Value":"String","Sub_":"String","Delta":"String","DeltaUp":false,"HasDelta":false,"Good":false}],"CostVsBilling":[{"Name":"String","CostUSD":0,"BilledUSD":0}],"Monthly":[{"Month":"String","RevenueUSD":0,"CostUSD":0}],"Backlog":{"TotalUSD":0,"MonthsAhead":0,"AwardsYtdUSD":0,"BurnYtdUSD":0,"ByYear":[{"Year":"String","ValueUSD":0}]},"Wip":[{"ContractId":0,"Name":"String","Owner":"String","ValueUSD":0,"PctComplete":0,"BilledUSD":0,"OverUnderUSD":0,"MarginPct":0,"FadePts":0}],"Pipeline":[{"Stage":"String","ValueUSD":0,"Count":0}],"WinRatePct":0,"Receivables":[{"Bucket":"String","AmountUSD":0,"IsRetainage":false}],"RetainageUSD":0,"DsoDays":0,"Safety":[{"Label":"String","Value":"String","Sub_":"String","Good":false}]}}