Getting Model Data

Below is the example of using the GetMs operation to get model data. The request contains an instance of opened modeling container and the data getting pattern. The response contains the workbook that contains model data.

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">
- <GetMs xmlns="http://www.fsight.ru/PP.SOM.Som">
- <tMs xmlns="">
  <id>S55!M!S!C1</id>
  </tMs>
- <tArg xmlns="">
- <pattern>
  <obInst>true</obInst>
- <item>
  <key>2803</key>
- <problem>
- <metamodel>
- <visualControllerPattern>
- <chainWorkbook>
- <pattern>
  <obInst>true</obInst>
- <cellsTable>
  <headers>true</headers>
- <slots>
  <elementName>true</elementName>
  </slots>
  <cells>true</cells>
  <emptyCells>false</emptyCells>
  <getCellDate>true</getCellDate>
  </cellsTable>
  </pattern>
  </chainWorkbook>
- <chainWorkbookEax>
- <pattern>
  <obInst>true</obInst>
  <dataEditState>true</dataEditState>
  <dataSource />
- <gridStyle>
  <all>false</all>
- <parts>
  <it>Table</it>
  </parts>
  </gridStyle>
  </pattern>
  </chainWorkbookEax>
  </visualControllerPattern>
  </metamodel>
  </problem>
  </item>
  </pattern>
- <execParams>
  <execFillChain>true</execFillChain>
  </execParams>
  </tArg>
  </GetMs>
  </s:Body>
  </s:Envelope>

SOAP response:

- <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
- <soapenv:Body>
- <GetMsResult 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>S55!M!S!C1</id>
  </id>
- <meta xmlns="">
- <obInst>
- <obDesc isShortcut="0">
  <i>MODELSPACE</i>
  <n>Modeling container</n>
  <k>1581</k>
  <c>5121</c>
  <p>1580</p>
  <h>0</h>
  </obDesc>
  </obInst>
  <dirty>0</dirty>
- <item>
  <k>2803</k>
  <id>TEMP_MODEL</id>
  <n>TEMP_MODEL</n>
  <vis>1</vis>
  <type>Problem</type>
- <problemMd>
- <metamodel>
  <k>2804</k>
- <visualController>
- <chainWorkbook>
- <id>
  <id>S55!M!S!W4</id>
  </id>
- <meta>
- <obInst>
- <obDesc isShortcut="0">
  <i>CHAINWB_2804</i>
  <n>ChainWorkBook</n>
  <k>2837</k>
  <c>2827</c>
  <p>2804</p>
  <h>0</h>
  </obDesc>
  </obInst>
  <dirty>1</dirty>
  <windowsPosition>Vertical</windowsPosition>
  <hasPivot>0</hasPivot>
  <hasLaner>1</hasLaner>
- <series count="2">
  <its />
  </series>
- <cellsTable columnCount="31" rowCount="2">
- <columns>
- <dims>
- <it>
  <k>0</k>
  <id>calendar</id>
  </it>
  </dims>
- <slots>
- <s date="1990-01-01">
- <els>
- <e>
  <k>YEARS:1.1.1990</k>
  <n>1990A1</n>
  </e>
  </els>
  </s>
- <s date="1991-01-01">
- <els>
- <e>
  <k>YEARS:1.1.1991</k>
  <n>1991A1</n>
  </e>
  </els>
  </s>
- <s date="1992-01-01">
- <els>
- <e>
  <k>YEARS:1.1.1992</k>
  <n>1992A1</n>
  </e>
  </els>
  </s>
- <s date="1993-01-01">
- <els>
- <e>
  <k>YEARS:1.1.1993</k>
  <n>1993A1</n>
  </e>
  </els>
  </s>
- <s date="1994-01-01">
- <els>
- <e>
  <k>YEARS:1.1.1994</k>
  <n>1994A1</n>
  </e>
  </els>
  </s>
- <s date="1995-01-01">
- <els>
- <e>
  <k>YEARS:1.1.1995</k>
  <n>1995A1</n>
  </e>
  </els>
  </s>
- <s date="1996-01-01">
- <els>
- <e>
  <k>YEARS:1.1.1996</k>
  <n>1996A1</n>
  </e>
  </els>
  </s>
- <s date="1997-01-01">
- <els>
- <e>
  <k>YEARS:1.1.1997</k>
  <n>1997A1</n>
  </e>
  </els>
  </s>
- <s date="1998-01-01">
- <els>
- <e>
  <k>YEARS:1.1.1998</k>
  <n>1998A1</n>
  </e>
  </els>
  </s>
- <s date="1999-01-01">
- <els>
- <e>
  <k>YEARS:1.1.1999</k>
  <n>1999A1</n>
  </e>
  </els>
  </s>
- <s date="2000-01-01">
- <els>
- <e>
  <k>YEARS:1.1.2000</k>
  <n>2000A1</n>
  </e>
  </els>
  </s>
- <s date="2001-01-01">
- <els>
- <e>
  <k>YEARS:1.1.2001</k>
  <n>2001A1</n>
  </e>
  </els>
  </s>
