GetSemanticLayerETLSettings

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

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

  <mon xmlns="">GFAMHMEBEJKIGOAEDMJOMGJEACAMPAKEOILBFEHAKKCNIMJB!M!S!PDNPPFNEBEJKIGOAEAAODFDMMFLPIKLCEFLEAMAOHOABKNAHP!EtlSettings!0</mon>

<tArg xmlns="">

  <fileName>file1.xlsx</fileName>

<pages>

<its>

<it>

  <k>0</k>

  <n>Лист1</n>

<fields>

<its>

<it>

  <k>-1</k>

  <n />

  <type>2147483647</type>

  </it>

  </its>

  </fields>

  <checked>true</checked>

  </it>

  </its>

  </pages>

  <unionSources>false</unionSources>

  </tArg>

  </GetSemanticLayerETLSettings>

  </s:Body>

  </s:Envelope>

SOAP-ответ:

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

<soapenv:Body>

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

  <fileName xmlns="">file1.xlsx</fileName>

<pages xmlns="">

<its>

<it>

  <k>0</k>

  <n>Лист1</n>

<fields>

<its>

<it>

  <k>1</k>

  <n>Город</n>

  <type>1</type>

  </it>

<it>

  <k>2</k>

  <n>Предприятие</n>

  <type>1</type>

  </it>

<it>

  <k>3</k>

  <n>Показатель</n>

  <type>1</type>

  </it>

<it>

  <k>4</k>

  <n>Значение</n>

  <type>8</type>

  </it>

  </its>

  </fields>

  <checked>1</checked>

  </it>

  </its>

  </pages>

  <unionSources xmlns="">0</unionSources>

  </GetSemanticLayerETLSettingsResult>

  </soapenv:Body>

  </soapenv:Envelope>

JSON-запрос:

{
 "GetSemanticLayerETLSettings" : 
  {
   "mon" : "GFAMHMEBEJKIGOAEDMJOMGJEACAMPAKEOILBFEHAKKCNIMJB!M!S!PDNPPFNEBEJKIGOAEAAODFDMMFLPIKLCEFLEAMAOHOABKNAHP!EtlSettings!0",
   "tArg" : 
    {
     "fileName" : "file1.xlsx",
     "pages" : 
      {
       "its" : 
        {
         "it" : 
          [
            {
             "k" : "0",
             "n" : "Лист1",
             "fields" : 
              {
               "its" : 
                {
                 "it" : 
                  [
                    {
                     "k" : "-1",
                     "n" : "",
                     "type" : "2147483647"
                    }
                  ]
                }
              },
             "checked" : "true"
            }
          ]
        }
      },
     "unionSources" : "false"
    }
  }
}

JSON-ответ:

{
 "GetSemanticLayerETLSettingsResult" : 
  {
   "fileName" : "file1.xlsx",
   "pages" : 
    {
     "its" : 
      {
       "it" : 
        [
          {
           "k" : "0",
           "n" : "Лист1",
           "fields" : 
            {
             "its" : 
              {
               "it" : 
                [
                  {
                   "k" : "1",
                   "n" : "Город",
                   "type" : "1"
                  },
                  {
                   "k" : "2",
                   "n" : "Предприятие",
                   "type" : "1"
                  },
                  {
                   "k" : "3",
                   "n" : "Показатель",
                   "type" : "1"
                  },
                  {
                   "k" : "4",
                   "n" : "Значение",
                   "type" : "8"
                  }
                ]
              }
            },
           "checked" : "1"
          }
        ]
      }
    },
   "unionSources" : "0"
  }
}

public static SemanticLayerETLSettings GetSemanticLayerETLSettings(string moniker, SemanticLayerETLSettings getSettings, uint? indexFile = null)
{
    var somClient = new SomPortTypeClient(); // Прокси-объект для выполнения операций
    // Параметры выполнения операции
    var tGet = new GetSemanticLayerETLSettings()
    {
        tArg = getSettings,
        mon = moniker + "!EtlSettings" + ("!" + indexFile ?? null)
    };
    // Получение настроек импорта из файлов в таблицы модели данных
    var result = somClient.GetSemanticLayerETLSettings(tGet);
    return result;
}