Driver XPath Get XML element value

fartyalvikram over 1 year ago

I have the XML response in Driver's local variable 'lv-Result'.

<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns="urn:partner.soap.sforce.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:sf="urn:sobject.partner.soap.sforce.com">
    <soapenv:Header>
        <LimitInfoHeader>
            <limitInfo>
                <current>142795</current>
                <limit>49754000</limit>
                <type>API REQUESTS</type>
            </limitInfo>
        </LimitInfoHeader>
    </soapenv:Header>
    <soapenv:Body>
        <queryAllResponse>
            <result xsi:type="QueryResult">
                <done>true</done>
                <queryLocator xsi:nil="true"/>
                <records xsi:type="sf:sObject">
                    <sf:type>User</sf:type>
                    <sf:Id>005030000040AQeAAM</sf:Id>
                    <sf:Id>005030000040AQeAAM</sf:Id>
                </records>
                <size>1</size>
            </result>
        </queryAllResponse>
    </soapenv:Body>
</soapenv:Envelope>

I want to get the value of <sf:Id>005030000040AQeAAM</sf:Id> and <size>1</size>, please help here.

I tried the below XPath in Driver's local variable as String but got an error.

$lv-Result/*[local-name()="soapenv:Envelope"]/*[local-name()="soapenv:Body"]/queryAllResponse/result/size/text()

I am using IDM 4.7.3.

Tags:

Designer

xpath

Engine-Drivers

drivers

Top Replies

Geoffrey Carman over 1 year ago in reply to Geoffrey Carman +1 verified

Here is a screen shot, for a POlicy editor page, I clicked on the Namespace icon, upper right, (see where my arrow is pointing) and moved the Namespace Editor underneath for a smaller screen shot. …

Parents

0 Geoffrey Carman over 1 year ago

Define the sf namespace in the policy, and then add in the sf: on the size node.

Or use the *[local-name()="size"] style thing, all the way through.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 fartyalvikram over 1 year ago in reply to Geoffrey Carman

could you please guide me on what should be the URI for the 'sf' prefix namespace?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Geoffrey Carman over 1 year ago in reply to fartyalvikram

In Designer, you could flip to the XMLview, in the <policy> node, add this text inside the node like:
<policy xmlns:sf="urn:sobject.partner.soap.sforce.com"?

Or you could click the Namespace button on the Policy page where you use this XPATH expression (upper right, it is next to the Simulate button)

And define the first field as sf and then the second field as urn:sobject.partner.soap.sforce.com
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
Verified Answer

+1 Geoffrey Carman over 1 year ago in reply to Geoffrey Carman

Here is a screen shot, for a POlicy editor page, I clicked on the Namespace icon, upper right, (see where my arrow is pointing) and moved the Namespace Editor underneath for a smaller screen shot.

In the prefix, put sf

In the URI put the urn:sobject.partner.soap.sforce.com value

If you check the <policy> node, before and after the change, you will see it gets appended the full

xmlns:sf="urn:sobject.partner.soap.sforce.com" value.

Both ways are the same, just different approaches.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Reject Answer

Cancel

Reply

Verified Answer

+1 Geoffrey Carman over 1 year ago in reply to Geoffrey Carman

Here is a screen shot, for a POlicy editor page, I clicked on the Namespace icon, upper right, (see where my arrow is pointing) and moved the Namespace Editor underneath for a smaller screen shot.

In the prefix, put sf

In the URI put the urn:sobject.partner.soap.sforce.com value

If you check the <policy> node, before and after the change, you will see it gets appended the full

xmlns:sf="urn:sobject.partner.soap.sforce.com" value.

Both ways are the same, just different approaches.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Reject Answer

Cancel

Children

0 al_b over 1 year ago in reply to Geoffrey Carman

XPATH expressions (generated by XMLPad):

for value:

/soapenv:Envelope/soapenv:Body/queryAllResponse/result/records/sf:Id

or /soapenv:Envelope/soapenv:Body/queryAllResponse/result/records/sf:Id[1]

for size:

/soapenv:Envelope/soapenv:Body/queryAllResponse/result/size
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Menu

Identity Manager Discussions

Driver XPath Get XML element value

Tags:

Top Replies

Verified Answer

Verified Answer

Resources