GetPivotMetaData

SOAP-запрос:

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">

<s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<GetPivotMetaData xmlns="http://www.fsight.ru/PP.SOM.Som">

  <mon xmlns="">FCJKECDEBBGOFOAENKBHCHAOHGPDFHHEPJAKMBIGJNLFCJOB!M!S!PLHCGKDDEBBGOFOAENCPCGCHBJGOFDLNEIJMPDIHNAGKFLNGA!DataArea!DataSources!1!DataSourceSlices!1!Pivot</mon>

<tArg xmlns="">

<dims>

<its>

<it>

  <k>-1</k>

  <id />

  <n />

  <position>Unknown</position>

  <index>0</index>

  </it>

  </its>

  </dims>

  </tArg>

  </GetPivotMetaData>

  </s:Body>

  </s:Envelope>

SOAP-ответ:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">

<soapenv:Body>

<GetPivotMetaDataResult xmlns="http://www.fsight.ru/PP.SOM.Som" xmlns:q1="http://www.fsight.ru/PP.SOM.Som" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<dims xmlns="">

<its>

<it>

  <k>5858</k>

  <id>FACTS</id>

  <n>Факты</n>

  <position>Fixed</position>

  <index>0</index>

  </it>

<it>

  <k>112</k>

  <id>CALENDAR</id>

  <n>Календарь</n>

  <position>Top</position>

  <index>0</index>

  </it>

<it>

  <k>116</k>

  <id>DIM_1</id>

  <n>Dim_1</n>

  <position>Left</position>

  <index>0</index>

  </it>

<it>

  <k>991</k>

  <id>DIM_2</id>

  <n>Dim_2</n>

  <position>Fixed</position>

  <index>1</index>

  </it>

  </its>

  </dims>

  <drillThrough xmlns="">0</drillThrough>

  </GetPivotMetaDataResult>

  </soapenv:Body>

  </soapenv:Envelope>

JSON-запрос:

{
 "GetPivotMetaData" : 
  {
   "mon" : "FCJKECDEBBGOFOAENKBHCHAOHGPDFHHEPJAKMBIGJNLFCJOB!M!S!PLHCGKDDEBBGOFOAENCPCGCHBJGOFDLNEIJMPDIHNAGKFLNGA!DataArea!DataSources!1!DataSourceSlices!1!Pivot",
   "tArg" : 
    {
     "dims" : 
      {
       "its" : 
        {
         "it" : 
          [
            {
             "k" : "-1",
             "id" : "",
             "n" : "",
             "position" : "Unknown",
             "index" : "0"
            }
          ]
        }
      }
    }
  }
}

JSON-ответ:

{
 "GetPivotMetaDataResult" : 
  {
   "dims" : 
    {
     "its" : 
      {
       "it" : 
        [
          {
           "k" : "5858",
           "id" : "FACTS",
           "n" : "Факты",
           "position" : "Fixed",
           "index" : "0"
          },
          {
           "k" : "112",
           "id" : "CALENDAR",
           "n" : "Календарь",
           "position" : "Top",
           "index" : "0"
          },
          {
           "k" : "116",
           "id" : "DIM_1",
           "n" : "Dim_1",
           "position" : "Left",
           "index" : "0"
          },
          {
           "k" : "991",
           "id" : "DIM_2",
           "n" : "Dim_2",
           "position" : "Fixed",
           "index" : "1"
          }
        ]
      }
    },
   "drillThrough" : "0"
  }
}

public static PivotMetaData GetPivotInfo(string moniker, uint dataSourceKey, uint sliceKey)
{
    var somClient = new SomPortTypeClient(); //Прокси-объект для выполнения операций
    //Параметры выполнения операции
    var tGet = new GetPivotMetaData()
    {
        tArg = new PivotMetaData()
        {
            dims = new PivotDimensions()
            {
                its = new PivotDimension[1]
                {
                    new PivotDimension()
                    {
                        k = uint.MaxValue,
                        id = "",
                        n = "",
                        position = PvtDimPos.Unknown,
                        index = 0
                    }
                }
            }
        },
        mon = moniker + "!DataArea!DataSources!" + dataSourceKey.ToString() + "!DataSourceSlices!" + sliceKey.ToString() + "!Pivot"
    };
    //Получение информации об основе среза
    var result = somClient.GetPivotMetaData(tGet);
    return result;
}