Query Parameters for XML/XSLT URL Requests

The FileMaker Web Publishing Engine delivers XML data in response to specially formatted URLs. The specific details of the request are contained in the query string, which is a specific portion of the URL. For example, the query string is highlighted in the following URL:

http://my.filemakerserver.net/fmi/xsl/customer-files/customer_list.xsl?-db=Customer&-lay=list&-max=50&-findall

The query string consists of a series of name-value pairs, of the form name=value, separated by ampersands, and following a question mark within the URL.

Generally, a query string intended for the Web Publishing Engine consists of a single query command, representing the type of request being made, supported by additional query parameters that add specificity to the request. In the preceding example, the request is findall (find all records). Additional query parameters specify the database, the layout, and the maximum number of records to be returned.

Please note the following important points about URL queries.

• Each URL query string must contain one and only one query command (though it may contain many additional query parameters).
• Query commands and query parameters begin with a hyphen (-). Omitting the hyphen will cause an error.
• A query command is expressed as a plain name, not as a name-value pair. Any supplied value will be ignored. (So you can say ...&-findall=somevalue, but the =somevalue will be ignored.)
• The names of FileMaker fields, when included in the URL for purposes of searching, or creating or editing records, do not require a hyphen.
• Most query commands have a minimum set of query parameters that must also be provided in the URL. These are noted in the tables below.

Query Commands

This section lists the possible query commands. If the command requires certain specific additional parameters, those are listed.

Command	Parameters Required	Description
-dbnames	None	Returns a list of all databases on the given server that are enabled for XML or XSLT publishing.
http://my.server.com/fmi/xml/fmresultset.xml?-dbnames
-delete	-db, -lay, -recid	Delete the record with the specified recid from the specified database. (The affected table is determined by the specified layout.)
http://my.server.com/fmi/xml/fmresultset.xml?-db=Customer&-lay=web&-recid=303&-delete
-dup	-db, -lay, -recid	Duplicate the record with the specified record ID from the specified database. (The affected table is determined by the specified layout.)
http://my.server.com/fmi/xml/fmresultset.xml?-db=Customer&-lay=web&-recid=303&-dup
-edit	-db, -lay, -recid, field name(s)	Edit the record with the specified recid from the specified database. (The affected table is determined by the specified layout.) Field names and associated field values determine what data gets written into the record.
http://my.server.com/fmi/xml/fmresultset.xml?-db=Customer&-lay=web&-recid=303&name_first=Sarah&-edit
-find	-db, -lay, field name(s)	Find a record in the specified database and table, with search criteria determined by the supplied field data.
http://my.server.com/fmi/xml/fmresultset.xml?-db=Customer&-lay=web&name_last=Smith&-find
-findall	-db, lay	Find all records in the specified database and table.
http://my.server.com/fmi/xml/fmresultset.xml?-db=Customer&-lay=web&-findall
-findany	-db, -lay	Find a random record in the specified database and table.
http://my.server.com/fmi/xml/fmresultset.xml?-db=Customer&-lay=web&-findany
-layoutnames	-db	Returns a list of all layout names from the specified database.
http://my.server.com/fmi/xml/fmresultset.xml?-db=Customer&-layoutnames
-new	-db, -lay	Create a new record in the specified database and table. If field names and field values are also supplied, these will create specific data values in the new record.
http://my.server.com/fmi/xml/fmresultset.xml?-db=Customer&-lay=web&name_first=Kai&name_last=Love&-new
-process	-grammar	XSLT only. This command instructs the Web Publishing Engine to process a stylesheet without performing any database transactions.
http://my.server.com/fmi/xsl/stylesheet.xsl?-grammar=fmresultset&-process
-scriptnames	-db	Returns a list of the names of all scripts in the specified database.
http://my.server.com/fmi/xml/fmresultset.xml?-db=Customer&-scriptnames
-view	-db, -lay	Used with the FMPXMLLAYOUT grammar, -view retrieves layout information in the FMPXMLLAYOUT format. Used with the other grammars, it retrieves the database metadata and an empty result set.
http://my.server.com/fmi/xml/FMPXMLLAYOUT.xml?-db=Customer&-lay=web&-view

