FrameAppWS

EjecutaScriptBDRQ

The following routes are available for this service:
All Verbs	/Utilidades/EjecutaScriptBD

Imports System
Imports System.Collections
Imports System.Collections.Generic
Imports System.Runtime.Serialization
Imports ServiceStack
Imports ServiceStack.DataAnnotations
Imports Administrador.Modelo.Tipos
Imports Administrador.Modelo.Contexto

Namespace Global

    Namespace Administrador.Modelo.Contexto

        <DataContract>
        Public Partial Class LogScriptsBD
            <DataMember>
            Public Overridable Property CodigoServidor As Decimal

            <DataMember>
            Public Overridable Property CodigoDetalle As Decimal

            <DataMember>
            Public Overridable Property CodigoLog As Decimal

            <DataMember>
            Public Overridable Property CodigoScript As Decimal

            <DataMember>
            Public Overridable Property SQL As String

            <DataMember>
            Public Overridable Property SQLAnt As String

            <DataMember>
            Public Overridable Property NombreServidor As String

            <DataMember>
            Public Overridable Property Mensaje As String

            <DataMember>
            Public Overridable Property FechaEjecucion As Date

            <DataMember>
            Public Overridable Property LoginAplica As String

            <DataMember>
            Public Overridable Property Estado As String
        End Class
    End Namespace

    Namespace Administrador.Modelo.Tipos

        Public Partial Class EjecutaScriptBDRQ
            Public Overridable Property CodigoScript As Decimal
        End Class

        Public Partial Class EjecutaScriptBDRS
            Public Sub New()
                LogScript = New List(Of LogScriptsBD)
            End Sub

            Public Overridable Property LogScript As List(Of LogScriptsBD)
            Public Overridable Property [Error] As String
        End Class
    End Namespace
End Namespace

VB.NET 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"}