FrameAppWS

<back to all web services

EjecutaCuboOpRemotasRQ

Requires Authentication
The following routes are available for this service:
All Verbs/Utilidades/Consultas/Cubos/OperacionesRemotas
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 EjecutaCuboOpRemotasRS:
    data: Optional[List[Dict[str, Object]]] = None
    total_count: int = 0
    error: Optional[str] = None
    sql: Optional[str] = None


class Lenguajes(str, Enum):
    ES = 'ES'
    PT = 'PT'
    EN = 'EN'


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class gridSortOptions:
    selector: Optional[str] = None
    desc: bool = False


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class EjecutaCuboOpRemotasRQ:
    id_vista: int = 0
    id_pivot: int = 0
    parametros: Optional[Dict[str, Object]] = None
    lenguaje: Optional[Lenguajes] = None
    skip: int = 0
    take: int = 0
    filter: Optional[List[Object]] = None
    sort: Optional[gridSortOptions] = None
    group: Optional[List[gridGroupOptions]] = None
    group_summary: Optional[List[gridSummaryOptions]] = None
    total_summary: Optional[List[gridSummaryOptions]] = None
    require_total_count: bool = False
    require_group_count: bool = False


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class gridGroupOptions:
    selector: Optional[str] = None
    desc: bool = False
    is_expanded: bool = False


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class gridSummaryOptions:
    selector: Optional[str] = None
    summary_type: Optional[str] = None

Python EjecutaCuboOpRemotasRQ DTOs

To override the Content-type in your clients, use the HTTP Accept Header, append the .xml suffix or ?format=xml

HTTP + XML

The following are sample HTTP requests and responses. The placeholders shown need to be replaced with actual values.

POST /Utilidades/Consultas/Cubos/OperacionesRemotas HTTP/1.1 
Host: soluser-recaudo.sgsas.co 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<EjecutaCuboOpRemotasRQ xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Administrador.Modelo.Tipos">
  <IDPivot>0</IDPivot>
  <IDVista>0</IDVista>
  <Lenguaje>ES</Lenguaje>
  <Parametros xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:KeyValueOfstringanyType>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value />
    </d2p1:KeyValueOfstringanyType>
  </Parametros>
  <filter xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:anyType />
  </filter>
  <group xmlns:d2p1="http://schemas.datacontract.org/2004/07/Administrador.Modelo.DevExtreme">
    <d2p1:gridGroupOptions>
      <d2p1:desc>false</d2p1:desc>
      <d2p1:isExpanded>false</d2p1:isExpanded>
      <d2p1:selector>String</d2p1:selector>
    </d2p1:gridGroupOptions>
  </group>
  <groupSummary xmlns:d2p1="http://schemas.datacontract.org/2004/07/Administrador.Modelo.DevExtreme">
    <d2p1:gridSummaryOptions>
      <d2p1:selector>String</d2p1:selector>
      <d2p1:summaryType>String</d2p1:summaryType>
    </d2p1:gridSummaryOptions>
  </groupSummary>
  <requireGroupCount>false</requireGroupCount>
  <requireTotalCount>false</requireTotalCount>
  <skip>0</skip>
  <sort xmlns:d2p1="http://schemas.datacontract.org/2004/07/Administrador.Modelo.DevExtreme">
    <d2p1:desc>false</d2p1:desc>
    <d2p1:selector>String</d2p1:selector>
  </sort>
  <take>0</take>
  <totalSummary xmlns:d2p1="http://schemas.datacontract.org/2004/07/Administrador.Modelo.DevExtreme">
    <d2p1:gridSummaryOptions>
      <d2p1:selector>String</d2p1:selector>
      <d2p1:summaryType>String</d2p1:summaryType>
    </d2p1:gridSummaryOptions>
  </totalSummary>
</EjecutaCuboOpRemotasRQ>
HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<EjecutaCuboOpRemotasRS xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Administrador.Modelo.Tipos">
  <Error>String</Error>
  <SQL>String</SQL>
  <data xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:ArrayOfKeyValueOfstringanyType>
      <d2p1:KeyValueOfstringanyType>
        <d2p1:Key>String</d2p1:Key>
        <d2p1:Value />
      </d2p1:KeyValueOfstringanyType>
    </d2p1:ArrayOfKeyValueOfstringanyType>
  </data>
  <totalCount>0</totalCount>
</EjecutaCuboOpRemotasRS>