FrameAppWS

EjecutaQueryRQ

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

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 EjecutaQueryRS:
    datos_consulta: Optional[List[Dict[str, Object]]] = None
    total_registros: Optional[int] = None
    total_grupos: Optional[int] = None
    summary_list: Optional[List[Object]] = 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: Optional[bool] = None


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


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class EjecutaQueryRQ:
    id_vista: Optional[int] = None
    datos_detalles: Optional[bool] = None
    parametros: Optional[Dict[str, Object]] = None
    lenguaje: Optional[Lenguajes] = None
    record_skip: Optional[int] = None
    record_take: Optional[int] = None
    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
    omitir_paginacion: Optional[bool] = None
    multi_empresa_sel: Optional[bool] = None


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

Python EjecutaQueryRQ DTOs

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

To embed the response in a jsonp callback, append ?callback=myCallback

HTTP + JSON

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

POST /Utilidades/Consultas/Listados/Ejecucion HTTP/1.1 
Host: ws.jimsnwa.com 
Accept: application/json
Content-Type: application/json
Content-Length: length

{"IDVista":0,"DatosDetalles":false,"Parametros":{"String":{}},"Lenguaje":"ES","RecordSkip":0,"RecordTake":0,"Filter":[{}],"Sort":{"selector":"String","desc":false},"Group":{"selector":"String","desc":false,"isExpanded":false},"SummaryGroupItems":[{"selector":"String","summaryType":"String"}],"SummaryTotalItems":[{"selector":"String","summaryType":"String"}],"omitirPaginacion":false,"multiEmpresaSel":false}

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

{"DatosConsulta":[{"String":{}}],"TotalRegistros":0,"TotalGrupos":0,"SummaryList":[{}]}