FrameAppWS

<back to all web services

EjecutaQueryRQ

Requires Authentication
The following routes are available for this service:
All Verbs/Utilidades/Consultas/Listados/Ejecucion
EjecutaQueryRQ Parameters:
NameParameterData TypeRequiredDescription
IDVistaqueryintNo
DatosDetallesqueryboolNo
ParametrosqueryDictionary<string, Object>No
LenguajequeryLenguajesNo
RecordSkipqueryintNo
RecordTakequeryintNo
FilterqueryList<Object>No
SortquerygridSortOptionsNo
GroupquerygridGroupOptionsNo
SummaryGroupItemsquerygridSummaryOptions[]No
SummaryTotalItemsquerygridSummaryOptions[]No
omitirPaginacionqueryboolNo
multiEmpresaSelqueryboolNo
Lenguajes Enum:
ES
PT
EN
gridSortOptions Parameters:
NameParameterData TypeRequiredDescription
selectorformstringNo
descformboolNo
gridGroupOptions Parameters:
NameParameterData TypeRequiredDescription
selectorformstringNo
descformboolNo
isExpandedformboolNo
gridSummaryOptions Parameters:
NameParameterData TypeRequiredDescription
selectorformstringNo
summaryTypeformstringNo
EjecutaQueryRS Parameters:
NameParameterData TypeRequiredDescription
DatosConsultaformList<Dictionary<String,Object>>No
TotalRegistrosformintNo
TotalGruposformintNo
SummaryListformList<Object>No

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

To embed the response in a jsonp callback, append ?callback=myCallback

HTTP + JSON

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: application/json
Content-Type: application/json
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: application/json
Content-Length: length

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