Query Parameters

Parameter Name	Required Value(s)		Description
-db	Name of a database (without file extension)		Specify a database as a target of the URL command. Most commands require this parameter.
http://my.server.com/fmi/xml/fmresultset.xml?-db=Customer&-lay=web&name_first=Kai&name_last=Love&-new
-encoding	US-ASCII, ISO-8859-1, ISO-8859-15, ISO-2022-JP, Shift_JIS, UTF-8		XSLT only. Specify the text encoding for an XSLT request. This governs only the encoding of the request, not of the output page. Encoding for the output page is set within an XSL stylesheet using the "encoding" attribute of an element.
http://my.server.com/fmi/xsl/stylesheet.xsl?-grammar=fmresultset&-db=Company&-lay=detail&-encoding=ISO-8859-1&name=Beech%20Street&-new
-field	Name of a container field		Specify a container field from which to extract data.
http://my.filemakerserver.net:8080/fmi/xml/cnt/data.tiff?-db=Customers&-lay=web_search&-field=photo[1]&-recid=303
	Name of a non-container field		Used to specify search parameters (with a find command) or data values to be inserted (with the edit and new commands).
http://my.server.com/fmi/xml/fmresultset.xml?-db=Customer&-lay=web&name_first=Kai&name_last=Love&-new
.op	eq cn bw ew gt gte lt lte neq	(equals) (contains) (begins with) (ends with) (greater than) (greater than or equal) (less than) (less than or equal) (not equal)	Specify a search comparison operator to use when searching on . Used with the find command.
http://my.server.com/fmi/xml/fmresultset.xml?-db=Agent&-lay=web&commission=.3&commission.op=gte&-find
-grammar	One of the four FileMaker XMLgrammars		XSLT only. Specify the grammar in which the XML data should be passed to the XSL stylesheet.
http://my.server.com/fmi/xsl/stylesheet.xsl?-grammar=fmresultset&-process
-lay	Name of a layout in the database specified by the db parameter		Required by many commands. Note that the choice of layout also governs which table the command is performed against.
http://my.server.com/fmi/xml/fmresultset.xml?-db=Customer&-lay=web&name_first=Kai&name_last=Love&-new
-lay.response	Name of a layout in the database specified by the db parameter		You may wish to return data from an alternate layout. For example, you may wish to search on a particular field (in which case that field must be present on the layout specified by lay), but not return that field in the result set (in which case you would return XML from the layout named in lay.response, which would not contain the field in question).
http://my.server.com/fmi/xml/fmresultset.xml?-db=Customer&-lay=web&-lay.response=web_response&-findall
-lop	and or or		Specifies whether the criteria in a find request represent an "and" search or an "or" search. (The default is "and".)
http://my.server.com/fmi/xml/fmresultset.xml?-db=Customer&-lay=web&name_last=Smythe&hair_color=red&-lop=or&-find
-max	A positive number, or the value "all"		For a find or findall request, specifies how many records to return.
http://my.server.com/fmi/xml/fmresultset.xml?-db=Customer&-lay=web&name_last=Smythe&hair_color=red&-max=25&-find
-modid	A FileMaker modification ID		Use with the edit command to specify a valid modification ID for the record being updated. If the modid value does not match the target records modification ID, the edit will be rejected. This is to ensure that the record has not been modified by someone else since the time it was fetched for a web user.
http://my.server.com/fmi/xml/fmresultset.xml?-db=Customer&-lay=web&name_last=Smythe&recid=10003&-modid=13&-edit
-recid	A FileMaker record ID		The edit, -dup and delete commands need to know the ID of a specific record on which to operate. Generally this record ID will be extracted from the result of a previous request. The recid parameter can also be used with the find command.
http://my.server.com/fmi/xml/fmresultset.xml?-db=Customer&-lay=web&name_last=Smythe&recid=10003&-modid=13&-edit
-script	The name of a script in the database specified by the db parameter		Specifies a script to be run after the query and any sorting are performed. Make sure you understand the issue of web compatibility for scripts when using this parameter.
http://my.server.com/fmi/xml/fmresultset.xml?-db=Customer&-lay=web&-lay.response=web_response&-script=OmitDuplicates&-findall
-script.param	Value of a script parameter to be passed to the script named in script		The script named in script may be passed a script parameter.
http://my.server.com/fmi/xml/fmresultset.xml?-db=Customer&-lay=web&-lay.response=web_response&-script=Omit&-script.param=3&-find
-script.prefind	The name of a script in the database specified by the db parameter		Specifies a script to be run before the specified query is run and sorted.
http://my.server.com/fmi/xml/fmresultset.xml?-db=Customer&-lay=web&-lay.response=web_response&-script.prefind=Omit&-script.prefind.param=3&-find
-script.prefind.param	Value of a script parameter to be passed to the script named in script.prefind		The script named in script.prefind may be passed a script parameter.
http://my.server.com/fmi/xml/fmresultset.xml?-db=Customer&-lay=web&-lay.response=web_response&-script.prefind=Omit&-script.prefind.param=3&-find
-script.presort	The name of a script in the database specified by the db parameter		Specifies a script to be run after the specified query is run and before the results are sorted.
http://my.server.com/fmi/xml/fmresultset.xml?-db=Customer&-lay=web&-lay.response=web_response&-script.presort=Omit&-script.presort.param=3&-find
-script.presort.param	Value of a script parameter to be passed to the script named in script.presort		The script named in script.presort may be passed a script parameter.
http://my.server.com/fmi/xml/fmresultset.xml?-db=Customer&-lay=web&-lay.response=web_response&-script.presort=Omit&-script.presort.param=3&-find
-skip	A number of records to skip		Based on this value, the Web Publishing Engine will skip some of the records normally returned by a query and begin returning records from later in the result set.
http://my.server.com/fmi/xml/fmresultset.xml?-db=Customer&-lay=web&-lay.response=web_response&-skip=20&-max=25&-find
-sortfield.precedence	Name of a field to sort on, along with a sort precedence from 1 to 9		Using the values sortfield.1 through sortfield.9, its possible to specify up to nine fields on which to sort. The precedence value is mandatory, even for a single sort criterion.
http://my.server.com/fmi/xml/fmresultset.xml?-db=Customer&-lay=web&-lay.response=web_response&-skip=20&-max=25&sortfield.1=name&-find
-sortorder.precedence	ascend, descend, or a value list name		Specify a sort order for a specific sort field.
http://my.server.com/fmi/xml/fmresultset.xml?-db=Customer&-lay=web&-lay.response=web_response&-skip=20&-max=25&sortfield.1=name&-sortorder.1=descend&-find
-stylehref	Path to a client-side stylesheet		This will cause the output document to contain XML processing instructions that link to a CSS or XSLT stylesheet. The stylesheet name must end in .css or .xsl. Used in conjunction with styletype.
http://my.server.com/fmi/xsl/stylesheet.xsl?-grammar=fmresultset&-stylehref=/stylesheets/display.css&-styletype=text/css&-process
-styletype	text/css or text/xsl		Used in conjunction with stylehref, specifies the MIME type of an associated client-side stylesheet.
http://my.server.com/fmi/xsl/stylesheet.xsl?-grammar=fmresultset&-stylehref=/stylesheets/display.css&-styletype=text/css&-process
-token.	Any name for a token, plus the specific value to be assigned to the token of that name		XSLT only. Tokens provide a means to pass information from one stylesheet to the next without using other session mechanisms.
http://my.server.com/fmi/xsl/stylesheet.xsl?-grammar=fmresultset&-token.name=Fred&-process