FrameAppWS

<back to all web services

EjecutaScriptBDRQ

Requires Authentication
The following routes are available for this service:
All Verbs/Utilidades/EjecutaScriptBD
namespace Administrador.Modelo.Contexto

open System
open System.Collections
open System.Collections.Generic
open System.Runtime.Serialization
open ServiceStack
open ServiceStack.DataAnnotations

    [<DataContract>]
    [<AllowNullLiteral>]
    type LogScriptsBD() = 
        [<DataMember>]
        member val CodigoServidor:Decimal = new Decimal() with get,set

        [<DataMember>]
        member val CodigoDetalle:Decimal = new Decimal() with get,set

        [<DataMember>]
        member val CodigoLog:Decimal = new Decimal() with get,set

        [<DataMember>]
        member val CodigoScript:Decimal = new Decimal() with get,set

        [<DataMember>]
        member val SQL:String = null with get,set

        [<DataMember>]
        member val SQLAnt:String = null with get,set

        [<DataMember>]
        member val NombreServidor:String = null with get,set

        [<DataMember>]
        member val Mensaje:String = null with get,set

        [<DataMember>]
        member val FechaEjecucion:DateTime = new DateTime() with get,set

        [<DataMember>]
        member val LoginAplica:String = null with get,set

        [<DataMember>]
        member val Estado:String = null with get,set

    [<AllowNullLiteral>]
    type EjecutaScriptBDRS() = 
        member val LogScript:ResizeArray<LogScriptsBD> = new ResizeArray<LogScriptsBD>() with get,set
        member val Error:String = null with get,set

    [<AllowNullLiteral>]
    type EjecutaScriptBDRQ() = 
        member val CodigoScript:Decimal = new Decimal() with get,set

F# EjecutaScriptBDRQ DTOs

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

HTTP + CSV

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: text/csv
Content-Type: text/csv
Content-Length: length

{"CodigoScript":0}
HTTP/1.1 200 OK
Content-Type: text/csv
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"}