Extract metadata from XML

To extract metadata from a XML sidecar file, the xpath node can be used to get the value of the dedicated key.

Example 1 - "Dutch"

<?xml version="1.0" ?>
<AssetMetadata>
  <Asset>1247156</Asset>
  <Channel>BTV</Channel>
  <Program>Laat je verrassen</Program>
  <Date>2024-02-26</Date>
  <MetadataFields>
    <TitleName>231026 2100 - Laat je verrassen</TitleName>
    <ItemCode>NHM81589</ItemCode>
    <OriginalCreator>Rudi Carrell</OriginalCreator>
  </MetadataFields>
</AssetMetadata>

Extract value via the following xpath expressions:

Asset
/AssetMetadata/Asset/text()

Channel
/AssetMetadata/Channel/text()

Program
/AssetMetadata/Program/text()

Date
/AssetMetadata/Date/text()
 
TitleName
/AssetMetadata/MetadataFields/TitleName/text()

ItemCode
/AssetMetadata/MetadataFields/ItemCode/text()

OriginalCreator
/AssetMetadata/MetadataFields/OriginalCreator/text()

Example 2 - "America"

<?xml version="1.0" ?>
<eMAM user-key="DlmCO%2frHfqn8MFWM72c2oEXEdfnMecNFm8Mz413k%2fUzRtOsyTzHvBg%3d%3d">
<asset file-action="move" file- name="422_A015_1984_01_01_Getty_1270948573_Lic.mp4" file- path="\\10.69.2.8\xml_ingest6" ingest-action="create-new-asset">
<basic-metadata>
<title>RR422_A015_1984_01_01_Getty_1270948573_Lic</title> 
<description>Hans Meiser walking in cemetery holding flowers and umbrella</description> 
<author/>
</basic-metadata>
<custom-metadata set-standard-id="CUST_SET_AST_ARCHIVAL MEDIA_22">
<field standard-id="CUST_FLD_ASSET LABEL_13">422_A015_1984_01_01_Getty_1270948573_Lic</field>
<field standard-id="CUST_FLD_ASSET NUMBER_25">15</field>
<field standard-id="CUST_FLD_SOURCE_17">Getty</field>
<field standard-id="CUST_FLD_PROJECT ID_29">422</field>
<field standard-id="CUST_FLD_IS ARCHIVAL_39">1</field>
<field standard-id="CUST_FLD_SOURCE ID_18">1270948573</field> <field standard-id="CUST_FLD_LINK_20"> https://www.gettyimages.com
/detail/video/videoname </field> 
<field standard-id="CUST_FLD_COPYRIGHT/SOURCE OWNER_21">Getty</field>
<field standard-id="CUST_FLD_DATE_5">1984-01-01</field>
</custom-metadata> 
<markers/> 
<subclips/> 
<projects/> 
<categories>
<category name="Stories/422 Hans Meiser/Archival"/> 
</categories>
</asset>
</eMAM>

Extract value via the following xpath expressions:

EMAM user-key
//eMAM/@user-key

Asset-file-name
//asset/@file-name

Asset-file-path
//asset/@file-path

Asset-title
/eMAM/asset/basic-metadata/title/text()

Asset-description
/eMAM/asset/basic-metadata/description/text()

Asset author
/eMAM/asset/basic-metadata/author/text()

Asset number
/eMAM/asset/custom-metadata/field[@standard-id='CUST_FLD_ASSET NUMBER_25']/text()

This tool can be used to test xpath expressions ahead of it use in the xpath node.

https://www.freeformatter.com/xpath-tester.html#before-output