AnsweredAssumed Answered

how do I modify xml using query xml action item.

Question asked by nehaagrawal on Aug 6, 2015
Latest reply on Aug 14, 2015 by nehaagrawal

Hello all,

 

I am new to this community and posting for the first time.

 

I am trying to modify below XML:

<Top>

<ValueData xmlns="http://microsoft.com/webservices/SharePointPortalServer/UserProfileService"><Value xsi:type="xsd:string" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">Proteomics</Value></ValueData>

<ValueData xmlns="http://microsoft.com/webservices/SharePointPortalServer/UserProfileService"><Value xsi:type="xsd:string" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">Metabolomics</Value></ValueData>

<ValueData xmlns="http://microsoft.com/webservices/SharePointPortalServer/UserProfileService"><Value xsi:type="xsd:string" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">Bioinformatics</Value></ValueData>

<ValueData xmlns="http://microsoft.com/webservices/SharePointPortalServer/UserProfileService"><Value xsi:type="xsd:string" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">Mass Spectrometry</Value></ValueData>

</Top>

 

to get the output as:

 

<Top>

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

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

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

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

</Top>

 

I want to remove attribute  xmlns from each <ValueData> tag. I tried doing this using XSLT with no luck. Any idea how to do that?

Outcomes