Administrator’s Guide

Using FileMaker Pro XML to deliver your data 5-9
Note The -max parameter now returns 0 if the request returns no
records.
Requests for adding records to a portal
When you make an –edit request or a –new request that includes data
for a portal of related database records, you must specify the layout
and the relationship name for the related database.
Note You can only add one record at a time to a portal, and therefore
must make separate –new requests to add more rows to the portal.
The following is an example of a –new request for adding a record to
a portal, where “Address::” is the name of the database relationship,
and “City.0” is the related field name in the portal:
FMPro?–db=employees.fp5&–lay=LayoutOne&FirstName=Sam
&LastName= Smith&Address::City.0=Seattle&–format= –fmp_xml&–new
Requests for editing multiple records in a portal
You only need to make one –edit request to edit multiple records in
a portal. You specify each row (or record) in the portal by adding a
period and a consecutive number (starting with number 1) to the end
of the related field name.
–scriptnames Retrieve names of all available scripts for a
specified open, web-shared database
–dbopen Open a database that’s in the Web folder with
Remote Administration enabled
–dbclose Close a database that’s in the Web folder with
Remote Administration enabled
Use these
parameter names To go with these requests
–db (database name) Required for all requests except –dbnames
–lay (layout name) Required for –view, and with –edit or –new
requests for data in related fields and portals.
Optional for –find, –findall
–format Required for all requests. (Use one of these
formats: –dso_xml, –dso_xml_dtd, –fmp_xml, or
–fmp_xml_dtd)
–recid (record I.D.) Required for –edit and –delete. Optional for –find
–modid (modification I.D.) Optional for –edit
–lop (logical operator) Optional for –find
–op (operator) Optional for –find
–max (maximum records) Optional for –find
–skip (skip records) Optional for –find
–sortorder (sort order) Optional for –find, –findall
–sortfield (sort field) Optional for –find, –findall
–script (perform script) Optional for –find, –findall
–script.prefind
(perform script before
–find)
Optional for –find, –findall
–script.presort (perform
script before sort)
Optional for –find, –findall
Use this
request name To generate this request
–styletype (stylesheet type) Optional for all requests
–stylehref (stylesheet
HREF)
Optional for all requests
–password Optional for –dbopen requests. Specifies the
database’s password.
field name (no hyphen) At least one field name is required for –new and
–edit. Optional for –find. See “field name (Name
of specific field)” on page A-10 for more
information.
Use these
parameter names To go with these requests