FrameAppWS

<back to all web services

EjecutaQueryRQ

Requires Authentication
The following routes are available for this service:
All Verbs/Utilidades/Consultas/Listados/Ejecucion
import Foundation
import ServiceStack

public class EjecutaQueryRQ : Codable
{
    public var idVista:Int
    public var datosDetalles:Bool
    public var parametros:[String:Object] = [:]
    public var lenguaje:Lenguajes
    public var recordSkip:Int
    public var recordTake:Int
    public var filter:[Object] = []
    public var sort:gridSortOptions
    public var group:gridGroupOptions
    public var summaryGroupItems:[gridSummaryOptions] = []
    public var summaryTotalItems:[gridSummaryOptions] = []
    public var omitirPaginacion:Bool
    public var multiEmpresaSel:Bool

    required public init(){}
}

public enum Lenguajes : String, Codable
{
    case ES
    case PT
    case EN
}

public class gridSortOptions : Codable
{
    public var selector:String
    public var desc:Bool

    required public init(){}
}

public class gridGroupOptions : Codable
{
    public var selector:String
    public var desc:Bool
    public var isExpanded:Bool

    required public init(){}
}

public class gridSummaryOptions : Codable
{
    public var selector:String
    public var summaryType:String

    required public init(){}
}

public class EjecutaQueryRS : Codable
{
    public var datosConsulta:[[String:Object]] = []
    public var totalRegistros:Int
    public var totalGrupos:Int
    public var summaryList:[Object] = []

    required public init(){}
}


Swift EjecutaQueryRQ 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/Consultas/Listados/Ejecucion HTTP/1.1 
Host: soluser-recaudo.sgsas.co 
Accept: text/csv
Content-Type: text/csv
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: text/csv
Content-Length: length

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