GetRepoParams

Syntax

RepoParamsResult GetRepoParams(MbId tMb, GetRepoParamsArg tArg)

Parameters

tMb. Repository connection moniker.

tArg. Operation execution parameters.

Description

The GetRepoParams operation gets repository parameters.

Comments

The operation gets the following parameters:

To execute the operation, in the tMb field specify the repository connection moniker, and in the tArg.pattern field specify the pattern, according to which various parameters are obtained. The moniker can be obtained on executing the OpenMetabase operation. The operation results in the requested parameters.

Example

The example of getting repository parameters. The request contains repository connection moniker and the pattern indicating whether it is necessary to get repository parameters. The response contains values of various parameters, except for the information about custom classes/events/methods.

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">
<GetRepoParams xmlns="http://www.fsight.ru/PP.SOM.Som">
<tMb xmlns="">
  <id>NCNODCBKFLJMFOAEBOCGFBINJBKLJKMEHIPDDDDKLEKKNJDH!M</id>
  </tMb>
<tArg xmlns="">
<pattern>
  <obInst>true</obInst>
  <all>true</all>
  </pattern>
  </tArg>
  </GetRepoParams>
  </s:Body>
  </s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<GetRepoParamsResult 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>NCNODCBKFLJMFOAEBOCGFBINJBKLJKMEHIPDDDDKLEKKNJDH!M</id>
  </id>
<meta xmlns="">
<innerParams>
<params>
<it>
  <k>-1</k>
  <id>METABASE_SERVER</id>
  <n>METABASE_SERVER</n>
  <vis>1</vis>
  <value>v-nrspo-mssql.dev.fs.fsight.world</value>
  <dt>1</dt>
  </it>
<it>
  <k>-1</k>
  <id>METABASE_DATABASE</id>
  <n>METABASE_DATABASE</n>
  <vis>1</vis>
  <value>Warehouse</value>
  <dt>1</dt>
  </it>
<it>
  <k>-1</k>
  <id>METABASE_FILEGROUP</id>
  <n>METABASE_FILEGROUP</n>
  <vis>1</vis>
  <value>PRIMARY</value>
  <dt>1</dt>
  </it>
<it>
  <k>-1</k>
  <id>METABASE_CASESENSITIVE</id>
  <n>METABASE_CASESENSITIVE</n>
  <vis>1</vis>
  <value>false</value>
  <dt>1</dt>
  </it>
<it>
  <k>-1</k>
  <id>METABASE_DATABASE_ONLY</id>
  <n>METABASE_DATABASE_ONLY</n>
  <vis>1</vis>
  <value>Warehouse</value>
  <dt>1</dt>
  </it>
<it>
  <k>-1</k>
  <id>METABASE_SCHEMA_ONLY</id>
  <n>METABASE_SCHEMA_ONLY</n>
  <vis>1</vis>
  <value>dbo</value>
  <dt>1</dt>
  </it>
<it>
  <k>-1</k>
  <id>METABASE_ODBCPARAMS</id>
  <n>METABASE_ODBCPARAMS</n>
  <vis>1</vis>
  <dt>1</dt>
  </it>
  </params>
  </innerParams>
<sharedParams>
  <IsShared>1</IsShared>
  <Url>http://v-shp-development.dev.fs.fsight.world</Url>
<params>
<it>
  <k>1</k>
  <id>GLOBAL_INT</id>
  <n>Constraint</n>
  <vis>1</vis>
  <value>600</value>
  <dt>2</dt>
  <binding>UI="IntegerEdit"</binding>
  </it>
  </params>
  </sharedParams>
<defParams>
<database ds="" isShortcut="0" isLink="0" ver="2" hf="0">
  <i>DB</i>
  <n>Database</n>
  <k>56</k>
  <c>513</c>
  <p>12363</p>
  <h>0</h>
  <hasPrv>0</hasPrv>
  <ic>0</ic>
  <trackElementDependents>0</trackElementDependents>
  </database>
