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 <[log in to unmask]> 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:
> [log in to unmask]&-lay=LayoutNameInOtherTable&-script.prefind=SCRIPTNAME&–script.prefind.param=1234%7B%7Capple&code=1234&-find" target="_blank">http://username:[log in to unmask]&-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: [log in to unmask]
> 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
>