Getting Query Execution Result: the GetDbCommand Operation

Below is the example of using the GetDbCommand operation to get a data set obtained on executing the Query repository object. The request contains moniker of opened object instance and the pattern indicating whether to get the output data set. The response contains requested information.

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

</tDbCommand>

</pattern>

</tArg>

</GetDbCommand>

</s:Body>

</s:Envelope>

SOAP response:

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

<soapenv:Body>

</id>

<n>Query</n>

</obDesc>

</obInst>

<type>Query</type>

<rows>

<its>

<r>

<it>Russia</it>

<it>Russian ruble (RUB)</it>

</r>

<r>

<it>United States of America</it>

<it>United States dollar ($) (USD)</it>

</r>

</its>

</rows>

</meta>

</GetDbCommandResult>

</soapenv:Body>

</soapenv:Envelope>

JSON request:

{
 "GetDbCommand" : 
  {
   "tDbCommand" : 
    {
     "id" : "S2!M!S!M1"
    },
   "tArg" : 
    {
     "pattern" : 
      {
       "obInst" : "true",
       "rows" : "true"
      }
    }
  }
}

JSON response:

{
 "GetDbCommandResult" : 
  {
   "id" : 
    {
     "id" : "S2!M!S!M1"
    },
   "meta" : 
    {
     "obInst" : 
      {
       "obDesc" : 
        {
         "@fullUrl" : "\/",
         "@isShortcut" : "0",
         "@isLink" : "0",
         "i" : "OBJ9051",
         "n" : "Query",
         "k" : "9051",
         "c" : "770",
         "p" : "9050",
         "h" : "0"
        }
      },
     "dirty" : "0",
     "type" : "Query",
     "rows" : 
      {
       "its" : 
        {
         "r" : 
          [
            {
             "it" : 
              [
                "RU",
                "Russia",
                "143666931",
                "17125187",
                "Russian ruble (RUB)"
              ]
            },
            {
             "it" : 
              [
                "US",
                "United States of America",
                "320194478",
                "9519431",
                "United States dollar ($) (USD)"
              ]
            }
          ]
        }
      }
    }
  }
}

    public static GetDbCommandResult GetQueryResult(DbCommandId moniker)
    {
        var somClient = new SomPortTypeClient(); //Proxy object for operation execution
        //Operation execution parameters
        var tGet = new GetDbCommand()
        {
            tArg = new GetDbCommandArg()
            {
                pattern = new DbCommandMdPattern()
                {
                    rows = true
                }
            },
            tDbCommand = moniker
        };
        //Get data
        var tResult = somClient.GetDbCommand(tGet);
        return tResult;
    }