
Since each country entry includes a “timezones” array, I decided to query those arrays for countries with more than two time zones. For instance, in the above example, the source JSON comes from. In the demo you’ll find examples that convey a tiny bit of what’s possible with JSONata.

Instructions: choose an entry on the left, then click “Get result into the field” to see results.

Note: the demo requires an online connection to access the JSONata library. If you’d like to learn more re: what’s going on under the hood, Jeremy goes into specifics here: Towards a Better JS Development Environment. Okay, a JSON query and transformation language sounds intriguing, at least in theory, but wouldn’t it be great if we could harness that power from within FileMaker? Well, now we can, utilizing techniques in this demo, built by Jeremy and shared here with his permission.ĭemo file: JSONata.zip (requires FM 19+ on Mac, 19.3+ on Windows)Īs you’ve probably surmised, the demo makes use of the Perform JavaScript in Web Viewer script step.