- <s date="2002-01-01">
- <els>
- <e>
  <k>YEARS:1.1.2002</k>
  <n>2002A1</n>
  </e>
  </els>
  </s>
- <s date="2003-01-01">
- <els>
- <e>
  <k>YEARS:1.1.2003</k>
  <n>2003A1</n>
  </e>
  </els>
  </s>
- <s date="2004-01-01">
- <els>
- <e>
  <k>YEARS:1.1.2004</k>
  <n>2004A1</n>
  </e>
  </els>
  </s>
- <s date="2005-01-01">
- <els>
- <e>
  <k>YEARS:1.1.2005</k>
  <n>2005A1</n>
  </e>
  </els>
  </s>
- <s date="2006-01-01">
- <els>
- <e>
  <k>YEARS:1.1.2006</k>
  <n>2006A1</n>
  </e>
  </els>
  </s>
- <s date="2007-01-01">
- <els>
- <e>
  <k>YEARS:1.1.2007</k>
  <n>2007A1</n>
  </e>
  </els>
  </s>
- <s date="2008-01-01">
- <els>
- <e>
  <k>YEARS:1.1.2008</k>
  <n>2008A1</n>
  </e>
  </els>
  </s>
- <s date="2009-01-01">
- <els>
- <e>
  <k>YEARS:1.1.2009</k>
  <n>2009A1</n>
  </e>
  </els>
  </s>
- <s date="2010-01-01">
- <els>
- <e>
  <k>YEARS:1.1.2010</k>
  <n>2010A1</n>
  </e>
  </els>
  </s>
- <s date="2011-01-01">
- <els>
- <e>
  <k>YEARS:1.1.2011</k>
  <n>2011A1</n>
  </e>
  </els>
  </s>
- <s date="2012-01-01">
- <els>
- <e>
  <k>YEARS:1.1.2012</k>
  <n>2012A1</n>
  </e>
  </els>
  </s>
- <s date="2013-01-01">
- <els>
- <e>
  <k>YEARS:1.1.2013</k>
  <n>2013A1</n>
  </e>
  </els>
  </s>
- <s date="2014-01-01">
- <els>
- <e>
  <k>YEARS:1.1.2014</k>
  <n>2014A1</n>
  </e>
  </els>
  </s>
- <s date="2015-01-01">
- <els>
- <e>
  <k>YEARS:1.1.2015</k>
  <n>2015A1</n>
  </e>
  </els>
  </s>
- <s date="2016-01-01">
- <els>
- <e>
  <k>YEARS:1.1.2016</k>
  <n>2016A1</n>
  </e>
  </els>
  </s>
- <s date="2017-01-01">
- <els>
- <e>
  <k>YEARS:1.1.2017</k>
  <n>2017A1</n>
  </e>
  </els>
  </s>
- <s date="2018-01-01">
- <els>
- <e>
  <k>YEARS:1.1.2018</k>
  <n>2018A1</n>
  </e>
  </els>
  </s>
- <s date="2019-01-01">
- <els>
- <e>
  <k>YEARS:1.1.2019</k>
  <n>2019A1</n>
  </e>
  </els>
  </s>
- <s date="2020-01-01">
- <els>
- <e>
  <k>YEARS:1.1.2020</k>
  <n>2020A1</n>
  </e>
  </els>
  </s>
  </slots>
  </columns>
- <rows>
- <dims>
- <it>
  <k>0</k>
  <id>series</id>
  </it>
  </dims>
- <slots>
- <s>
- <els>
- <e>
  <k>MyOutputVavable</k>
  <n>MyOutputVavable</n>
  </e>
  </els>
  </s>
- <s>
- <els>
- <e>
  <k>MyInputVavable</k>
  <n>MyInputVavable</n>
  </e>
  </els>
  </s>
  </slots>
  </rows>
