FrameAppWS

<back to all web services

EjecutaCuboOpRemotasRQ

Requires Authentication
The following routes are available for this service:
All Verbs/Utilidades/Consultas/Cubos/OperacionesRemotas
using System;
using System.Collections;
using System.Collections.Generic;
using System.Runtime.Serialization;
using ServiceStack;
using ServiceStack.DataAnnotations;
using Administrador.Modelo.Tipos;
using Administrador.Modelo.DevExtreme;

namespace Administrador.Modelo.DevExtreme
{
    public partial class gridGroupOptions
    {
        public virtual string selector { get; set; }
        public virtual bool desc { get; set; }
        public virtual bool isExpanded { get; set; }
    }

    public partial class gridSortOptions
    {
        public virtual string selector { get; set; }
        public virtual bool desc { get; set; }
    }

    public partial class gridSummaryOptions
    {
        public virtual string selector { get; set; }
        public virtual string summaryType { get; set; }
    }

}

namespace Administrador.Modelo.Tipos
{
    public partial class EjecutaCuboOpRemotasRQ
    {
        public EjecutaCuboOpRemotasRQ()
        {
            Parametros = new Dictionary<string, Object>{};
            filter = new List<Object>{};
            group = new gridGroupOptions[]{};
            groupSummary = new gridSummaryOptions[]{};
            totalSummary = new gridSummaryOptions[]{};
        }

        public virtual int IDVista { get; set; }
        public virtual int IDPivot { get; set; }
        public virtual Dictionary<string, Object> Parametros { get; set; }
        public virtual Lenguajes Lenguaje { get; set; }
        public virtual int skip { get; set; }
        public virtual int take { get; set; }
        public virtual List<Object> filter { get; set; }
        public virtual gridSortOptions sort { get; set; }
        public virtual gridGroupOptions[] group { get; set; }
        public virtual gridSummaryOptions[] groupSummary { get; set; }
        public virtual gridSummaryOptions[] totalSummary { get; set; }
        public virtual bool requireTotalCount { get; set; }
        public virtual bool requireGroupCount { get; set; }
    }

    public partial class EjecutaCuboOpRemotasRS
    {
        public EjecutaCuboOpRemotasRS()
        {
            data = new List<Dictionary<String,Object>>{};
        }

        public virtual List<Dictionary<String,Object>> data { get; set; }
        public virtual int totalCount { get; set; }
        public virtual string Error { get; set; }
        public virtual string SQL { get; set; }
    }

    public enum Lenguajes
    {
        ES,
        PT,
        EN,
    }

}

C# EjecutaCuboOpRemotasRQ 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/Cubos/OperacionesRemotas HTTP/1.1 
Host: soluser-recaudo.sgsas.co 
Accept: text/csv
Content-Type: text/csv
Content-Length: length

{"IDVista":0,"IDPivot":0,"Parametros":{"String":{}},"Lenguaje":"ES","skip":0,"take":0,"filter":[{}],"sort":{"selector":"String","desc":false},"group":[{"selector":"String","desc":false,"isExpanded":false}],"groupSummary":[{"selector":"String","summaryType":"String"}],"totalSummary":[{"selector":"String","summaryType":"String"}],"requireTotalCount":false,"requireGroupCount":false}
HTTP/1.1 200 OK
Content-Type: text/csv
Content-Length: length

{"data":[{"String":{}}],"totalCount":0,"Error":"String","SQL":"String"}