FrameAppWS

EjecutaQueryBackRQ

The following routes are available for this service:
All Verbs	/Utilidades/Consultas/Listados/EjecucionBackground

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 EjecutaQueryBackgroundRS:
    empresa: Decimal = decimal.Decimal(0)
    sistema: Decimal = decimal.Decimal(0)
    login: Optional[str] = None
    app_adm: bool = False
    txt_s_q_l: Optional[str] = None
    url_archivo: Optional[str] = None
    success: bool = False
    error: 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 gridGroupOptions:
    selector: Optional[str] = None
    desc: bool = False
    is_expanded: bool = False


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class EjecutaQueryBackRQ:
    id_vista: int = 0
    datos_detalles: bool = False
    parametros: Optional[Dict[str, Object]] = None
    lenguaje: Optional[Lenguajes] = None
    record_skip: int = 0
    record_take: int = 0
    filter: Optional[List[Object]] = None
    sort: Optional[gridSortOptions] = None
    group: Optional[gridGroupOptions] = None
    summary_group_items: Optional[List[gridSummaryOptions]] = None
    summary_total_items: Optional[List[gridSummaryOptions]] = None


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

Python EjecutaQueryBackRQ 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/Listados/EjecucionBackground HTTP/1.1 
Host: soluser-recaudo.sgsas.co 
Accept: application/xml
Content-Type: application/xml
Content-Length: length

<EjecutaQueryBackRQ xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Administrador.Modelo.Tipos">
  <DatosDetalles>false</DatosDetalles>
  <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:desc>false</d2p1:desc>
    <d2p1:isExpanded>false</d2p1:isExpanded>
    <d2p1:selector>String</d2p1:selector>
  </Group>
  <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>
  <RecordSkip>0</RecordSkip>
  <RecordTake>0</RecordTake>
  <Sort xmlns:d2p1="http://schemas.datacontract.org/2004/07/Administrador.Modelo.DevExtreme">
    <d2p1:desc>false</d2p1:desc>
    <d2p1:selector>String</d2p1:selector>
  </Sort>
  <SummaryGroupItems 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>
  </SummaryGroupItems>
  <SummaryTotalItems 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>
  </SummaryTotalItems>
</EjecutaQueryBackRQ>

HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<EjecutaQueryBackgroundRS xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Administrador.Modelo.Tipos">
  <AppAdm>false</AppAdm>
  <Empresa>0</Empresa>
  <Error>String</Error>
  <Login>String</Login>
  <Sistema>0</Sistema>
  <Success>false</Success>
  <TxtSQL>String</TxtSQL>
  <URLArchivo>String</URLArchivo>
</EjecutaQueryBackgroundRS>