JSONQuery

Overview

JSONQuery is a FileMaker custom function authored by Steve Senft-Herrera that enables you to query JSON data in FileMaker 18 or later¹.

Basic Capabilities

1. Query - Find elements matching specific values with various operators
2. Aggregate - Return aggregates (SUM, AVG, LIST, etc.) from matched elements
3. Transform - Customize output format with selective attribute inclusion

Examples

This example will find all elements in the JSON string that have a DetailType of SalesItemLineDetail and return a list of their IDs.

JSONQuery(
	
	$lines ;					/*  JSON 	*/
	"DetailType" ;			    /*  TargetPath	*/
	"EQUALS" ;				    /*  Operator	*/
	"SalesItemLineDetail" ;	    /*  ComparisonValue	*/
	JSONString ;				/*  ValueType	*/
	""						    /*  ResultPath	*/
)

Resources

• Official GitHub Repository
• FileMakerHacks Blog Post on JSONQuery 2.0²
• Demo file available with comprehensive examples

References