SetEtlUnpivot

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

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

<tEtl xmlns="">

  <id>ENAIMHDOPOEIGOAEIKGJBOMLGNPEKPJEOIFKLAKCKCFCJHKN!M!S!LBCNODJDOPOEIGOAEAACBDDFIJKHDGKNEHKAKNNDFDEABINKC</id>

  </tEtl>

<tArg xmlns="">

<props>

<stringDataFormat>

  <useSystem>true</useSystem>

  </stringDataFormat>

  <typeGuessRows>100</typeGuessRows>

  <autoFillMode>Strings</autoFillMode>

  <leftBegin>1</leftBegin>

  <leftEnd>3</leftEnd>

  <headTop>7</headTop>

  <headBottom>7</headBottom>

  <headColumn>-1</headColumn>

  <dataTop>8</dataTop>

  <dataWidth>1</dataWidth>

  <dataRight>-1</dataRight>

  <dataBottom>-1</dataBottom>

  <fieldsNames>true</fieldsNames>

  <fieldNamesRow>7</fieldNamesRow>

  <fieldNamesColumn>3</fieldNamesColumn>

  </props>

  </tArg>

  </SetEtlUnpivot>

  </s:Body>

  </s:Envelope>

SOAP response:

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

<soapenv:Body>

<SetEtlUnpivotResult 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>ENAIMHDOPOEIGOAEIKGJBOMLGNPEKPJEOIFKLAKCKCFCJHKN!M!S!LBCNODJDOPOEIGOAEAACBDDFIJKHDGKNEHKAKNNDFDEABINKC</id>

  </id>

<props xmlns="">

<stringDataFormat>

  <useSystem>1</useSystem>

  <dateFormat>DD.MM.YYYY</dateFormat>

  <decimalSeparator>,</decimalSeparator>

  <usePredefinedDateFormats>1</usePredefinedDateFormats>

  </stringDataFormat>

  <typeGuessRows>100</typeGuessRows>

  <autoFillMode>Strings</autoFillMode>

  <filterIf />

  <leftBegin>1</leftBegin>

  <leftEnd>3</leftEnd>

  <headTop>7</headTop>

  <headBottom>7</headBottom>

  <headColumn>-1</headColumn>

  <dataTop>8</dataTop>

  <dataWidth>1</dataWidth>

  <dataRight>-1</dataRight>

  <dataBottom>-1</dataBottom>

  <fixedCells />

  <fieldsNames>1</fieldsNames>

  <fieldNamesRow>7</fieldNamesRow>

  <fieldNamesColumn>3</fieldNamesColumn>

  </props>

  </SetEtlUnpivotResult>

  </soapenv:Body>

  </soapenv:Envelope>

JSON request:

{
 "SetEtlUnpivot" : 
  {
   "tEtl" : 
    {
     "id" : "ENAIMHDOPOEIGOAEIKGJBOMLGNPEKPJEOIFKLAKCKCFCJHKN!M!S!LBCNODJDOPOEIGOAEAACBDDFIJKHDGKNEHKAKNNDFDEABINKC"
    },
   "tArg" : 
    {
     "props" : 
      {
       "stringDataFormat" : 
        {
         "useSystem" : "true"
        },
       "typeGuessRows" : "100",
       "autoFillMode" : "Strings",
       "leftBegin" : "1",
       "leftEnd" : "3",
       "headTop" : "7",
       "headBottom" : "7",
       "headColumn" : "-1",
       "dataTop" : "8",
       "dataWidth" : "1",
       "dataRight" : "-1",
       "dataBottom" : "-1",
       "fieldsNames" : "true",
       "fieldNamesRow" : "7",
       "fieldNamesColumn" : "3"
      }
    }
  }
}

JSON response:

{
 "SetEtlUnpivotResult" : 
  {
   "id" : 
    {
     "id" : "ENAIMHDOPOEIGOAEIKGJBOMLGNPEKPJEOIFKLAKCKCFCJHKN!M!S!LBCNODJDOPOEIGOAEAACBDDFIJKHDGKNEHKAKNNDFDEABINKC"
    },
   "props" : 
    {
     "stringDataFormat" : 
      {
       "useSystem" : "1",
       "dateFormat" : "DD.MM.YYYY",
       "decimalSeparator" : ",",
       "usePredefinedDateFormats" : "1"
      },
     "typeGuessRows" : "100",
     "autoFillMode" : "Strings",
     "filterIf" : "",
     "leftBegin" : "1",
     "leftEnd" : "3",
     "headTop" : "7",
     "headBottom" : "7",
     "headColumn" : "-1",
     "dataTop" : "8",
     "dataWidth" : "1",
     "dataRight" : "-1",
     "dataBottom" : "-1",
     "fixedCells" : "",
     "fieldsNames" : "1",
     "fieldNamesRow" : "7",
     "fieldNamesColumn" : "3"
    }
  }
}

public static SetEtlUnpivotResult SetEtlUnpivot(string moniker)
{
    var somClient = new SomPortTypeClient(); // Proxy object for operation execution
    // Operation execution parameters
    var tSet = new SetEtlUnpivot()
    {
        tArg = new SetEtlUnpivotArg()
        {
            props = new DtProviderUnpivot()
            {
                stringDataFormat = new DtProviderDataFormat()
                {
                    useSystem = true
                },
                typeGuessRows = 100,
                autoFillMode = DtAutoFillMode.Strings,
                leftBegin = 1,
                leftEnd = 3,
                headTop = 7,
                headBottom = 7,
                headColumn = -1,
                dataTop = 8,
                dataWidth = 1,
                dataRight = -1,
                dataBottom = -1,
                fieldsNames = true,
                fieldNamesRow = 7,
                fieldNamesColumn = 3
            }
        },
        tEtl = new EtlId() { id = moniker }
    };
    // Change data extraction settings in the crosstab mode
    var result = somClient.SetEtlUnpivot(tSet);
    return result;
}