<rdsDatabase ds="" isShortcut="0" isLink="0" ver="0" hf="0">
  <i>RDS</i>
  <n>MDM repository</n>
  <k>159</k>
  <c>4353</c>
  <p>51</p>
  <h>0</h>
  <hasPrv>0</hasPrv>
  <ic>0</ic>
  <trackElementDependents>0</trackElementDependents>
  </rdsDatabase>
<modelSpace ds="" isShortcut="0" isLink="0" ver="6" hf="0">
  <i>MS_DEFAULT</i>
  <n>Modeling container (default)</n>
  <k>20639</k>
  <c>5121</c>
  <p>14212</p>
  <h>0</h>
  <hasPrv>0</hasPrv>
  <ic>0</ic>
  <trackElementDependents>0</trackElementDependents>
  </modelSpace>
<topobase ds="" isShortcut="0" isLink="0" ver="0" hf="0">
  <i>OBJ36625</i>
  <n>Russian Federation_FO_en.svg.tbs</n>
  <k>36625</k>
  <c>3330</c>
  <p>36624</p>
  <h>0</h>
  <hasPrv>0</hasPrv>
  <ic>0</ic>
  <trackElementDependents>0</trackElementDependents>
  </topobase>
<dimensionImageList ds="" isShortcut="0" isLink="0" ver="0" hf="0">
  <i>OBJ1532</i>
  <n>Element icons</n>
  <k>1532</k>
  <c>3329</c>
  <p>51</p>
  <h>0</h>
  <hasPrv>0</hasPrv>
  <ic>0</ic>
  <trackElementDependents>0</trackElementDependents>
  </dimensionImageList>
  <emptySelectionAsFull>0</emptySelectionAsFull>
  <rdsElementCard>PropertyList</rdsElementCard>
  <selColor>#3258C9</selColor>
  <selBorderColor>#6B8E23</selBorderColor>
  <selTransparent>252</selTransparent>
  <defLocale>1049</defLocale>
  </defParams>
<errorParams>
  <mailAddress>suppport@fsight.ru</mailAddress>
  <handler />
  </errorParams>
  <usersMetaData />
<eventHandling>
  <eventHandlers>1</eventHandlers>
<expressReports>
  <enabled>1</enabled>
  <eventClass>EventsClass</eventClass>
  <eventObject>EXP_EVENT</eventObject>
  </expressReports>
  <updateHandler />
  </eventHandling>
<cacheParams>
  <autoClear>1</autoClear>
  <threshold>70</threshold>
  </cacheParams>
  </meta>
  </GetRepoParamsResult>
  </soapenv:Body>
  </soapenv:Envelope>

JSON request:

{
"GetRepoParams" :
{
"tMb" :
{
"id" : "NCNODCBKFLJMFOAEBOCGFBINJBKLJKMEHIPDDDDKLEKKNJDH!M"
},
"tArg" :
{
"pattern" :
{
"obInst" : "true",
"all" : "true"
}
}
}
}

JSON response:

{
"GetRepoParamsResult" :
{
"id" :
{
"id" : "NCNODCBKFLJMFOAEBOCGFBINJBKLJKMEHIPDDDDKLEKKNJDH!M"
},
"meta" :
{
"innerParams" :
{
"params" :
{
"it" :
[
{
"k" : "4294967295",
"id" : "METABASE_SERVER",
"n" : "METABASE_SERVER",
"vis" : "1",
"value" : "v-nrspo-mssql.dev.fs.fsight.world",
"dt" : "1"
},
{
"k" : "4294967295",
"id" : "METABASE_DATABASE",
"n" : "METABASE_DATABASE",
"vis" : "1",
"value" : "Warehouse",
"dt" : "1"
},
{
"k" : "4294967295",
"id" : "METABASE_FILEGROUP",
"n" : "METABASE_FILEGROUP",
"vis" : "1",
"value" : "PRIMARY",
"dt" : "1"
},
{
"k" : "4294967295",
"id" : "METABASE_CASESENSITIVE",
"n" : "METABASE_CASESENSITIVE",
"vis" : "1",
"value" : "false",
"dt" : "1"
},
{
"k" : "4294967295",
"id" : "METABASE_DATABASE_ONLY",
"n" : "METABASE_DATABASE_ONLY",
"vis" : "1",
"value" : "Warehouse",
"dt" : "1"
},
{
"k" : "4294967295",
"id" : "METABASE_SCHEMA_ONLY",
"n" : "METABASE_SCHEMA_ONLY",
"vis" : "1",
"value" : "dbo",
"dt" : "1"
},
{
"k" : "4294967295",
"id" : "METABASE_ODBCPARAMS",
"n" : "METABASE_ODBCPARAMS",
"vis" : "1",
"dt" : "1"
}
]
}
},
"sharedParams" :
{
"IsShared" : "1",
"Url" : "http:\/\/v-shp-development.dev.fs.fsight.world",
"params" :
{
"it" :
{
"k" : "1",
"id" : "GLOBAL_INT",
"n" : "Constraint",
"vis" : "1",
"value" : "600",
"dt" : "2",
"binding" : "UI="IntegerEdit""
}
}
},
"defParams" :
{
"database" :
{
"@ds" : "",
"@isShortcut" : "0",
"@isLink" : "0",
"@ver" : "2",
"@hf" : "0",
"i" : "DB",
"n" : "Database",
"k" : "56",
"c" : "513",
"p" : "12363",
"h" : "0",
"hasPrv" : "0",
"ic" : "0",
"trackElementDependents" : "0"
},
"rdsDatabase" :
{
"@ds" : "",
"@isShortcut" : "0",
"@isLink" : "0",
"@ver" : "0",
"@hf" : "0",
"i" : "RDS",
"n" : "MDM repository",
"k" : "159",
"c" : "4353",
"p" : "51",
"h" : "0",
"hasPrv" : "0",
"ic" : "0",
"trackElementDependents" : "0"
},
"modelSpace" :
{
"@ds" : "",
"@isShortcut" : "0",
"@isLink" : "0",
"@ver" : "6",
"@hf" : "0",
"i" : "MS_DEFAULT",
"n" : "Modeling container (default)",
"k" : "20639",
"c" : "5121",
"p" : "14212",
"h" : "0",
"hasPrv" : "0",
"ic" : "0",
"trackElementDependents" : "0"
},
"topobase" :
{
"@ds" : "",
"@isShortcut" : "0",
"@isLink" : "0",
"@ver" : "0",
"@hf" : "0",
"i" : "OBJ36625",
"n" : "Russian Federation_FO_en.svg.tbs",
"k" : "36625",
"c" : "3330",
"p" : "36624",
"h" : "0",
"hasPrv" : "0",
"ic" : "0",
"trackElementDependents" : "0"
},
"dimensionImageList" :
{
"@ds" : "",
"@isShortcut" : "0",
"@isLink" : "0",
"@ver" : "0",
"@hf" : "0",
"i" : "OBJ1532",
"n" : "Element icons",
"k" : "1532",
"c" : "3329",
"p" : "51",
"h" : "0",
"hasPrv" : "0",
"ic" : "0",
"trackElementDependents" : "0"
},
"emptySelectionAsFull" : "0",
"rdsElementCard" : "PropertyList",
"selColor" : "#3258C9",
"selBorderColor" : "#6B8E23",
"selTransparent" : "252",
"defLocale" : "1049"
},
"errorParams" :
{
"mailAddress" : "suppport@fsight.ru",
"handler" : ""
},
"usersMetaData" : "",
"eventHandling" :
{
"eventHandlers" : "1",
"expressReports" :
{
"enabled" : "1",
"eventClass" : "EventsClass",
"eventObject" : "EXP_EVENT"
},
"updateHandler" : ""
},
"cacheParams" :
{
"autoClear" : "1",
"threshold" : "70"
}
}
}
}
public static RepoParamsResult GetMBParameters(string moniker)
{
var somClient = new SomPortTypeClient(); //Proxy object for operation execution
//Operation execution parameters
var tGet = new GetRepoParams()
{
tArg = new GetRepoParamsArg()
{
pattern = new RepoParamsMdPattern()
{
all = true
}
},
tMb = new MbId() { id = moniker }
};
//Get repository parameters
var result = somClient.GetRepoParams(tGet);
return result;
}

See also:

Operations for Working with Repository