- <cells>
  <c v="4.000000" dt="3" row="0" column="0" date="1990-01-01" />
  <c v="3.000000" dt="3" row="0" column="2" date="1992-01-01" />
  <c v="2.000000" dt="3" row="0" column="3" date="1993-01-01" />
  <c v="3.800000" dt="3" row="0" column="4" date="1994-01-01" />
  <c v="0" dt="3" row="0" column="5" date="1995-01-01" />
  <c v="2.000000" dt="3" row="0" column="7" date="1997-01-01" />
  <c v="1.100000" dt="3" row="0" column="8" date="1998-01-01" />
  <c v="5.400000" dt="3" row="0" column="9" date="1999-01-01" />
  <c v="1.000000" dt="3" row="0" column="10" date="2000-01-01" />
  <c v="-1.700000" dt="3" row="0" column="11" date="2001-01-01" />
  <c v="7.200000" dt="3" row="0" column="12" date="2002-01-01" />
  <c v="-1.000000" dt="3" row="0" column="13" date="2003-01-01" />
  <c v="5.000000" dt="3" row="0" column="14" date="2004-01-01" />
  <c v="0.200000" dt="3" row="0" column="15" date="2005-01-01" />
  <c v="2.208075" dt="3" row="0" column="16" date="2006-01-01" />
  <c v="-0.500000" dt="3" row="0" column="17" date="2007-01-01" />
  <c v="3.200000" dt="3" row="0" column="18" date="2008-01-01" />
  <c v="2.000000" dt="3" row="0" column="19" date="2009-01-01" />
  <c v="3.000000" dt="3" row="0" column="20" date="2010-01-01" />
  <c v="5.700000" dt="3" row="1" column="0" date="1990-01-01" />
  <c v="2.600000" dt="3" row="1" column="1" date="1991-01-01" />
  <c v="5.300000" dt="3" row="1" column="2" date="1992-01-01" />
  <c v="1.600000" dt="3" row="1" column="3" date="1993-01-01" />
  <c v="5.000000" dt="3" row="1" column="4" date="1994-01-01" />
  <c v="0.200000" dt="3" row="1" column="5" date="1995-01-01" />
  <c v="6.600000" dt="3" row="1" column="6" date="1996-01-01" />
  <c v="-0.500000" dt="3" row="1" column="7" date="1997-01-01" />
  <c v="3.200000" dt="3" row="1" column="8" date="1998-01-01" />
  <c v="2.000000" dt="3" row="1" column="9" date="1999-01-01" />
  <c v="3.000000" dt="3" row="1" column="10" date="2000-01-01" />
  <c v="6.200000" dt="3" row="1" column="11" date="2001-01-01" />
  <c v="7.100000" dt="3" row="1" column="12" date="2002-01-01" />
  <c v="5.800000" dt="3" row="1" column="13" date="2003-01-01" />
  <c v="2.800000" dt="3" row="1" column="14" date="2004-01-01" />
  <c v="3.700000" dt="3" row="1" column="15" date="2005-01-01" />
  <c v="4.454652" dt="3" row="1" column="16" date="2006-01-01" />
  <c v="3.200000" dt="3" row="1" column="17" date="2007-01-01" />
  <c v="3.600000" dt="3" row="1" column="18" date="2008-01-01" />
  <c v="8.000000" dt="3" row="1" column="19" date="2009-01-01" />
  <c v="7.000000" dt="3" row="1" column="20" date="2010-01-01" />
  </cells>
  </cellsTable>
  </meta>
  </chainWorkbook>
- <chainWorkbookEax>
- <id>
  <id />
  </id>
- <meta>
- <obInst>
- <obDesc isShortcut="0">
  <i>CHAINWB_2804</i>
  <n>ChainWorkBook</n>
  <k>2837</k>
  <c>2827</c>
  <p>2804</p>
  <h>0</h>
  </obDesc>
  </obInst>
  <dirty>1</dirty>
- <dataEditState>
  <readOnly>0</readOnly>
  <modified>0</modified>
  </dataEditState>
- <grid>
- <style>
- <table>
  <Name>EAX table style</Name>
- <Range>
  <left>0</left>
  <top>0</top>
  <width>0</width>
  <height>0</height>
  </Range>
- <Corner B="">
  <Text HA="-1" VA="-1" WW="-1" M="-3.78 -3.78 -3.78 -3.78" />
  <Fill C="#E6E9F5" />
  <Font F="Arial" S="10.670000" C="#000000" A="0" I="false" B="false" U="false" SO="false" />
  <Borders />
  <Hyperlink />
  </Corner>
- <FirstRow>
  <Width>1</Width>
- <Style B="">
  <Text HA="-1" VA="-1" WW="-1" M="-3.78 -3.78 -3.78 -3.78" />
  <Fill C="#FFFFFF" />
  <Font F="Arial" S="10.670000" C="#000000" A="0" I="false" B="false" U="false" SO="false" />
  <Borders />
  <Hyperlink />
  </Style>
  </FirstRow>
- <SecondRow>
  <Width>1</Width>
- <Style B="">
  <Text HA="-1" VA="-1" WW="-1" M="-3.78 -3.78 -3.78 -3.78" />
  <Fill C="#EEEEEE" />
  <Font F="Arial" S="10.670000" C="#000000" A="0" I="false" B="false" U="false" SO="false" />
  <Borders />
  <Hyperlink />
  </Style>
  </SecondRow>
- <FirstColumn>
  <Width>1</Width>
  </FirstColumn>
- <SecondColumn>
  <Width>1</Width>
  </SecondColumn>
- <HeaderRow>
  <Width>0</Width>
- <Style B="">
  <Text HA="-1" VA="-1" WW="-1" M="-3.78 -3.78 -3.78 -3.78" />
  <Fill C="#EEEEEE" />
  <Font F="Arial" S="10.670000" C="#000000" A="0" I="false" B="false" U="false" SO="false" />
- <Borders>
  <Border I="2" S="0" C="#BBBBBB" />
  <Border I="5" S="0" C="#BBBBBB" />
  <Border I="6" S="0" C="#FFFFFF" />
  <Border I="7" S="0" C="#FFFFFF" />
  </Borders>
  <Hyperlink />
  </Style>
  </HeaderRow>
