Getting Information about ETL Task Execution Status: the GetEtl Operation

Below is the example of using the GetEtl operation for checking execution status of the ETL task, which was started by means of the SetEtl operation. The response contains the ETL task moniker. The response contains information about task execution status and information about possible execution errors.

SOAP request:

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

</tEtl>

</pattern>

</tArg>

</GetEtl>

</s:Body>

</s:Envelope>

SOAP response:

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

<soapenv:Body>

</id>

<i>ETL_INDICATOR</i>

<n>ETL task for factor loading</n>

</obDesc>

</obInst>

<state>Finished</state>

</execute>

</meta>

</GetEtlResult>

</soapenv:Body>

</soapenv:Envelope>

JSON request:

{
 "GetEtl" : 
  {
   "tEtl" : 
    {
     "id" : "S1!M!S!L1"
    },
   "tArg" : 
    {
     "pattern" : 
      {
       "obInst" : "true",
       "execute" : "true"
      }
    }
  }
}

JSON response:

{
 "GetEtlResult" : 
  {
   "id" : 
    {
     "id" : "S1!M!S!L1"
    },
   "meta" : 
    {
     "obInst" : 
      {
       "obDesc" : 
        {
         "@ds" : "",
         "@isShortcut" : "0",
         "@isLink" : "0",
         "@ver" : "3",
         "@hf" : "0",
         "i" : "ETL_INDICATOR",
         "n" : "ETL task for loading indicators",
         "k" : "7012",
         "c" : "4097",
         "p" : "7011",
         "h" : "0",
         "hasPrv" : "0",
         "ic" : "0",
         "isPermanent" : "1",
         "isTemp" : "0"
        }
      },
     "dirty" : "1",
     "execute" : 
      {
       "state" : "Finished",
       "progress" : "0",
       "totalRec" : "584",
       "errorRec" : "0",
       "executionTime" : "140"
      }
    }
  }
}

public static GetEtlResult GetETLExecutingInfo(EtlId moniker)
{
    var somClient = new SomPortTypeClient(); //Proxy object for operation execution
    //Operation execution parameters
    var tGet = new GetEtl()
    {
        tArg = new GetEtlArg()
        {
            pattern = new EtlMdPattern()
            {
                execute = true
            }
        },
        tEtl = moniker
    };
    //Get information about ETL task execution status
    var result = somClient.GetEtl(tGet);
    return result;
}