FrameAppWS

<back to all web services

EjecutaQueryRQ

Requires Authentication
The following routes are available for this service:
All Verbs/Utilidades/Consultas/Listados/Ejecucion
"use strict";
export class EjecutaQueryRS {
    /** @param {{DatosConsulta?:{ [index:string]: Object; }[],TotalRegistros?:number,TotalGrupos?:number,SummaryList?:Object[]}} [init] */
    constructor(init) { Object.assign(this, init) }
    /** @type {{ [index:string]: Object; }[]} */
    DatosConsulta;
    /** @type {number} */
    TotalRegistros;
    /** @type {number} */
    TotalGrupos;
    /** @type {Object[]} */
    SummaryList;
}
/** @typedef {'ES'|'PT'|'EN'} */
export var Lenguajes;
(function (Lenguajes) {
    Lenguajes["ES"] = "ES"
    Lenguajes["PT"] = "PT"
    Lenguajes["EN"] = "EN"
})(Lenguajes || (Lenguajes = {}));
export class gridSortOptions {
    /** @param {{selector?:string,desc?:boolean}} [init] */
    constructor(init) { Object.assign(this, init) }
    /** @type {string} */
    selector;
    /** @type {boolean} */
    desc;
}
export class gridGroupOptions {
    /** @param {{selector?:string,desc?:boolean,isExpanded?:boolean}} [init] */
    constructor(init) { Object.assign(this, init) }
    /** @type {string} */
    selector;
    /** @type {boolean} */
    desc;
    /** @type {boolean} */
    isExpanded;
}
export class EjecutaQueryRQ {
    /** @param {{IDVista?:number,DatosDetalles?:boolean,Parametros?:{ [index: string]: Object; },Lenguaje?:Lenguajes,RecordSkip?:number,RecordTake?:number,Filter?:Object[],Sort?:gridSortOptions,Group?:gridGroupOptions,SummaryGroupItems?:gridSummaryOptions[],SummaryTotalItems?:gridSummaryOptions[],omitirPaginacion?:boolean,multiEmpresaSel?:boolean}} [init] */
    constructor(init) { Object.assign(this, init) }
    /** @type {number} */
    IDVista;
    /** @type {boolean} */
    DatosDetalles;
    /** @type {{ [index: string]: Object; }} */
    Parametros;
    /** @type {Lenguajes} */
    Lenguaje;
    /** @type {number} */
    RecordSkip;
    /** @type {number} */
    RecordTake;
    /** @type {Object[]} */
    Filter;
    /** @type {gridSortOptions} */
    Sort;
    /** @type {gridGroupOptions} */
    Group;
    /** @type {gridSummaryOptions[]} */
    SummaryGroupItems;
    /** @type {gridSummaryOptions[]} */
    SummaryTotalItems;
    /** @type {boolean} */
    omitirPaginacion;
    /** @type {boolean} */
    multiEmpresaSel;
}
export class gridSummaryOptions {
    /** @param {{selector?:string,summaryType?:string}} [init] */
    constructor(init) { Object.assign(this, init) }
    /** @type {string} */
    selector;
    /** @type {string} */
    summaryType;
}

JavaScript EjecutaQueryRQ DTOs

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

HTTP + XML

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

<EjecutaQueryRQ xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Administrador.Modelo.Tipos">
  <DatosDetalles>false</DatosDetalles>
  <Filter xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:anyType />
  </Filter>
  <Group xmlns:d2p1="http://schemas.datacontract.org/2004/07/Administrador.Modelo.DevExtreme">
    <d2p1:desc>false</d2p1:desc>
    <d2p1:isExpanded>false</d2p1:isExpanded>
    <d2p1:selector>String</d2p1:selector>
  </Group>
  <IDVista>0</IDVista>
  <Lenguaje>ES</Lenguaje>
  <Parametros xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:KeyValueOfstringanyType>
      <d2p1:Key>String</d2p1:Key>
      <d2p1:Value />
    </d2p1:KeyValueOfstringanyType>
  </Parametros>
  <RecordSkip>0</RecordSkip>
  <RecordTake>0</RecordTake>
  <Sort xmlns:d2p1="http://schemas.datacontract.org/2004/07/Administrador.Modelo.DevExtreme">
    <d2p1:desc>false</d2p1:desc>
    <d2p1:selector>String</d2p1:selector>
  </Sort>
  <SummaryGroupItems xmlns:d2p1="http://schemas.datacontract.org/2004/07/Administrador.Modelo.DevExtreme">
    <d2p1:gridSummaryOptions>
      <d2p1:selector>String</d2p1:selector>
      <d2p1:summaryType>String</d2p1:summaryType>
    </d2p1:gridSummaryOptions>
  </SummaryGroupItems>
  <SummaryTotalItems xmlns:d2p1="http://schemas.datacontract.org/2004/07/Administrador.Modelo.DevExtreme">
    <d2p1:gridSummaryOptions>
      <d2p1:selector>String</d2p1:selector>
      <d2p1:summaryType>String</d2p1:summaryType>
    </d2p1:gridSummaryOptions>
  </SummaryTotalItems>
  <multiEmpresaSel>false</multiEmpresaSel>
  <omitirPaginacion>false</omitirPaginacion>
</EjecutaQueryRQ>

HTTP/1.1 200 OK
Content-Type: application/xml
Content-Length: length

<EjecutaQueryRS xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/Administrador.Modelo.Tipos">
  <DatosConsulta xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:ArrayOfKeyValueOfstringanyType>
      <d2p1:KeyValueOfstringanyType>
        <d2p1:Key>String</d2p1:Key>
        <d2p1:Value />
      </d2p1:KeyValueOfstringanyType>
    </d2p1:ArrayOfKeyValueOfstringanyType>
  </DatosConsulta>
  <SummaryList xmlns:d2p1="http://schemas.microsoft.com/2003/10/Serialization/Arrays">
    <d2p1:anyType />
  </SummaryList>
  <TotalGrupos>0</TotalGrupos>
  <TotalRegistros>0</TotalRegistros>
</EjecutaQueryRS>