FOR THE ARCHIVES So, now this is working:
http://10.211.55.6/fmi/xml/fmresultset.xml?-db=DBName&-lay=LayoutNameForFind&-script=SCRIPTNAME&-script.param=1234|B|apple&customerCode=1234&-find Parameters are separated with | and parsed in FileMaker; script does steps 1-4 (see below). Finds the record, runs the script like I wanted. What made it work? Besides giving the GUEST account Full Access privileges I also checked the "run script with full access privileges" checkbox inside the script. Another way that works is to have the GUEST account have Read-Only privileges and check the "run script with full access privileges" checkbox inside the script. On Jan 16, 2015, at 12:32 PM, Tami Williams <[email protected]> wrote: > From a web browser/any app, I need to submit and XML request to FileMaker and > get an XML result back, so I'm trying to use FileMaker 13 and an XML url to: > > 1. find a record > 2. if that record is found and one of its fields has a certain value > 3. create a record in another table > 4. show the user the fields from the record in the other table in xml format > > > I've tried to do this with an xml url that runs a script to do steps 1-3, > then finds the new record in step 4: > > http://IPAddress/fmi/xml/fmresultset.xml?-db=DBName&-lay=LayoutNameInOtherTable&-script.prefind=SCRIPTNAME&–script.prefind.param=1234%7B%7Capple&code=1234&-find > > > > > However, > > 1. how do you pass the username and password in the URL? > > This: > http://username:password@IPAddress/fmi/xml/fmresultset.xml?-db=DBName&-lay=LayoutNameInOtherTable&-script.prefind=SCRIPTNAME&–script.prefind.param=1234%7B%7Capple&code=1234&-find > > does NOT work > > So, I've given the GUEST account Full Access privileges. > > > 2. the script does not run > > (I've also tried -script and -script.param to run the script after the find > and that didnt' work either) > > > I can use XML to create a record OR find a record but not to run a script. > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > "It's better to burn out than to fade away." > > Tami Williams > Creative Computing > Let us help you make frustrating, costly, and inefficient processes more > efficient, less costly and scalable. > Lasso, MySQL and FileMaker specialists. > > Tel/Fax: 770.457.3221 > E-Mail: [email protected] > Web: http://www.asktami.com/ > LinkedIn: http://www.linkedin.com/in/asktami > Twitter: http://twitter.com/asktami > iChat/AIM/Skype: tamiwilliamsusa > > FileMaker Business Alliance Member | Lasso Professional Alliance Member | > Certified Lasso Developer | FileMaker 11, 12 & 13 Certified Developer > > ------ > > If you want to receive sporadic email from Creative Computing regarding news > at the company and announcements about upcoming Lasso webinars and online > classes, please opt-in at http://tinyurl.com/yj7eqlg >
