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 .jsv suffix or ?format=jsv

HTTP + JSV

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

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