POST | /v1/reports/Csv | Retrieve Report by ReportName and Filters and return as CSV |
---|
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 DashboardReportResult:
total_count: int = 0
report_result: Optional[List[Object]] = None
class ReportFilterType(str, Enum):
LIST = 'list'
LIST_LIKE = 'list_like'
DATE = 'date'
RANGE = 'range'
@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class ReportFilter:
type: Optional[ReportFilterType] = None
values: Optional[List[str]] = None
start: Optional[datetime.datetime] = None
end: Optional[datetime.datetime] = None
higher_than: Optional[int] = None
lower_than: Optional[int] = None
@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class DashboardCsvReportsRequest(IPost):
# @ApiMember(Description="Report Name", IsRequired=true, ParameterType="body")
report_name: Optional[str] = None
"""
Report Name
"""
# @ApiMember(Description="Filters", IsRequired=true, ParameterType="body")
filters: Dict[str, ReportFilter] = field(default_factory=dict)
"""
Filters
"""
Python DashboardCsvReportsRequest DTOs
To override the Content-type in your clients, use the HTTP Accept Header, append the .xml suffix or ?format=xml
The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.
POST /v1/reports/Csv HTTP/1.1
Host: uat-api-vehicle-mgt-mb-dhc.rapp-customers.co.uk
Accept: application/xml
Content-Type: application/xml
Content-Length: length
<DashboardCsvReportsRequest xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Mercedes.VehicleManagement.API.ServiceModel">
<Filters xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
<d2p1:KeyValueOfstringReportFilterI2Pv2xeL>
<d2p1:Key>String</d2p1:Key>
<d2p1:Value xmlns:d4p1="http://schemas.datacontract.org/2004/07/Mercedes.VehicleManagement.API.Shared.POCO">
<d4p1:End>0001-01-01T00:00:00</d4p1:End>
<d4p1:HigherThan>0</d4p1:HigherThan>
<d4p1:LowerThan>0</d4p1:LowerThan>
<d4p1:Start>0001-01-01T00:00:00</d4p1:Start>
<d4p1:Type>list</d4p1:Type>
<d4p1:Values i:nil="true" />
</d2p1:Value>
</d2p1:KeyValueOfstringReportFilterI2Pv2xeL>
</Filters>
<ReportName>String</ReportName>
</DashboardCsvReportsRequest>
HTTP/1.1 200 OK Content-Type: application/xml Content-Length: length <DashboardReportResult xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Mercedes.VehicleManagement.API.Shared.POCO"> <ReportResult xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays" i:nil="true" /> <TotalCount>0</TotalCount> </DashboardReportResult>