AnsweredAssumed Answered

How can I import an xml without having to remove the xmlns reference at the start of the XML

Question asked by brendan_mc on Apr 27, 2016
Latest reply on Apr 27, 2016 by beverly

I have figured out the XSTL section and can import the XML if I remove the xmlns= part of the first tag. Can I add something to the xslt so I do not need to remove the xmlns reference? Below is a simple example of the file.

 

XML FILE

-------------

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Project xmlns="http://schemas.microsoft.com/project">
            <ProjectID>Test DData</ProjectID>
</Project>

 

 

 

 

XSTL FILE

--------------

<?xml version='1.0' encoding='UTF-8'?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:template match="/">
<FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">
<METADATA>
<FIELD NAME="Group_ID" TYPE="TEXT"/>
</METADATA>
<RESULTSET>
  <ROW>
<COL>
<DATA><xsl:value-of select="Project/ProjectID" /></DATA>
</COL>
</ROW>
</RESULTSET>
</FMPXMLRESULT>
  </xsl:template>
</xsl:stylesheet>

Outcomes