Articles in this section

.fmpxml

Avatar
Nicholas Orr
Follow

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

ImportFMPXML.png

Example URI and response

http://demo.restfm.com/RESTfm/postcodes/layout/brief%20postcodes.fmpxml?RFMmax=2&RFMsF1=Pcode&RFMsV1=3012
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

<?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.

 

 

Related articles