# Python FMS?

**URL:** <https://the.fmsoup.org/t/python-fms/3051>\
**Category:** Questions\
**Tags:** community\
**Created:** [August 16, 2022, 2:25pm UTC](https://the.fmsoup.org/t/python-fms/3051 "2022-08-16T14:25:11Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![OliverBarrett](https://avatars.discourse-cdn.com/v4/letter/o/f19dbf/32.png) [@OliverBarrett](https://the.fmsoup.org/u/OliverBarrett)\
**Post date:** [August 16, 2022, 2:25pm UTC](https://the.fmsoup.org/t/python-fms/3051/1 "2022-08-16T14:25:11Z")

</div>

Is anyone using Python to connect to FMS using _any_ method like the Python FMS connector?

Thanks,

---

<div class="post-metadata">

**Author:** ![samfmp](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@samfmp](https://the.fmsoup.org/u/samfmp)\
**Post date:** [August 16, 2022, 10:19pm UTC](https://the.fmsoup.org/t/python-fms/3051/2 "2022-08-16T22:19:06Z")

</div>

Hi did you mean python and data api?

---

<div class="post-metadata">

**Author:** ![OliverBarrett](https://avatars.discourse-cdn.com/v4/letter/o/f19dbf/32.png) [@OliverBarrett](https://the.fmsoup.org/u/OliverBarrett)\
**Post date:** [August 16, 2022, 10:33pm UTC](https://the.fmsoup.org/t/python-fms/3051/3 "2022-08-16T22:33:49Z")

</div>

Thanks for your reply. Really, I'm just wondering if anyone uses Python-_anything_ with FMS.

---

<div class="post-metadata">

**Author:** ![Malcolm](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/malcolm/32/196_2.png) [@Malcolm](https://the.fmsoup.org/u/Malcolm)\
**Post date:** [August 16, 2022, 11:07pm UTC](https://the.fmsoup.org/t/python-fms/3051/4 "2022-08-16T23:07:18Z")

</div>

I collaborated with a developer to deliver a shop-front ordering system. All of the data sources were managed by FileMaker. He used Python as the code for the website and the comms with FileMaker. I never saw the code, and I don't know what effort was required, but the website worked really well.

---

<div class="post-metadata">

**Author:** ![jwilling](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/jwilling/32/256_2.png) [@jwilling](https://the.fmsoup.org/u/jwilling)\
**Post date:** [August 17, 2022, 3:58am UTC](https://the.fmsoup.org/t/python-fms/3051/5 "2022-08-17T03:58:57Z")

</div>

I did a project that used python extensively on the client computer using BaseElements `BE_ExecuteSystemCommand`. One of the hurdles I encountered was that the scripts had to be called with the full path to the python executable and the scripts themselves had to use full paths to the various imported modules. Just a couple gotchas, but it ended up working great.

Looking back, I wish that the client had just hired me to write the scripts in filemaker in the first place instead of a python developer, especially because he wanted to call them from filemaker in the end anyway. But it gave me a chance to brush up on some python, so it's all good.

---

<div class="post-metadata">

**Author:** ![depotmaestro](https://avatars.discourse-cdn.com/v4/letter/d/9f8e36/32.png) [@depotmaestro](https://the.fmsoup.org/u/depotmaestro)\
**Post date:** [August 19, 2022, 1:06pm UTC](https://the.fmsoup.org/t/python-fms/3051/6 "2022-08-19T13:06:10Z")

</div>

We're using Python in the mix somewhere that drives our React Scheduler. Also in there are GraphQL, Go and Django.  
But I'm the UI guy so I don't have the technical details.  
I do know that right now we can't update the server past 19.2.1 because that's the last version that supports the older ODBC driver. It does not work with Apple Silicon.

---

<div class="post-metadata">

**Author:** ![OliverBarrett](https://avatars.discourse-cdn.com/v4/letter/o/f19dbf/32.png) [@OliverBarrett](https://the.fmsoup.org/u/OliverBarrett)\
**Post date:** [August 19, 2022, 1:25pm UTC](https://the.fmsoup.org/t/python-fms/3051/7 "2022-08-19T13:25:47Z")

</div>

thanks

---

<div class="post-metadata">

**Author:** ![JayG](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/jayg/32/616_2.png) [@JayG](https://the.fmsoup.org/u/JayG)\
**Post date:** [June 5, 2023, 5:45am UTC](https://the.fmsoup.org/t/python-fms/3051/8 "2023-06-05T05:45:13Z")

</div>

**bBox plug-in for FileMaker**

> **[bBox | Beezwax](https://beezwax.net/products/bbox)**
>
> The bBox plugin extends the reach of your macOS-based FileMaker solutions to programs, code libraries, or native functions that are normally outside your reach. Now you can plug Python, JavaScript, Ruby, Perl, PHP, AppleScript, bash/sh, XPath, and...

- macOS (FM Pro, FM Server) and Linux (FM Server) only
- 50+ functions, many useable as script steps
- Free, as in beer

**Python functions:**

- bBox\_Python3Run ( mode; script; text {; param1; ...} )
- bBox\_PythonCompile ( mode; script )
- bBox\_PythonEval ( reference; expression )
- bBox\_PythonExecute ( mode )
- bBox\_PythonFinalize
- bBox\_PythonGetVar ( name }
- bBox\_PythonSetVar ( name; value {; asType} )

* * *

As mentioned, other plugins (MBS, BE) can be used to execute python. Also, various methods using Data API, serverless or microservices models, etc.

---

<div class="post-metadata">

**Author:** ![OliverBarrett](https://avatars.discourse-cdn.com/v4/letter/o/f19dbf/32.png) [@OliverBarrett](https://the.fmsoup.org/u/OliverBarrett)\
**Post date:** [June 5, 2023, 10:06am UTC](https://the.fmsoup.org/t/python-fms/3051/9 "2023-06-05T10:06:36Z")

</div>

I avoid plug-ins at all cost since they restrict me to a "FileMaker-Only" implementation (often with expensive server costs and restrictions).  
A simple REST ("micro") service is, IMHO, far superior as it can be used with any HTTP-capable application (like, for example, FileMaker) and you control the code so no worries about needing the "developer" to fix any issues. Free and quick to set up in just about any modern programming language, also.

---

<div class="post-metadata">

**Author:** ![steve\_ssh](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/steve_ssh/32/160_2.png) [@steve\_ssh](https://the.fmsoup.org/u/steve_ssh)\
**Post date:** [June 5, 2023, 5:07pm UTC](https://the.fmsoup.org/t/python-fms/3051/10 "2023-06-05T17:07:43Z")

</div>

Nice to see you here, @JayG . Welcome to the Soup.

---

<div class="post-metadata">

**Author:** ![Malcolm](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/malcolm/32/196_2.png) [@Malcolm](https://the.fmsoup.org/u/Malcolm)\
**Post date:** [June 6, 2023, 6:02am UTC](https://the.fmsoup.org/t/python-fms/3051/11 "2023-06-06T06:02:34Z")

</div>

Nice product. Is that your work?

---

<div class="post-metadata">

**Author:** ![JayG](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/jayg/32/616_2.png) [@JayG](https://the.fmsoup.org/u/JayG)\
**Post date:** [June 7, 2023, 6:45am UTC](https://the.fmsoup.org/t/python-fms/3051/12 "2023-06-07T06:45:13Z")

</div>

Simon Brown is the chief architect. Others contribute code, testing, docs.

---

<div class="post-metadata">

**Author:** ![JayG](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/jayg/32/616_2.png) [@JayG](https://the.fmsoup.org/u/JayG)\
**Post date:** [June 7, 2023, 6:50am UTC](https://the.fmsoup.org/t/python-fms/3051/13 "2023-06-07T06:50:32Z")

</div>

Thanks! Been lurking for 3 years.
