Custom Web Publishing Guide

80 Custom Web Publishing Guide
–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 78.
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
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:
http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family&-findall
To find a random record:
http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-lay=family&-findany
–layoutnames (Layout names) query command
Retrieves the names of all available layouts for a specified database that is hosted by FileMaker Server and
enabled for Custom Web Publishing with XML or XSLT
Required query parameters: –db
Example:
To retrieve the names of available layouts:
http://192.168.123.101/fmi/xml/fmresultset.xml?-db=employees&-layoutnames