Получение информации об объектах задачи ETL

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

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

<tEtl xmlns="">

  <id>S1!M!S!L1</id>

  </tEtl>

<tArg xmlns="">

<pattern>

  <obInst>true</obInst>

  <objects>Get</objects>

<object>

  <settings>true</settings>

  </object>

  </pattern>

  </tArg>

  </GetEtl>

  </s:Body>

  </s:Envelope>

SOAP-ответ:

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

<soapenv:Body>

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

<id xmlns="">

  <id>S1!M!S!L1</id>

  </id>

<meta xmlns="">

<obInst>

<obDesc isShortcut="0" isLink="0" fullUrl="/">

  <i>ETL_INDICATOR</i>

  <n>Задача ETL для загрузки показателей</n>

  <k>7012</k>

  <c>4097</c>

  <p>7011</p>

  <h>0</h>

  <isPermanent>1</isPermanent>

  <isTemp>0</isTemp>

  </obDesc>

  </obInst>

  <dirty>0</dirty>

<objects>

<its>

<it>

  <k>1</k>

  <id>PLAINDATAEXCELPROVIDER1</id>

  <n>Импорт из Excel (97-2003)1</n>

  <vis>1</vis>

  <type>PlainDataExcelProvider</type>

  <settings />

  </it>

<it>

  <k>3</k>

  <id>PLAINDATAMETABASECONSUMER1</id>

  <n>Приемник репозитория1</n>

  <vis>1</vis>

  <type>PlainDataMetabaseConsumer</type>

  <settings />

  </it>

<it>

  <k>5</k>

  <id>PLAINDATACOPY1</id>

  <n>Копирование данных1</n>

  <vis>1</vis>

  <type>PlainDataCopy</type>

<settings>

<plainDataCopy>

  <provider />

<consumer>

<obDesc isShortcut="0" isLink="0" fullUrl="/">

  <i>T_INDICATOR</i>

  <n>Таблица</n>

  <k>7013</k>

  <c>769</c>

  <p>7011</p>

  <h>0</h>

  </obDesc>

  <keyFieldNames />

  </consumer>

  <clearConsumer>1</clearConsumer>

  <commitCount>1024</commitCount>

  <actionOnProblem>DiscardInvalidRecords</actionOnProblem>

  </plainDataCopy>

  </settings>

  </it>

  </its>

  </objects>

  </meta>

  </GetEtlResult>

  </soapenv:Body>

  </soapenv:Envelope>

JSON-запрос:

{
 "GetEtl" : 
  {
   "tEtl" : 
    {
     "id" : "S1!M!S!L1"
    },
   "tArg" : 
    {
     "pattern" : 
      {
       "obInst" : "true",
       "objects" : "Get",
       "object" : 
        {
         "settings" : "true"
        }
      }
    }
  }
}

JSON-ответ:

{
 "GetEtlResult" : 
  {
   "id" : 
    {
     "id" : "S1!M!S!L1"
    },
   "meta" : 
    {
     "obInst" : 
      {
       "obDesc" : 
        {
         "@fullUrl" : "\/",
         "@isShortcut" : "0",
         "@isLink" : "0",
         "i" : "ETL_INDICATOR",
         "n" : "Задача ETL для загрузки показателей",
         "k" : "7012",
         "c" : "4097",
         "p" : "7011",
         "h" : "0",
         "isPermanent" : "1",
         "isTemp" : "0"
        }
      },
     "dirty" : "0",
     "objects" : 
      {
       "its" : 
        {
         "it" : 
          [
            {
             "k" : "1",
             "id" : "PLAINDATAEXCELPROVIDER1",
             "n" : "Импорт из Excel (97-2003)1",
             "vis" : "1",
             "type" : "PlainDataExcelProvider",
             "settings" : ""
            },
            {
             "k" : "3",
             "id" : "PLAINDATAMETABASECONSUMER1",
             "n" : "Приемник репозитория1",
             "vis" : "1",
             "type" : "PlainDataMetabaseConsumer",
             "settings" : ""
            },
            {
             "k" : "5",
             "id" : "PLAINDATACOPY1",
             "n" : "Копирование данных1",
             "vis" : "1",
             "type" : "PlainDataCopy",
             "settings" : 
              {
               "plainDataCopy" : 
                {
                 "provider" : "",
                 "consumer" : 
                  {
                   "obDesc" : 
                    {
                     "@fullUrl" : "\/",
                     "@isShortcut" : "0",
                     "@isLink" : "0",
                     "i" : "T_INDICATOR",
                     "n" : "Таблица",
                     "k" : "7013",
                     "c" : "769",
                     "p" : "7011",
                     "h" : "0"
                    },
                   "keyFieldNames" : ""
                  },
                 "clearConsumer" : "1",
                 "commitCount" : "1024",
                 "actionOnProblem" : "DiscardInvalidRecords"
                }
              }
            }
          ]
        }
      }
    }
  }
}

public static GetEtlResult GetETLInfo(EtlId moniker)
{
    var somClient = new SomPortTypeClient(); //Прокси-объект для выполнения операций
    //Параметры выполнения операции
    var tGet = new GetEtl()
    {
        tArg = new GetEtlArg()
        {
            pattern = new EtlMdPattern()
            {
                objects = ListOperation.Get,
                @object = new EtlObjectPattern() 
                {
                    settings = true
                }
            }
        },
        tEtl = moniker
    };
    //Получение информации об объектах задачи ETL
    var result = somClient.GetEtl(tGet);
    return result;
}