akpbj.blogg.se - Filemaker 2021

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.

The JSONata Exerciser, where you can experiment with pre-existing examples, or with your own pasted in JSON.

A link to the Stack Overflow forum, where you can ask questions (which may or may not get answered), and.

The JSONata site is packed with useful information, including this short video… Recently I had the pleasure of speaking with Jeremy Brown on The Context Podcast about an open-source project called JSONata that enables you to query and transform JSON.