I have a situation where the only method to push third party app data to FileMaker is via a web form. I have looked into instant web publishing and while the login bypass is well documented, posting form data to a IWP page directly is not, and perhaps not possible.

So my question is this, I have a one shot webform that can be anything and I need it to both login into the database and post new records. Can this be done? The third party app doesn't offer any ODBC or other functionality associated with passing data, and while it does have SQL backend, the function cannot be scripted into the UI to update real time between the two apps.

My first thought is XML to XSLT server side being pushed by the webform. Can the login and creation of the record with data be accomplished in a single execution?

Any suggestions as to how to do this, not just the one I mentioned, would be greatly appreciated.

Thanks

A server-side XSLT can have a FM username/pw hard-coded into it, so that when it executes, it can push records directly into the FM server. You could also do this with a PHP script (my preference since I know PHP better than XSL) using one of the available APIs.