FMPRO-L Archives

January 2015, Week 3

FMPRO-L@LISTSERV.DARTMOUTH.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Tami Williams <[log in to unmask]>
Reply To:
FileMaker Pro Discussions <[log in to unmask]>
Date:
Fri, 16 Jan 2015 12:32:40 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (58 lines)
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

ATOM RSS1 RSS2