Custom Format : .fmpxml

RESTfm supports FileMaker's FMPXMLRESULT format out of the box.

This format may be imported directly into a FileMaker table when using an import script step. This format may also be imported from a HTTP request with no XSLT required.

Example Import Script Step setup

Example URI and response

http://demo.restfm.com/RESTfm/postcodes/layout/brief%20postcodes.fmpxml?RFMmax=2&RFMsF1=Pcode&RFMsV1=3012

<?xml version="1.0" encoding="UTF-8"?>
<FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult">
  <METADATA>
    <FIELD EMPTYOK="YES" MAXREPEAT="1" TYPE="TEXT" NAME="Pcode"/>
    <FIELD EMPTYOK="YES" MAXREPEAT="1" TYPE="TEXT" NAME="Locality"/>
    <FIELD EMPTYOK="YES" MAXREPEAT="1" TYPE="TEXT" NAME="State"/>
    <FIELD EMPTYOK="YES" MAXREPEAT="1" TYPE="TEXT" NAME="Comments"/>
  </METADATA>
  <RESULTSET FOUND="2">
    <ROW RECORDID="10102569">
      <COL>
        <DATA>3012</DATA>
      </COL>
      <COL>
        <DATA>BROOKLYN</DATA>
      </COL>
      <COL>
        <DATA>VIC</DATA>
      </COL>
      <COL>
        <DATA/>
      </COL>
    </ROW>
    <ROW RECORDID="10102570">
      <COL>
        <DATA>3012</DATA>
      </COL>
      <COL>
        <DATA>KINGSVILLE</DATA>
      </COL>
      <COL>
        <DATA>VIC</DATA>
      </COL>
      <COL>
        <DATA/>
      </COL>
    </ROW>
  </RESULTSET>
</FMPXMLRESULT>

Example fmpxml format GET response.