Re: Exporting as xml

Using an XSLT Stylesheet will allow you to transform the XML response into any format you desire.

So would this be done in the coding part of the URL formula field?

You have to create a XSLT stylesheet and save it in a code page.

They look like this:

<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
                version="1.0">
        
 <xsl:key name="LabelToField" match="/qdbif/table/fields/field/@id" use="../label"/>
        
 <xsl:template match="/">
  <xsl:apply-templates select="qdbif"/>
 </xsl:template>
 
 <xsl:template match="qdbif">
  <xsl:apply-templates select="table"/>
 </xsl:template>
 <xsl:template match="table">
  <xsl:apply-templates select="records"/>  
 </xsl:template>
  
 <xsl:template match="records">
  <table border="1">
   <tr>
    <th>Field1 Heading</th>
    <th>Field2 Heading</th>
    <th>Field3 Heading</th>
   </tr>
   <xsl:apply-templates select="record"/>
  </table>
 </xsl:template>
 
 <xsl:template match="record">
  <tr>
   <td>
    <xsl:value-of select="f[@id=key('LabelToField','Field1')]"/> 
   </td>
   <td>
    <xsl:value-of select="f[@id=key('LabelToField','Field2')]"/> 
   </td> 
   <td>
    <xsl:value-of select="f[@id=key('LabelToField','Field3')]"/> 
   </td> 
  </tr>
 </xsl:template> 
</xsl:stylesheet> 

Then you can associate the XSLT stylesheet with (1) a native query or (2) use the xsl parameter with API_DoQuery.

However, I doubt there are many people that even know how to do this any more and the feature is rarely used or asked about.