FrameAppWS

<back to all web services

EjecutaQueryRQ

Requires Authentication
The following routes are available for this service:
All Verbs/Utilidades/Consultas/Listados/Ejecucion
namespace Administrador.Modelo.DevExtreme

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

    [<AllowNullLiteral>]
    type EjecutaQueryRS() = 
        member val DatosConsulta:ResizeArray<Dictionary<String,Object>> = new ResizeArray<Dictionary<String,Object>>() with get,set
        member val TotalRegistros:Int32 = new Int32() with get,set
        member val TotalGrupos:Int32 = new Int32() with get,set
        member val SummaryList:ResizeArray<Object> = new ResizeArray<Object>() with get,set

    type Lenguajes =
        | ES = 0
        | PT = 1
        | EN = 2

    [<AllowNullLiteral>]
    type gridSortOptions() = 
        member val selector:String = null with get,set
        member val desc:Boolean = new Boolean() with get,set

    [<AllowNullLiteral>]
    type gridGroupOptions() = 
        member val selector:String = null with get,set
        member val desc:Boolean = new Boolean() with get,set
        member val isExpanded:Boolean = new Boolean() with get,set

    [<AllowNullLiteral>]
    type EjecutaQueryRQ() = 
        member val IDVista:Int32 = new Int32() with get,set
        member val DatosDetalles:Boolean = new Boolean() with get,set
        member val Parametros:Dictionary<String, Object> = new Dictionary<String, Object>() with get,set
        member val Lenguaje:Lenguajes = new Lenguajes() with get,set
        member val RecordSkip:Int32 = new Int32() with get,set
        member val RecordTake:Int32 = new Int32() with get,set
        member val Filter:ResizeArray<Object> = new ResizeArray<Object>() with get,set
        member val Sort:gridSortOptions = null with get,set
        member val Group:gridGroupOptions = null with get,set
        member val SummaryGroupItems:gridSummaryOptions[] = [||] with get,set
        member val SummaryTotalItems:gridSummaryOptions[] = [||] with get,set
        member val omitirPaginacion:Boolean = new Boolean() with get,set
        member val multiEmpresaSel:Boolean = new Boolean() with get,set

    [<AllowNullLiteral>]
    type gridSummaryOptions() = 
        member val selector:String = null with get,set
        member val summaryType:String = null with get,set

F# 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: 
	[
		{
			
		}
	]
}