FrameAppWS

<back to all web services

EjecutaScriptBDRQ

Requires Authentication
The following routes are available for this service:
All Verbs/Utilidades/EjecutaScriptBD
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 LogScriptsBD:
    codigo_servidor: Decimal = decimal.Decimal(0)
    codigo_detalle: Decimal = decimal.Decimal(0)
    codigo_log: Decimal = decimal.Decimal(0)
    codigo_script: Decimal = decimal.Decimal(0)
    sql: Optional[str] = None
    sql_ant: Optional[str] = None
    nombre_servidor: Optional[str] = None
    mensaje: Optional[str] = None
    fecha_ejecucion: datetime.datetime = datetime.datetime(1, 1, 1)
    login_aplica: Optional[str] = None
    estado: Optional[str] = None


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class EjecutaScriptBDRS:
    log_script: Optional[List[LogScriptsBD]] = None
    error: Optional[str] = None


@dataclass_json(letter_case=LetterCase.CAMEL, undefined=Undefined.EXCLUDE)
@dataclass
class EjecutaScriptBDRQ:
    codigo_script: Decimal = decimal.Decimal(0)

Python EjecutaScriptBDRQ 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/EjecutaScriptBD HTTP/1.1 
Host: soluser-recaudo.sgsas.co 
Accept: application/json
Content-Type: application/json
Content-Length: length

{"CodigoScript":0}
HTTP/1.1 200 OK
Content-Type: application/json
Content-Length: length

{"LogScript":[{"CodigoServidor":0,"CodigoDetalle":0,"CodigoLog":0,"CodigoScript":0,"SQL":"String","SQLAnt":"String","NombreServidor":"String","Mensaje":"String","FechaEjecucion":null,"LoginAplica":"String","Estado":"String"}],"Error":"String"}