GetPivotHeaderMetaData

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">

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

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

<tArg xmlns="">

<headerSettings>

<filter>

  <enabled>false</enabled>

  <suppressEmptyCells>false</suppressEmptyCells>

  <suppressZeroCells>false</suppressZeroCells>

  <suppressNoNumericCells>false</suppressNoNumericCells>

  </filter>

  </headerSettings>

  <separated>0</separated>

  </tArg>

  </GetPivotHeaderMetaData>

  </s:Body>

  </s:Envelope>

SOAP-ответ:

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

<soapenv:Body>

<GetPivotHeaderMetaDataResult 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">

<headerSettings xmlns="">

<filter>

  <enabled>1</enabled>

  <suppressEmptyCells>0</suppressEmptyCells>

  <suppressZeroCells>0</suppressZeroCells>

  <suppressNoNumericCells>0</suppressNoNumericCells>

  </filter>

  </headerSettings>

  <separated xmlns="">1</separated>

  </GetPivotHeaderMetaDataResult>

  </soapenv:Body>

  </soapenv:Envelope>

JSON-запрос:

{
 "GetPivotHeaderMetaData" : 
  {
   "mon" : "FCJKECDEBBGOFOAENKBHCHAOHGPDFHHEPJAKMBIGJNLFCJOB!M!S!PLHCGKDDEBBGOFOAENCPCGCHBJGOFDLNEIJMPDIHNAGKFLNGA!DataArea!DataSources!1!DataSourceSlices!1!Pivot!TopHeader",
   "tArg" : 
    {
     "headerSettings" : 
      {
       "filter" : 
        {
         "enabled" : "false",
         "suppressEmptyCells" : "false",
         "suppressZeroCells" : "false",
         "suppressNoNumericCells" : "false"
        }
      },
     "separated" : "0"
    }
  }
}

JSON-ответ:

{
 "GetPivotHeaderMetaDataResult" : 
  {
   "headerSettings" : 
    {
     "filter" : 
      {
       "enabled" : "1",
       "suppressEmptyCells" : "0",
       "suppressZeroCells" : "0",
       "suppressNoNumericCells" : "0"
      }
    },
   "separated" : "1"
  }
}

public static PivotHeader GetPivotHeaderMeta(string moniker, uint dataSourceKey, uint sliceKey)
{
    var somClient = new SomPortTypeClient(); //Прокси-объект для выполнения операций
    //Параметры выполнения операции
    var tGet = new GetPivotHeaderMetaData()
    {
        tArg = new PivotHeader()
        {
            headerSettings = new PivotHeaderSettings()
            {
                filter = new PivotHeaderFilter()
                {
                    enabled = new bool(),
                    suppressEmptyCells = new bool(),
                    suppressNoNumericCells = new bool(),
                    suppressZeroCells = new bool()
                }
            },
            separated = new int()
        },
        mon = moniker + "!DataArea!DataSources!" + dataSourceKey.ToString() + "!DataSourceSlices!" + sliceKey.ToString() + "!Pivot!TopHeader"
    };
    //Получение информации о заголовке
    var result = somClient.GetPivotHeaderMetaData(tGet);
    return result;
}