- <HeaderColumn>
  <Width>1</Width>
- <Style B="">
  <Text HA="-1" VA="-1" WW="-1" M="-3.78 -3.78 -3.78 -3.78" />
  <Fill C="#E6E9F5" />
  <Font F="Arial" S="10.670000" C="#000000" A="0" I="false" B="false" U="false" SO="false" />
- <Borders>
  <Border I="3" S="0" C="#BBBBBB" />
  <Border I="4" S="0" C="#BBBBBB" />
  <Border I="6" S="0" C="#FFFFFF" />
  <Border I="7" S="0" C="#FFFFFF" />
  </Borders>
  <Hyperlink />
  </Style>
  </HeaderColumn>
- <FooterRow>
  <Width>0</Width>
  </FooterRow>
- <FooterColumn>
  <Width>0</Width>
  </FooterColumn>
  <PredefinedStyle>ExtBlueStriped</PredefinedStyle>
  <IsEmpty>0</IsEmpty>
  </table>
  </style>
  </grid>
  <windowsPosition>Vertical</windowsPosition>
  <hasPivot>0</hasPivot>
  </meta>
  </chainWorkbookEax>
  </visualController>
  </metamodel>
  </problemMd>
  </item>
  </meta>
  </GetMsResult>
  </soapenv:Body>
  </soapenv:Envelope>

JSON request:

    {
     "GetMs" : 
      {
       "tMs" : 
        {
         "id" : "S65!M!S!C1"
        },
       "tArg" : 
        {
         "pattern" : 
          {
           "obInst" : "true",
           "item" : 
            {
             "key" : "2803",
             "problem" : 
              {
               "metamodel" : 
                {
                 "visualControllerPattern" : 
                  {
                   "chainWorkbook" : 
                    {
                     "pattern" : 
                      {
                       "obInst" : "true",
                       "cellsTable" : 
                        {
                         "headers" : "true",
                         "slots" : 
                          {
                           "elementName" : "true"
                          },
                         "cells" : "true",
                         "emptyCells" : "false",
                         "getCellDate" : "true"
                        }
                      }
                    },
                   "chainWorkbookEax" : 
                    {
                     "pattern" : 
                      {
                       "obInst" : "true",
                       "dataEditState" : "true",
                       "dataSource" : "",
                       "gridStyle" : 
                        {
                         "all" : "false",
                         "parts" : 
                          {
                           "it" : "Table"
                          }
                        }
                      }
                    }
                  }
                }
              }
            }
          },
         "execParams" : 
          {
           "execFillChain" : "true"
          }
        }
      }
    }
  }
}

