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
Solved

Filemaker Pro Connection to Web Service

Posted on 2013-05-10
2
966 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
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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
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…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

860 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