Push XML at Advanced Server

[wplate]

I'm trying to understand how to have a web server insert data into a FileMaker database. The data is coming from a perl-based shopping cart, and we have FileMaker Server Advanced. The goal is that as orders are entered on the existing shopping cart, the perl script "pushes" XML at the FileMaker server creating a new record in the database. I'm finding that resources are hard to come by.

[Martin Brändle]

XML is output by FMSA, but is not used as input for record creation.

For record creation and editing, standard CGI queries are used. Consider reading the CWP Guide that comes with FMSA, Appendix A about the query language.

[wplate]

Thank you, that is good information to hear, I didn't know that. I'll start looking at Appendix A.

[wplate]

Martin, your post was VERY helpful. Thank you.

Using this I can add a record to a database...

http://192.168.0.100/fmi/xml/fmresultset.xml?-db=TESTGETCSV&-lay=layout&BillingFirstName=Wes&BillingLastName=Plate&BillingCompany=AutomaticDuck&-new

SO COOL.

[Martin Brändle]

If you can, turn off XML publishing and use only XSLT publishing for the DB in question. With XML publishing too much information can be read from the database with the right queries.