set a variable to the contents of the Python script to run.Set Variable Ī representative sample of the result yields this:, ,, , 'r = fm.executesql ('SELECT id,category,name FROM EXAMPLE WHERE enabled_t = 'Y'')' & ¶ &Įxit Loop If Using this module, here is a complete FileMaker expression that queries the database and returns a JSON string: Set Variable [ For many purposes, the standard json module will do just fine.

Python has a number of good, robust, and fast JSON modules. But the combination makes for a very concise implementation. The bBox plugin and a small amount of Python scripting will be required.

This does have its own dependencies however. So I am going to propose yet another way. Some other solutions only parse JSON, but don’t encode it. And using a WebViewer has a number of complications, the main one being the awkwardness of getting data in & out of the WebViewer. JSON however doesn’t parse easily with FileMaker’s text handling functions.

Custom Functions based parsing & encoding.

There are a number of ways of working with JSON data in FileMaker.

Filemaker python