AnsweredAssumed Answered

Query XML after Call Web Service

Question asked by jsupple on Oct 15, 2015
Latest reply on Oct 16, 2015 by jsupple

I have used the GetUserProfileByName web service to retrieve a profile in XML format. I now ned to retrieve a specific piece of data from the xml.

 

A sample of the xml returned (also attached) is

 

<xml>

<PropertyData xmlns="http://microsoft.com/webservices/SharePointPortalServer/UserProfileService">

     <IsPrivacyChanged>false</IsPrivacyChanged>

falsefalse     <IsValueChanged>false</IsValueChanged>

     <Name>HomePhone</Name

PublicPublic     ><Privacy>Public</Privacy>

     <Values

          ><ValueData>

               <Value xsi:type="xsd:string" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">250-555-1111</Value>

          </ValueData>

     </Values>

</PropertyData>

<PropertyData xmlns="http://microsoft.com/webservices/SharePointPortalServer/UserProfileService">

falsefalse     <IsPrivacyChanged>false</IsPrivacyChanged>

falsefalse     <IsValueChanged>false</IsValueChanged>

CellPhoneCellPhone     <Name>CellPhone</Name>

PublicPublic     <Privacy>Public</Privacy>

     <Values>

          <ValueData>

               <Value xsi:type="xsd:string" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">250-555-2222</Value>

          </ValueData>

     </Values>

</PropertyData>

<PropertyData xmlns="http://microsoft.com/webservices/SharePointPortalServer/UserProfileService">

falsefalse     <IsPrivacyChanged>false</IsPrivacyChanged>

falsefalse     <IsValueChanged>false</IsValueChanged>

EmergencyContactPersonEmergencyContactPerson     <Name>EmergencyContactPerson</Name>

     <Privacy>Public</Privacy><

     Values>

          <ValueData>

               <Value xsi:type="xsd:string" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">George Washington</Value>

          </ValueData>

     </Values>

</PropertyData>

</xml>

 

Using a Query XML I would like to extract the value of "George Washington" from the node that has Name=EmergencyContactPerson. I have tried a number of different things but have not managed to get it to work. I am running Nintex 2007.

 

Thanks

Attachments

Outcomes