Solved

Filemaker Pro Connection to Web Service

Posted on 2013-05-10
2
973 Views
Last Modified: 2013-05-17
I have a local Filemaker Pro database that I want to be able to connect to a specific webservice so that I can sync my data to the data on the webservice. The webservice accepts http posts (in xml format) and provides a response (also in xml format). Any recommendations for the best way to make this work?
0
Comment
Question by:garyknight
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 11

Accepted Solution

by:
Andrew Angell earned 500 total points
ID: 39157509
There are a few ways you could make this work.

1)  Get a plugin for FM that provides HTTP POSTing capabilities.  The Troi URL plugin is one example.  Then you could generate your XML request within a FM script and POST it to your web service endpoint URL using the Troi plugin.  Then you'd also have to parse the XML response data which can be a little tricky within FM scripts.  

2)  Build your own web services to receive data from your FM apps and communicate with the 3rd party web services. Then you could send data to your web service within a web viewer in FM by simply setting the URL of the web viewer to your service endpoint with all of the data included as URL parameters.  I would recommend PHP because then you can use the FM PHP API (with FM Server) to push data back to FM from that web service. The web viewer in FM could be setup to simply display the progress and a complete or failed message accordingly.  

3)  The way I do it is by using the Scodigo PHP SmartPill plugin.  This plugin actually gives you the power of PHP from directly within FM so you can write PHP code to handle things like generating and parsing XML, POSTing data, and pretty much anything else you can do with PHP.  You can embed your PHP code in FM fields and run it when necessary to accomplish your goals.  This way is nice because you can build things directly into FM scripts and you don't need a web viewer.  Your PHP scripts can run just like regular FM scripts and it makes it work a lot more seamlessly.  You could even build your own custom functions that utilize the PHP to make calling it from FM very simple.

One example is this set of PayPal API functions I released for FM awhile back.
0
 

Author Closing Comment

by:garyknight
ID: 39174652
I ended up using the Troi URL plugin. Works great for my purposes. Thanks!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
micro services vs rest web services 16 153
read an xml file in perl 2 70
ebay devID, appID, certID, userToken 2 85
XSL for-each loop - Excluding specific text 4 18
New Relic recently released its Synthetics product that allows for the creation of performance monitors that periodically test a site's performance. If you wish to test an interactive workflow New Relic employs Selenium WebDriverJS to run those test…
Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
The purpose of this video is to demonstrate how to set up the WordPress backend so that each page automatically generates a Mailchimp signup form in the sidebar. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question