Master Data Management with webMethods OneData : Working with webMethods OneData MDR : Appendix of Examples : getDataElementSummarybyName
getDataElementSummarybyName
Sample Input
<RepositoryId >CAPITOL</RepositoryId>
<UserId >admin</UserId>
<Password >1563472D29F72A2F0482818D662E31F8</Password>
<ClientId>1</ClientId>
<ProjectId>1</ProjectId>
<SchemaId>2</SchemaId>
<Name >FLIGHT_AirborneCommNavApproachEquipment_code</Name>
<ContextName >Generic</ContextName>
<NameColumn />
<ExcludeAuditColumns >true</ExcludeAuditColumns>
Sample Output
<?xml version="1.0" encoding="UTF-8" ?>
<OUTPUT>
<DATA>
<ADMIN_ITEM>
 <RECORD>
 <COLUMN>
  <NAME>ADMIN_ITEM_TYP_ID</NAME>
  <VALUE>4</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>ADMIN_ITEM_TYP_ID_DESC</NAME>
  <VALUE><![CDATA[Data Element]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>ITEM_NM</NAME>
  <VALUE><![CDATA[FLIGHT_AirborneCommNavApproachEquipment_code-ICAO]]>
  </VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>ITEM_DESC</NAME>
  <VALUE><![CDATA[Indicates the kinds of communication, navigation and
approach aid equipment available and serviceable carried on aircraft.
Represented as one to 24 one-letter codes.]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CNTXT_ITEM_ID</NAME>
  <VALUE>1569</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CNTXT_ITEM_ID_DESC</NAME>
  <VALUE><![CDATA[Generic]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>REGSTR_STUS_ID</NAME>
  <VALUE>2</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>REGSTR_STUS_ID_DESC</NAME>
  <VALUE><![CDATA[RECORDED]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>ADMIN_STUS_ID</NAME>
  <VALUE>8</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>ADMIN_STUS_ID_DESC</NAME>
  <VALUE><![CDATA[CANDIDATE]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>DATA_ID_STR</NAME>
  <VALUE><![CDATA[1893]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VER_NR</NAME>
  <VALUE>1</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>ITEM_ID</NAME>
  <VALUE>4771</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CNTXT_VER_NR</NAME>
  <VALUE>1</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CURRNT_VER_IND</NAME>
  <VALUE>1</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CREATION_DT</NAME>
  <VALUE>2004-05-03 14:13:46</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>EFF_DT</NAME>
  <VALUE>2004-05-03 00:00:00</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CHNG_DESC_TXT</NAME>
  <VALUE><![CDATA[removed repeated terms from name. Added representation
to defn.]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>REGSTR_AUTH_ID</NAME>
  <VALUE>26</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>REGSTR_AUTH_ID_DESC</NAME>
  <VALUE><![CDATA[TEST REGISTRATION AUTHORITY]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>SUBMT_ORG_ID</NAME>
  <VALUE>26</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>SUBMT_ORG_ID_DESC</NAME>
  <VALUE><![CDATA[TEST REGISTRATION AUTHORITY]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>REGISTRR_CNTCT_ID</NAME>
  <VALUE>7</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>REGISTRR_CNTCT_ID_DESC</NAME>
  <VALUE><![CDATA[Test User]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>SUBMT_CNTCT_ID</NAME>
  <VALUE>7</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>SUBMT_CNTCT_ID_DESC</NAME>
  <VALUE><![CDATA[Test User]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CASE_FILE_ID</NAME>
  <VALUE>10</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CASE_FILE_ID_DESC</NAME>
  <VALUE><![CDATA[IO300-NAS-003]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>DE_CONC_ITEM_ID</NAME>
  <VALUE>3181</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>DE_CONC_ITEM_ID_DESC</NAME>
  <VALUE><![CDATA[FLIGHT_AirborneCommNavApproachEquipment]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>DE_CONC_VER_NR</NAME>
  <VALUE>1</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VAL_DOM_ITEM_ID</NAME>
  <VALUE>4219</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VAL_DOM_ITEM_ID_DESC</NAME>
  <VALUE><![CDATA[code-airborne-comm-nav-approach-equipment-ICAO]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VAL_DOM_VER_NR</NAME>
  <VALUE>1</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CONC_DOM_ITEM_ID</NAME>
  <VALUE>2468</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CONC_DOM_ITEM_ID_DESC</NAME>
  <VALUE><![CDATA[altitude]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CONC_DOM_VER_NR</NAME>
  <VALUE>1</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VAL_DOM_TYP_ID</NAME>
  <VALUE>17</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VAL_DOM_TYP_ID_DESC</NAME>
  <VALUE><![CDATA[Enumerated]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>DTTYPE_ID</NAME>
  <VALUE>28</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>DTTYPE_ID_DESC</NAME>
  <VALUE><![CDATA[LETTERSTRING]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CHAR_SET_ID</NAME>
  <VALUE>5</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>CHAR_SET_ID_DESC</NAME>
  <VALUE><![CDATA[Extended Binary-Coded Decimal Interchange Code]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VAL_DOM_FMT_ID</NAME>
  <VALUE>1202</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VAL_DOM_FMT_ID_DESC</NAME>
  <VALUE><![CDATA[L...L(1,25)]]></VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VAL_DOM_MAX_CHAR</NAME>
  <VALUE>25</VALUE>
 </COLUMN>
 <COLUMN>
  <NAME>VAL_DOM_MIN_CHAR</NAME>
  <VALUE>1</VALUE>
 </COLUMN>
</RECORD>
</ADMIN_ITEM>
</DATA>
</OUTPUT>
Copyright © 2011-2017 Software AG, Darmstadt, Germany. (Innovation Release)

Product LogoContact Support   |   Community   |   Feedback