I have a need to pass data between FileMaker and another application
Have you looked at PyFileMaker?
In addition, just in the last year you'll find posts on this forum:
Plenty of good resources.
Yes! Two ways that work well:
1. Create a simple (free, etc.) Python micro-service. That's the most powerful way since once you are in the Python micro-service (Flask being the easiest), you're free to use any Python code available and then pass back data in any format you want to FMP.
I posted an entire tutorial on setting up a Flask micro-service from FileMaker
Check out my two micro-service tutorials in the App Innovations Area:
The Simplest Micro-Service! (Python and Flask)
A key (usually overlooked) advantage of creating a simple Python micro-service is that that micro-service can be used by other clients (Terminal, Browser, Any program that can issue HTTP verbs, not "just" FMP).
2. Use MBS' "Shell" command to call Python and get data back. This approach isn't as slick as the micro-service in my view, and you need to pay for MBS, but it will get the job done.
I even created a small FileMaker example using the MBS approach that works for both standalone Python and Standalone Java (again, I would recommend the micro-service route):
In the FMP example below, the Python (or Java) program just gets the input, upper-cases it, and returns it.
I do lots with Python (Machine Learning stuff, mostly), but I'm sure I can help if you have any questions.
Let me know.
Another interesting blog post on this topic by davidhamannmedia: https://davidhamann.de/2016/12/24/working-with-filemaker-data-in-python/ - also check out the other resources mention in this and other posts.
Functions in bBox allow you to set/get Python variables from FMP, evaluate FM calc's from Python, run snippets of Python code, or use FM's ExecuteSQL from Python. Text from FMP can be passed in to Python as stdin, and stdout output from Python is returned to FileMaker as a function result, making basic usage fairly simple.
Functions in FileMaker:
Functions in Python:
One caveat, mainly relevant for server-side calls, is that you can only have a single Python instance, so you'll need to block your calls or use Python threads for concurrent usage.
See beezwax > products for more information.
I used PyFileMaker, and it worked well. But be warned that it works only with Python 2.x. I asked the author if he thinks about porting it to Python 3.x, he will not for the moment.
Just use a python micro-service directly with FMP (no FMS required)!
Use INSERT FROM URL from FMP.
Simple. Quick. Easy.
Alternatively, you can use MBS' Shell command to directly call and get data back from Python programs per my postings above.
Will the OP please comment?
Retrieving data ...