Custom Web Publishing Guide

90 FileMaker Server Advanced Custom Web Publishing Guide
–dup (Duplicate record) query command
Duplicates the record specified by –recid
Required query parameters: –db, –lay, –recid
Optional query parameter: –script
Example:
To duplicate the specified record:
http://192.168.123.101/fmi/xml/fmresultset.xml?–db=employees&–lay=departments&–recid=14&–dup
–edit (Edit record) query command
Updates the record specified by the –recid parameter, populating the fields with the contents of any field
name/value pairs. The
–recid parameter indicates which record should be edited.
Required query parameters: –db, –lay, –recid, one or more field name(s)
Optional query parameter: –modid, –script
Note For information on editing records in a portal, see “Editing records in a portal” on page 88.
Example:
To edit a record:
http://192.168.123.101/fmi/xml/fmresultset.xml?–db=employees&–lay=departments&–recid=13&Country=USA&–edit
–find, –findall, or –findany (Find records) query commands
Submits a search request using defined criteria
Required query parameters: –db, –lay
Optional query parameters: –recid, –lop, –op, –max, –skip, –sortorder, –sortfield, –script, –script.prefind,
–script.presort, field name
Examples:
To find a record by field name:
http://192.168.123.101/fmi/xml/fmresultset.xml?–db=employees&–lay=family&Country=USA&–find
Note Specifying a field name multiple times in a single request is not supported; FileMaker Server parses
all of the values, but uses only the last value parsed.
To find a record by record ID:
http://192.168.123.101/fmi/xml/fmresultset.xml?–db=employees&–lay=family&–recid=427&–find
To find all records in the database, use –findall:
http://192.168.123.101/fmi/xml/fmresultset.xml?–db=employees&–lay=family&–findall
To find a random record, use –findany:
http://192.168.123.101/fmi/xml/fmresultset.xml?–db=employees&–lay=family&–findany