Master Data Management with webMethods OneData : Working with webMethods OneData MDR : Appendix of Examples : getClassificationSchemeItemHierarchyByName
getClassificationSchemeItemHierarchyByName
Sample Input
<RepositoryId>CAPITOL</RepositoryId>
<UserId>admin</UserId>
<Password>1563472D29F72A2F0482818D662E31F8</Password>
<ClientId>1</ClientId>
<ProjectId>1</ProjectId>
<SchemaId>2</SchemaId>
<ClassificationScheme>
PersonalPropertyAsset_ClassFull_Code
</ClassificationScheme>
<ContextName>Generic</ContextName>
<NameColumnName/>
<ExcludeAuditColumns>true</ExcludeAuditColumns>
<IncludeAdministeredItems>false</ IncludeAdministeredItems>
Sample Output
<?xml version="1.0" encoding="UTF-8" ?>
<OUTPUT>
<DATA>
<ADMIN_ITEM>
<RECORD>
 <COLUMN>
  <NAME>ADMIN_ITEM_TYP_ID</NAME>
  <VALUE>9</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>ADMIN_ITEM_TYP_ID_DESC</NAME>
  <VALUE><![CDATA[Classification Scheme]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>ITEM_NM</NAME>
  <VALUE><![CDATA[PersonalPropertyAsset_ClassFull_Code]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VER_NR</NAME>
  <VALUE>1</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>ITEM_ID</NAME>
  <VALUE>6020</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CURRNT_VER_IND</NAME>
  <VALUE>0</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CREATION_DT</NAME>
  <VALUE>2006-05-16 15:00:26</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>FLD_DELETE</NAME>
  <VALUE>0</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LST_DEL_DT</NAME>
  <VALUE>2006-05-16 15:00:26</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>S2P_TRN_DT</NAME>
  <VALUE>2006-05-16 15:00:26</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CREAT_USR_ID</NAME>
  <VALUE><![CDATA[ADMIN]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LST_UPD_USR_ID</NAME>
  <VALUE><![CDATA[ADMIN]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LST_UPD_DT</NAME>
  <VALUE>2006-05-16 15:00:26</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CREAT_DT</NAME>
  <VALUE>2006-05-16 15:00:28</VALUE>
 </COLUMN>
 
<CLSFCTN_SCHM_ITEM>
<RECORD>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_ITEM_NM</NAME>
  <VALUE><![CDATA[ci1]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_ID</NAME>
  <VALUE>6020</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_VER_NR</NAME>
  <VALUE>1</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_ITEM_ID</NAME>
  <VALUE>101</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CREAT_DT</NAME>
  <VALUE>2006-06-05 16:44:00</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CREAT_USR_ID</NAME>
  <VALUE><![CDATA[ADMIN]]>
</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LST_UPD_USR_ID</NAME>
  <VALUE><![CDATA[ADMIN]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>FLD_DELETE</NAME>
  <VALUE>0</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LST_DEL_DT</NAME>
  <VALUE>2006-06-05 16:44:00</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>S2P_TRN_DT</NAME>
  <VALUE>2006-06-05 16:44:00</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LST_UPD_DT</NAME>
  <VALUE>2006-06-05 16:44:00</VALUE>
 </COLUMN>
 
<CLSFCTN_SCHM_ITEM>
<RECORD>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_ITEM_NM</NAME>
  <VALUE><![CDATA[CI11]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_ID</NAME>
  <VALUE>6020</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_VER_NR</NAME>
  <VALUE>1</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>PRNT_CLSFCTN_SCHM_ITEM_ID</NAME>
  <VALUE>101</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_ITEM_ID</NAME>
  <VALUE>102</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CREAT_DT</NAME>
  <VALUE>2006-06-05 16:44:00</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CREAT_USR_ID</NAME>
  <VALUE><![CDATA[ADMIN]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LST_UPD_USR_ID</NAME>
  <VALUE><![CDATA[ADMIN]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>FLD_DELETE</NAME>
  <VALUE>0</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LST_DEL_DT</NAME>
  <VALUE>2006-06-05 16:44:00</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>S2P_TRN_DT</NAME>
  <VALUE>2006-06-05 16:44:00</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LST_UPD_DT</NAME>
  <VALUE>2006-06-05 16:44:05</VALUE>
 </COLUMN>
 
<CLSFCTN_SCHM_ITEM>
<RECORD>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_ITEM_NM</NAME>
  <VALUE><![CDATA[CI111]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_ID</NAME>
  <VALUE>6020</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_VER_NR</NAME>
  <VALUE>1</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>PRNT_CLSFCTN_SCHM_ITEM_ID</NAME>
  <VALUE>102</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_ITEM_ID</NAME>
  <VALUE>103</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CREAT_DT</NAME>
  <VALUE>2006-06-05 16:44:00</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CREAT_USR_ID</NAME>
  <VALUE><![CDATA[ADMIN]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LST_UPD_USR_ID</NAME>
  <VALUE><![CDATA[ADMIN]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>FLD_DELETE</NAME>
  <VALUE>0</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LST_DEL_DT</NAME>
  <VALUE>2006-06-05 16:44:00</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>S2P_TRN_DT</NAME>
  <VALUE>2006-06-05 16:44:00</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LST_UPD_DT</NAME>
  <VALUE>2006-06-05 16:44:05</VALUE>
 </COLUMN>
</RECORD>
</CLSFCTN_SCHM_ITEM>
</RECORD>
<RECORD>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_ITEM_NM</NAME>
  <VALUE><![CDATA[ci12]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_ID</NAME>
  <VALUE>6020</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_VER_NR</NAME>
  <VALUE>1</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>PRNT_CLSFCTN_SCHM_ITEM_ID</NAME>
  <VALUE>101</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_ITEM_ID</NAME>
  <VALUE>104</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CREAT_DT</NAME>
  <VALUE>2006-06-05 16:44:00</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CREAT_USR_ID</NAME>
  <VALUE><![CDATA[ADMIN]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LST_UPD_USR_ID</NAME>
  <VALUE><![CDATA[ADMIN]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>FLD_DELETE</NAME>
  <VALUE>0</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LST_DEL_DT</NAME>
  <VALUE>2006-06-05 16:44:00</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>S2P_TRN_DT</NAME>
  <VALUE>2006-06-05 16:44:00</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LST_UPD_DT</NAME>
  <VALUE>2006-06-05 16:44:05</VALUE>
 </COLUMN>
<CLSFCTN_SCHM_ITEM />
</RECORD>
</CLSFCTN_SCHM_ITEM>
</RECORD>
<RECORD>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_ITEM_NM</NAME>
  <VALUE><![CDATA[ci2]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_ID</NAME>
  <VALUE>6020</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_VER_NR</NAME>
  <VALUE>1</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_ITEM_ID</NAME>
  <VALUE>105</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CREAT_DT</NAME>
  <VALUE>2006-06-05 16:44:00</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CREAT_USR_ID</NAME>
  <VALUE><![CDATA[ADMIN]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LST_UPD_USR_ID</NAME>
  <VALUE><![CDATA[ADMIN]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>FLD_DELETE</NAME>
  <VALUE>0</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LST_DEL_DT</NAME>
  <VALUE>2006-06-05 16:44:00</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>S2P_TRN_DT</NAME>
  <VALUE>2006-06-05 16:44:00</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LST_UPD_DT</NAME>
  <VALUE>2006-06-05 16:44:00</VALUE>
 </COLUMN>
 
<CLSFCTN_SCHM_ITEM>
<RECORD>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_ITEM_NM</NAME>
  <VALUE><![CDATA[ci21]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_ID</NAME>
  <VALUE>6020</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_VER_NR</NAME>
  <VALUE>1</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>PRNT_CLSFCTN_SCHM_ITEM_ID</NAME>
  <VALUE>105</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_ITEM_ID</NAME>
  <VALUE>106</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CREAT_DT</NAME>
  <VALUE>2006-06-05 16:44:00</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CREAT_USR_ID</NAME>
  <VALUE><![CDATA[ADMIN]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LST_UPD_USR_ID</NAME>
  <VALUE><![CDATA[ADMIN]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>FLD_DELETE</NAME>
  <VALUE>0</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LST_DEL_DT</NAME>
  <VALUE>2006-06-05 16:44:00</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>S2P_TRN_DT</NAME>
  <VALUE>2006-06-05 16:44:00</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LST_UPD_DT</NAME>
  <VALUE>2006-06-05 16:44:05</VALUE>
 </COLUMN>
<CLSFCTN_SCHM_ITEM />
</RECORD>
</CLSFCTN_SCHM_ITEM>
</RECORD>
<RECORD>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_ITEM_NM</NAME>
  <VALUE><![CDATA[new1ci1]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_ID</NAME>
  <VALUE>6020</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_VER_NR</NAME>
  <VALUE>1</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CLSFCTN_SCHM_ITEM_ID</NAME>
  <VALUE>121</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CREAT_DT</NAME>
  <VALUE>2006-07-10 11:34:19</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CREAT_USR_ID</NAME>
  <VALUE><![CDATA[ADMIN]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LST_UPD_USR_ID</NAME>
  <VALUE><![CDATA[ADMIN]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>FLD_DELETE</NAME>
  <VALUE>0</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LST_DEL_DT</NAME>
  <VALUE>2006-07-10 11:34:19</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>S2P_TRN_DT</NAME>
  <VALUE>2006-07-10 11:34:19</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>LST_UPD_DT</NAME>
  <VALUE>2006-07-10 11:34:19</VALUE>
 </COLUMN>
<CLSFCTN_SCHM_ITEM>
 <RECORD>
  <COLUMN>
   <NAME>CLSFCTN_SCHM_ITEM_NM</NAME>
   <VALUE><![CDATA[new1CI11]]></VALUE>
  </COLUMN>
  <COLUMN>
   <NAME>CLSFCTN_SCHM_ID</NAME>
   <VALUE>6020</VALUE>
  </COLUMN>
  <COLUMN>
   <NAME>CLSFCTN_SCHM_VER_NR</NAME>
   <VALUE>1</VALUE>
  </COLUMN>
  <COLUMN>
   <NAME>PRNT_CLSFCTN_SCHM_ITEM_ID</NAME>
   <VALUE>121</VALUE>
  </COLUMN>
  <COLUMN>
   <NAME>CLSFCTN_SCHM_ITEM_ID</NAME>
   <VALUE>122</VALUE>
  </COLUMN>
  <COLUMN>
   <NAME>CREAT_DT</NAME>
   <VALUE>2006-07-10 11:34:19</VALUE>
  </COLUMN>
  <COLUMN>
   <NAME>CREAT_USR_ID</NAME>
   <VALUE><![CDATA[ADMIN]]></VALUE>
  </COLUMN>
  <COLUMN>
   <NAME>LST_UPD_USR_ID</NAME>
   <VALUE><![CDATA[ADMIN]]></VALUE>
  </COLUMN>
  <COLUMN>
   <NAME>FLD_DELETE</NAME>
   <VALUE>0</VALUE>
  </COLUMN>
  <COLUMN>
   <NAME>LST_DEL_DT</NAME>
   <VALUE>2006-07-10 11:34:19</VALUE>
  </COLUMN>
  <COLUMN>
   <NAME>S2P_TRN_DT</NAME>
   <VALUE>2006-07-10 11:34:19</VALUE>
  </COLUMN>
  <COLUMN>
  <NAME>LST_UPD_DT</NAME>
   <VALUE>2006-07-10 11:34:48</VALUE>
  </COLUMN>
 
 <CLSFCTN_SCHM_ITEM>
  <RECORD>
   <COLUMN>
    <NAME>CLSFCTN_SCHM_ITEM_NM</NAME>
    <VALUE><![CDATA[new1CI111]]></VALUE>
   </COLUMN>
   <COLUMN>
    <NAME>CLSFCTN_SCHM_ID</NAME>
    <VALUE>6020</VALUE>
   </COLUMN>
   <COLUMN>
    <NAME>CLSFCTN_SCHM_VER_NR</NAME>
    <VALUE>1</VALUE>
   </COLUMN>
   <COLUMN>
    <NAME>PRNT_CLSFCTN_SCHM_ITEM_ID</NAME>
    <VALUE>122</VALUE>
   </COLUMN>
   <COLUMN>
    <NAME>CLSFCTN_SCHM_ITEM_ID</NAME>
    <VALUE>123</VALUE>
   </COLUMN>
   <COLUMN>
    <NAME>CREAT_DT</NAME>
    <VALUE>2006-07-10 11:34:19</VALUE>
   </COLUMN>
   <COLUMN>
    <NAME>CREAT_USR_ID</NAME>
    <VALUE><![CDATA[ADMIN]]></VALUE>
   </COLUMN>
   <COLUMN>
    <NAME>LST_UPD_USR_ID</NAME>
    <VALUE><![CDATA[ADMIN]]></VALUE>
   </COLUMN>
   <COLUMN>
    <NAME>FLD_DELETE</NAME>
    <VALUE>0</VALUE>
   </COLUMN>
   <COLUMN>
    <NAME>LST_DEL_DT</NAME>
    <VALUE>2006-07-10 11:34:19</VALUE>
   </COLUMN>
   <COLUMN>
    <NAME>S2P_TRN_DT</NAME>
    <VALUE>2006-07-10 11:34:19</VALUE>
   </COLUMN>
   <COLUMN>
    <NAME>LST_UPD_DT</NAME>
    <VALUE>2006-07-10 11:34:48</VALUE>
   </COLUMN>
  </RECORD>
 </CLSFCTN_SCHM_ITEM>
</RECORD>
</CLSFCTN_SCHM_ITEM>
</RECORD>
</CLSFCTN_SCHM_ITEM>
</RECORD>
</ADMIN_ITEM>
</DATA>
</OUTPUT>
Copyright © 2011-2017 Software AG, Darmstadt, Germany. (Innovation Release)

Product LogoContact Support   |   Community   |   Feedback