JSON response:

    {
     "GetMsResult" : 
      {
       "id" : 
        {
         "id" : "S65!M!S!C1"
        },
       "meta" : 
        {
         "obInst" : 
          {
           "obDesc" : 
            {
             "@isShortcut" : "0",
             "i" : "MODELSPACE",
"n" : "Modeling container",
"k" : "1581",
"c" : "5121",
"p" : "1580",
"h" : "0"
}
},
"dirty" : "0",
"item" : 
{
           "k" : "2803",
           "id" : "TEMP_MODEL",
           "n" : "TEMP_MODEL",
           "vis" : "1",
           "type" : "Problem",
           "problemMd" : 
            {
             "metamodel" : 
              {
               "k" : "2804",
               "visualController" : 
                {
                 "chainWorkbook" : 
                  {
                   "id" : 
                    {
                     "id" : "S65!M!S!W3"
                    },
                   "meta" : 
                    {
                     "obInst" : 
                      {
                       "obDesc" : 
                        {
                         "@isShortcut" : "0",
                         "i" : "CHAINWB_2804",
                         "n" : "ChainWorkBook",
                         "k" : "2837",
                         "c" : "2827",
                         "p" : "2804",
                         "h" : "0"
                        }
                      },
                     "dirty" : "1",
                     "windowsPosition" : "Vertical",
                     "hasPivot" : "0",
                     "hasLaner" : "1",
                     "series" : 
                      {
                       "@count" : "2",
                       "its" : ""
                      },
                     "cellsTable" : 
                      {
                       "@rowCount" : "2",
                       "@columnCount" : "31",
                       "columns" : 
                        {
                         "dims" : 
                          {
                           "it" : 
                            {
                             "k" : "0",
                             "id" : "calendar"
                            }
                          },
                         "slots" : 
                          {
                           "s" : 
                            [
                              {
                               "@date" : "1990-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.1990",
                                   "n" : "1990A1"
                                  }
                                }
                              },
                              {
                               "@date" : "1991-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.1991",
                                   "n" : "1991A1"
                                  }
                                }
                              },
                              {
                               "@date" : "1992-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.1992",
                                   "n" : "1992A1"
                                  }
                                }
                              },
                              {
                               "@date" : "1993-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.1993",
                                   "n" : "1993A1"
                                  }
                                }
                              },
                              {
                               "@date" : "1994-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.1994",
                                   "n" : "1994A1"
                                  }
                                }
                              },
                              {
                               "@date" : "1995-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.1995",
                                   "n" : "1995A1"
                                  }
                                }
                              },
                              {
                               "@date" : "1996-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.1996",
                                   "n" : "1996A1"
                                  }
                                }
                              },
                              {
                               "@date" : "1997-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.1997",
                                   "n" : "1997A1"
                                  }
                                }
                              },
                              {
                               "@date" : "1998-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.1998",
                                   "n" : "1998A1"
                                  }
                                }
                              },
                              {
                               "@date" : "1999-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.1999",
                                   "n" : "1999A1"
                                  }
                                }
                              },
                              {
                               "@date" : "2000-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.2000",
                                   "n" : "2000A1"
                                  }
                                }
                              },
                              {
                               "@date" : "2001-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.2001",
                                   "n" : "2001A1"
                                  }
                                }
                              },
                              {
                               "@date" : "2002-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.2002",
                                   "n" : "2002A1"
                                  }
                                }
                              },
                              {
                               "@date" : "2003-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.2003",
                                   "n" : "2003A1"
                                  }
                                }
                              },
                              {
                               "@date" : "2004-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.2004",
                                   "n" : "2004A1"
                                  }
                                }
                              },
                              {
                               "@date" : "2005-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.2005",
                                   "n" : "2005A1"
                                  }
                                }
                              },
                              {
                               "@date" : "2006-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.2006",
                                   "n" : "2006A1"
                                  }
                                }
                              },
                              {
                               "@date" : "2007-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.2007",
                                   "n" : "2007A1"
                                  }
                                }
                              },
                              {
                               "@date" : "2008-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.2008",
                                   "n" : "2008A1"
                                  }
                                }
                              },
                              {
                               "@date" : "2009-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.2009",
                                   "n" : "2009A1"
                                  }
                                }
                              },
                              {
                               "@date" : "2010-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.2010",
                                   "n" : "2010A1"
                                  }
                                }
                              },
                              {
                               "@date" : "2011-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.2011",
                                   "n" : "2011A1"
                                  }
                                }
                              },
                              {
                               "@date" : "2012-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.2012",
                                   "n" : "2012A1"
                                  }
                                }
                              },
                              {
                               "@date" : "2013-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.2013",
                                   "n" : "2013A1"
                                  }
                                }
                              },
                              {
                               "@date" : "2014-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.2014",
                                   "n" : "2014A1"
                                  }
                                }
                              },
                              {
                               "@date" : "2015-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.2015",
                                   "n" : "2015A1"
                                  }
                                }
                              },
                              {
                               "@date" : "2016-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.2016",
                                   "n" : "2016A1"
                                  }
                                }
                              },
                              {
                               "@date" : "2017-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.2017",
                                   "n" : "2017A1"
                                  }
                                }
                              },
                              {
                               "@date" : "2018-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.2018",
                                   "n" : "2018A1"
                                  }
                                }
                              },
                              {
                               "@date" : "2019-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.2019",
                                   "n" : "2019A1"
                                  }
                                }
                              },
                              {
                               "@date" : "2020-01-01",
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "YEARS:1.1.2020",
                                   "n" : "2020A1"
                                  }
                                }
                              }
                            ]
                          }
                        },
                       "rows" : 
                        {
                         "dims" : 
                          {
                           "it" : 
                            {
                             "k" : "0",
                             "id" : "series"
                            }
                          },
                         "slots" : 
                          {
                           "s" : 
                            [
                              {
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "MyInputVavable",
                                   "n" : "MyInputVavable"
                                  }
                                }
                              },
                              {
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "MyOutputVavable",
                                   "n" : "MyOutputVavable"
                                  }
                                }
                              }
                            ]
                          }
                        },
                       "cells" : 
                        {
                         "c" : 
                          [
                            {
                             "@v" : "1.000000",
                             "@dt" : "3",
                             "@row" : "0",
                             "@column" : "0",
                             "@date" : "1990-01-01"
                            },
                            {
                             "@v" : "-1.700000",
                             "@dt" : "3",
                             "@row" : "0",
                             "@column" : "1",
                             "@date" : "1991-01-01"
                            },
                            {
                             "@v" : "7.200000",
                             "@dt" : "3",
                             "@row" : "0",
                             "@column" : "2",
                             "@date" : "1992-01-01"
                            },
                            {
                             "@v" : "-1.000000",
                             "@dt" : "3",
                             "@row" : "0",
                             "@column" : "3",
                             "@date" : "1993-01-01"
                            },
                            {
                             "@v" : "5.000000",
                             "@dt" : "3",
                             "@row" : "0",
                             "@column" : "4",
                             "@date" : "1994-01-01"
                            },
                            {
                             "@v" : "0.200000",
                             "@dt" : "3",
                             "@row" : "0",
                             "@column" : "5",
                             "@date" : "1995-01-01"
                            },
                            {
                             "@v" : "6.600000",
                             "@dt" : "3",
                             "@row" : "0",
                             "@column" : "6",
                             "@date" : "1996-01-01"
                            },
                            {
                             "@v" : "-0.500000",
                             "@dt" : "3",
                             "@row" : "0",
                             "@column" : "7",
                             "@date" : "1997-01-01"
                            },
                            {
                             "@v" : "3.200000",
                             "@dt" : "3",
                             "@row" : "0",
                             "@column" : "8",
                             "@date" : "1998-01-01"
                            },
                            {
                             "@v" : "2.000000",
                             "@dt" : "3",
                             "@row" : "0",
                             "@column" : "9",
                             "@date" : "1999-01-01"
                            },
                            {
                             "@v" : "3.000000",
                             "@dt" : "3",
                             "@row" : "0",
                             "@column" : "10",
                             "@date" : "2000-01-01"
                            },
                            {
                             "@v" : "6.200000",
                             "@dt" : "3",
                             "@row" : "0",
                             "@column" : "11",
                             "@date" : "2001-01-01"
                            },
                            {
                             "@v" : "7.100000",
                             "@dt" : "3",
                             "@row" : "0",
                             "@column" : "12",
                             "@date" : "2002-01-01"
                            },
                            {
                             "@v" : "5.800000",
                             "@dt" : "3",
                             "@row" : "0",
                             "@column" : "13",
                             "@date" : "2003-01-01"
                            },
                            {
                             "@v" : "2.800000",
                             "@dt" : "3",
                             "@row" : "0",
                             "@column" : "14",
                             "@date" : "2004-01-01"
                            },
                            {
                             "@v" : "3.700000",
                             "@dt" : "3",
                             "@row" : "0",
                             "@column" : "15",
                             "@date" : "2005-01-01"
                            },
                            {
                             "@v" : "4.454652",
                             "@dt" : "3",
                             "@row" : "0",
                             "@column" : "16",
                             "@date" : "2006-01-01"
                            },
                            {
                             "@v" : "3.200000",
                             "@dt" : "3",
                             "@row" : "0",
                             "@column" : "17",
                             "@date" : "2007-01-01"
                            },
                            {
                             "@v" : "3.600000",
                             "@dt" : "3",
                             "@row" : "0",
                             "@column" : "18",
                             "@date" : "2008-01-01"
                            },
                            {
                             "@v" : "8.000000",
                             "@dt" : "3",
                             "@row" : "0",
                             "@column" : "19",
                             "@date" : "2009-01-01"
                            },
                            {
                             "@v" : "7.000000",
                             "@dt" : "3",
                             "@row" : "0",
                             "@column" : "20",
                             "@date" : "2010-01-01"
                            },
                            {
                             "@v" : "4.000000",
                             "@dt" : "3",
                             "@row" : "1",
                             "@column" : "0",
                             "@date" : "1990-01-01"
                            },
                            {
                             "@v" : "3.000000",
                             "@dt" : "3",
                             "@row" : "1",
                             "@column" : "2",
                             "@date" : "1992-01-01"
                            },
                            {
                             "@v" : "2.000000",
                             "@dt" : "3",
                             "@row" : "1",
                             "@column" : "3",
                             "@date" : "1993-01-01"
                            },
                            {
                             "@v" : "3.800000",
                             "@dt" : "3",
                             "@row" : "1",
                             "@column" : "4",
                             "@date" : "1994-01-01"
                            },
                            {
                             "@v" : "1.200000",
                             "@dt" : "3",
                             "@row" : "1",
                             "@column" : "5",
                             "@date" : "1995-01-01"
                            },
                            {
                             "@v" : "2.000000",
                             "@dt" : "3",
                             "@row" : "1",
                             "@column" : "7",
                             "@date" : "1997-01-01"
                            },
                            {
                             "@v" : "1.100000",
                             "@dt" : "3",
                             "@row" : "1",
                             "@column" : "8",
                             "@date" : "1998-01-01"
                            },
                            {
                             "@v" : "5.400000",
                             "@dt" : "3",
                             "@row" : "1",
                             "@column" : "9",
                             "@date" : "1999-01-01"
                            },
                            {
                             "@v" : "1.000000",
                             "@dt" : "3",
                             "@row" : "1",
                             "@column" : "10",
                             "@date" : "2000-01-01"
                            },
                            {
                             "@v" : "-1.700000",
                             "@dt" : "3",
                             "@row" : "1",
                             "@column" : "11",
                             "@date" : "2001-01-01"
                            },
                            {
                             "@v" : "7.200000",
                             "@dt" : "3",
                             "@row" : "1",
                             "@column" : "12",
                             "@date" : "2002-01-01"
                            },
                            {
                             "@v" : "-1.000000",
                             "@dt" : "3",
                             "@row" : "1",
                             "@column" : "13",
                             "@date" : "2003-01-01"
                            },
                            {
                             "@v" : "5.000000",
                             "@dt" : "3",
                             "@row" : "1",
                             "@column" : "14",
                             "@date" : "2004-01-01"
                            },
                            {
                             "@v" : "0.200000",
                             "@dt" : "3",
                             "@row" : "1",
                             "@column" : "15",
                             "@date" : "2005-01-01"
                            },
                            {
                             "@v" : "6.600000",
                             "@dt" : "3",
                             "@row" : "1",
                             "@column" : "16",
                             "@date" : "2006-01-01"
                            },
                            {
                             "@v" : "-0.500000",
                             "@dt" : "3",
                             "@row" : "1",
                             "@column" : "17",
                             "@date" : "2007-01-01"
                            },
                            {
                             "@v" : "3.200000",
                             "@dt" : "3",
                             "@row" : "1",
                             "@column" : "18",
                             "@date" : "2008-01-01"
                            },
                            {
                             "@v" : "2.000000",
                             "@dt" : "3",
                             "@row" : "1",
                             "@column" : "19",
                             "@date" : "2009-01-01"
                            },
                            {
                             "@v" : "3.000000",
                             "@dt" : "3",
                             "@row" : "1",
                             "@column" : "20",
                             "@date" : "2010-01-01"
                            }
                          ]
                        }
                      }
                    }
                  },
                 "chainWorkbookEax" : 
                  {
                   "id" : 
                    {
                     "id" : ""
                    },
                   "meta" : 
                    {
                     "obInst" : 
                      {
                       "obDesc" : 
                        {
                         "@isShortcut" : "0",
                         "i" : "CHAINWB_2804",
                         "n" : "ChainWorkBook",
                         "k" : "2837",
                         "c" : "2827",
                         "p" : "2804",
                         "h" : "0"
                        }
                      },
                     "dirty" : "1",
                     "dataEditState" : 
                      {
                       "readOnly" : "0",
                       "modified" : "0"
                      },
                     "grid" : 
                      {
                       "style" : 
                        {
                         "table" : 
                          {
                           "Name" : "EAX table style",
                           "Range" : 
                            {
                             "left" : "0",
                             "top" : "0",
                             "width" : "0",
                             "height" : "0"
                            },
                           "Corner" : 
                            {
                             "@B" : "",
                             "Text" : 
                              {
                               "@VA" : "-1",
                               "@HA" : "-1",
                               "@M" : "-3.78 -3.78 -3.78 -3.78",
                               "@WW" : "-1"
                              },
                             "Fill" : 
                              {
                               "@C" : "#E6E9F5"
                              },
                             "Font" : 
                              {
                               "@A" : "0",
                               "@B" : "false",
                               "@SO" : "false",
                               "@S" : "10.670000",
                               "@C" : "#000000",
                               "@U" : "false",
                               "@F" : "Arial",
                               "@I" : "false"
                              },
                             "Borders" : "",
                             "Hyperlink" : ""
                            },
                           "FirstRow" : 
                            {
                             "Width" : "1",
                             "Style" : 
                              {
                               "@B" : "",
                               "Text" : 
                                {
                                 "@VA" : "-1",
                                 "@HA" : "-1",
                                 "@M" : "-3.78 -3.78 -3.78 -3.78",
                                 "@WW" : "-1"
                                },
                               "Fill" : 
                                {
                                 "@C" : "#FFFFFF"
                                },
                               "Font" : 
                                {
                                 "@A" : "0",
                                 "@B" : "false",
                                 "@SO" : "false",
                                 "@S" : "10.670000",
                                 "@C" : "#000000",
                                 "@U" : "false",
                                 "@F" : "Arial",
                                 "@I" : "false"
                                },
                               "Borders" : "",
                               "Hyperlink" : ""
                              }
                            },
                           "SecondRow" : 
                            {
                             "Width" : "1",
                             "Style" : 
                              {
                               "@B" : "",
                               "Text" : 
                                {
                                 "@VA" : "-1",
                                 "@HA" : "-1",
                                 "@M" : "-3.78 -3.78 -3.78 -3.78",
                                 "@WW" : "-1"
                                },
                               "Fill" : 
                                {
                                 "@C" : "#EEEEEE"
                                },
                               "Font" : 
                                {
                                 "@A" : "0",
                                 "@B" : "false",
                                 "@SO" : "false",
                                 "@S" : "10.670000",
                                 "@C" : "#000000",
                                 "@U" : "false",
                                 "@F" : "Arial",
                                 "@I" : "false"
                                },
                               "Borders" : "",
                               "Hyperlink" : ""
                              }
                            },
                           "FirstColumn" : 
                            {
                             "Width" : "1"
                            },
                           "SecondColumn" : 
                            {
                             "Width" : "1"
                            },
                           "HeaderRow" : 
                            {
                             "Width" : "0",
                             "Style" : 
                              {
                               "@B" : "",
                               "Text" : 
                                {
                                 "@VA" : "-1",
                                 "@HA" : "-1",
                                 "@M" : "-3.78 -3.78 -3.78 -3.78",
                                 "@WW" : "-1"
                                },
                               "Fill" : 
                                {
                                 "@C" : "#EEEEEE"
                                },
                               "Font" : 
                                {
                                 "@A" : "0",
                                 "@B" : "false",
                                 "@SO" : "false",
                                 "@S" : "10.670000",
                                 "@C" : "#000000",
                                 "@U" : "false",
                                 "@F" : "Arial",
                                 "@I" : "false"
                                },
                               "Borders" : 
                                {
                                 "Border" : 
                                  [
                                    {
                                     "@S" : "0",
                                     "@C" : "#BBBBBB",
                                     "@I" : "2"
                                    },
                                    {
                                     "@S" : "0",
                                     "@C" : "#BBBBBB",
                                     "@I" : "5"
                                    },
                                    {
                                     "@S" : "0",
                                     "@C" : "#FFFFFF",
                                     "@I" : "6"
                                    },
                                    {
                                     "@S" : "0",
                                     "@C" : "#FFFFFF",
                                     "@I" : "7"
                                    }
                                  ]
                                },
                               "Hyperlink" : ""
                              }
                            },
                           "HeaderColumn" : 
                            {
                             "Width" : "1",
                             "Style" : 
                              {
                               "@B" : "",
                               "Text" : 
                                {
                                 "@VA" : "-1",
                                 "@HA" : "-1",
                                 "@M" : "-3.78 -3.78 -3.78 -3.78",
                                 "@WW" : "-1"
                                },
                               "Fill" : 
                                {
                                 "@C" : "#E6E9F5"
                                },
                               "Font" : 
                                {
                                 "@A" : "0",
                                 "@B" : "false",
                                 "@SO" : "false",
                                 "@S" : "10.670000",
                                 "@C" : "#000000",
                                 "@U" : "false",
                                 "@F" : "Arial",
                                 "@I" : "false"
                                },
                               "Borders" : 
                                {
                                 "Border" : 
                                  [
                                    {
                                     "@S" : "0",
                                     "@C" : "#BBBBBB",
                                     "@I" : "3"
                                    },
                                    {
                                     "@S" : "0",
                                     "@C" : "#BBBBBB",
                                     "@I" : "4"
                                    },
                                    {
                                     "@S" : "0",
                                     "@C" : "#FFFFFF",
                                     "@I" : "6"
                                    },
                                    {
                                     "@S" : "0",
                                     "@C" : "#FFFFFF",
                                     "@I" : "7"
                                    }
                                  ]
                                },
                               "Hyperlink" : ""
                              }
                            },
                           "FooterRow" : 
                            {
                             "Width" : "0"
                            },
                           "FooterColumn" : 
                            {
                             "Width" : "0"
                            },
                           "PredefinedStyle" : "ExtBlueStriped",
                           "IsEmpty" : "0"
                          }
                        }
                      },
                     "windowsPosition" : "Vertical",
                     "hasPivot" : "0"
                    }
                  }
                }
              }
            }
          }
        }
