![]() ![]() Python returned the JSON string to FileMaker.asked the json function to convert the Python list object into JSON text.executed a SQL request in FileMaker, which was returned as a Python list.created a Python VM and had the script compiled.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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |