Xpath not working. I have to retrieve the two fields company code and partner from the below xml .

[DD52]

Xpath not working. I have to retrieve the two fields company code and partner from the below xml . not sure what is incorrect , any help will be highly appreciated

My xml –

<feed xmlns=http://www.w3.org/2005/Atom xmlns:m=http://schemas.microsoft.com/ado/2007/08/dataservices/metadata xmlns:d=http://schemas.microsoft.com/ado/2007/08/dataservices xml:base=https://ns2ds4app1.sap.global.lmco.com:44400/sap/opu/odata/sap/ZI_SC_AP220_GET_PARTNR_CCD_CDS/><id>https://ns2ds4app1.sap.global.lmco.com:44400/sap/opu/odata/sap/ZI_SC_AP220_GET_PARTNR_CCD_CDS/ZI_SC_... type="text">ZI_SC_AP220_GET_PARTNR_CCDSet</title><updated>2025-02-13T20:45:56Z</updated><author><name/></author><link href="ZI_SC_AP220_GET_PARTNR_CCD(P_IDNUMBER='954100')/Set" rel="self" title="ZI_SC_AP220_GET_PARTNR_CCDSet"/><entry><id>https://ns2ds4app1.sap.global.lmco.com:44400/sap/opu/odata/sap/ZI_SC_AP220_GET_PARTNR_CCD_CDS/ZI_SC_... type="text">ZI_SC_AP220_GET_PARTNR_CCDSet(P_IDNUMBER='954100',IDNUMBER='954100')</title><updated>2025-02-13T20:45:56Z</updated><category term="ZI_SC_AP220_GET_PARTNR_CCD_CDS.ZI_SC_AP220_GET_PARTNR_CCDType" scheme=http://schemas.microsoft.com/ado/2007/08/dataservices/scheme/><link href="ZI_SC_AP220_GET_PARTNR_CCDSet(P_IDNUMBER='954100',IDNUMBER='954100')" rel="self" title="ZI_SC_AP220_GET_PARTNR_CCDType"/><link href="ZI_SC_AP220_GET_PARTNR_CCDSet(P_IDNUMBER='954100',IDNUMBER='954100')/Parameters" rel=http://schemas.microsoft.com/ado/2007/08/dataservices/related/Parameters type="application/atom+xml;type=entry" title="Parameters"/><content type="application/xml"><m:properties xmlns:m=http://schemas.microsoft.com/ado/2007/08/dataservices/metadata xmlns:d=http://schemas.microsoft.com/ado/2007/08/dataservices><d:P_IDNUMBER>954100</d:P_IDNUMBER><d:IDNUMBER>954100</d:IDNUMBER><d:PARTNER>40000</d:PARTNER><d:COMPANYCODE>1000</d:COMPANYCODE></m:properties></content></entry></feed>

XPath –

/feed/entry/content/m:properties/d:COMPANYCODE

/feed/entry/content/m:properties/d:PARTNER

Runtime config- namepace mapping

xmlns:m=http://schemas.microsoft.com/ado/2007/08/dataservices/metadata;xmlns:d=http://schemas.microsoft.com/...
 

[Sandra_Rossi]

Your XML appears with incorrect syntax in the forum. I spent some time to make it valid:

<feed xmlns="http://www.w3.org/2005/Atom"
    xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"
    xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices"
    xml:base="https://ns2ds4app1.sap.global.lmco.com:44400/sap/opu/odata/sap/ZI_SC_AP220_GET_PARTNR_CCD_CDS">
    <id>
        https://ns2ds4app1.sap.global.lmco.com:44400/sap/opu/odata/sap/ZI_SC_AP220_GET_PARTNR_CCD_CDS/ZI_SC_...</id>
    <title type="text">ZI_SC_AP220_GET_PARTNR_CCDSet</title>
    <updated>2025-02-13T20:45:56Z</updated>
    <author>
        <name />
    </author>
    <link href="ZI_SC_AP220_GET_PARTNR_CCD(P_IDNUMBER='954100')/Set" rel="self"
        title="ZI_SC_AP220_GET_PARTNR_CCDSet" />
    <entry>
        <id>
            https://ns2ds4app1.sap.global.lmco.com:44400/sap/opu/odata/sap/ZI_SC_AP220_GET_PARTNR_CCD_CDS/ZI_SC_...</id>
        <title type="text">ZI_SC_AP220_GET_PARTNR_CCDSet(P_IDNUMBER='954100',IDNUMBER='954100')</title>
        <updated>2025-02-13T20:45:56Z</updated>
        <category term="ZI_SC_AP220_GET_PARTNR_CCD_CDS.ZI_SC_AP220_GET_PARTNR_CCDType"
            scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
        <link href="ZI_SC_AP220_GET_PARTNR_CCDSet(P_IDNUMBER='954100',IDNUMBER='954100')" rel="self"
            title="ZI_SC_AP220_GET_PARTNR_CCDType" />
        <link href="ZI_SC_AP220_GET_PARTNR_CCDSet(P_IDNUMBER='954100',IDNUMBER='954100')/Parameters"
            rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/Parameters"
            type="application/atom+xml;type=entry" title="Parameters" />
        <content type="application/xml">
            <m:properties xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"
                xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices">
                <d:P_IDNUMBER>954100</d:P_IDNUMBER>
                <d:IDNUMBER>954100</d:IDNUMBER>
                <d:PARTNER>40000</d:PARTNER>
                <d:COMPANYCODE>1000</d:COMPANYCODE>
            </m:properties>
        </content>
    </entry>
</feed>

[Sandra_Rossi]

You are using the "d" namespace prefix, so you must define "d" also in the Runtime config-namespace mapping.