public static GetWbkMdResult GetMsModelData(MsId ms, ulong modelKey)
{
    var getMsOp = new GetMs();
    getMsOp.tMs = ms;
    getMsOp.tArg = new GetMsArg()
    {  // Set data get pattern
        pattern = new MsMdPattern()
        {
            item = new MsItemPattern()
            {  // Specify model key
                key = modelKey,

                problem = new MsProblemPattern()
                {
                    metamodel = new MsMetaModelPattern()
                    {   // Set pattern for visual building of metamodel
                        visualControllerPattern = new MsMetaModelVisualControllerPattern()
                        {   // Set internal workbook getting pattern
                            chainWorkbook = new GetWbkMdArg()
                            {
                                pattern = new WbkMdPattern()
                                {

                                    cellsTable = new WbkCellsTablePattern()
                                    {
                                        headers = true,
                                        cells = true,
                                        emptyCells = false,
                                        slots = new PvtSlotPattern() {elementName = true }
                                    }
                                }
                            },// Set internal express view getting pattern
                            chainWorkbookEax = new GetEaxMdArg()

                            {
                                pattern = new EaxMdPattern()
                                {
                                    dataSource = new CubeDataSourcePattern() { },
                                    dataEditState = true,
                                    gridStyle = new EaxGridStylePattern()
                                    {
                                        all = false,
                                        parts = new EaxGridStylePart[] { EaxGridStylePart.Table }
                                    }

                                }
                            }
                        }
                    }
                }
            }
        },// Set operation execution parameters
        execParams = new MsMdExecParams(){execFillChain = true}
    };
    // Create a proxy object for operation execution

    var somClient = new SomPortTypeClient();
    // Get model data
    GetMsResult getMsResult = somClient.GetMs(getMsOp);
    // Output model data
    MsMetaModelVisualController metaVC = getMsResult.meta.item.problemMd.metamodel.visualController;
    WbkCellsTable table = metaVC.chainWorkbook.meta.cellsTable;
    int ar = table.cells.Length;
    Console.WriteLine("Date - Value");
    ulong row = 0; ulong rowAft = 2; int nowRow = 0;
    for (int i = 0; i

See also:

GetMs: Operation