JSONSearchArray ( ~json ; ~arrayKey ; ~searchKey ; ~searchValue ; ~resultKey )

Search a JSON array for a value in a key, and specify the result key to return the value, ie search for an id key and return the name from that record

Be the first to rate this function Log in to vote

Mark Geerdes - Show more from this author
Technology By Design
https://www.tbdmn.com

Sample input:

JSONSearchArray (JSONSetElement ( "{}" ; [ "part[0].id" ; 1 ; JSONString ]; [ "part[0].name" ; "John" ; JSONString ]; [ "part[1].id" ; 2 ; JSONString ]; [ "part[1].name" ; "Mary" ; JSONString ]) ;"part";"id";"1";"name")

Sample output:

John

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

// Search a JSON array for a value in a key, and specify the result key to return the value, ie search for an id key and return the name from that record
// Created 2024 August 20, by Mark Geerdes, Technology By Design LLC
// Example - JSONSearchArray (JSONSetElement ( "{}" ; [ "part[0].id" ; 1 ; JSONString ]; [ "part[0].name" ; "John" ; JSONString ]; [ "part[1].id" ; 2 ; JSONString ]; [ "part[1].name" ; "Mary" ; JSONString ]) ;"part";"id";"1";"name") = "John"

While ( 
[ 
//	initialVariables
~loopCount = 1 ;
~arrayCount = ValueCount ( JSONListKeys ( ~json ; ~arrayKey ) ) ;
~result = ""
] ; 
//	condition 
~loopCount < ~arrayCount and ~result = ""
; [ 
//	logic 
~result = If ( 
JSONGetElement ( ~json ; ~arrayKey & "[" & ~loopCount -1 & "]." & ~searchKey ) = ~searchValue ; 
JSONGetElement ( ~json ; ~arrayKey & "[" & ~loopCount -1 & "]." & ~resultKey ) 
) ;
~loopCount = ~loopCount +1
] ; 
//	result 
~result
)

Search a JSON array for a value in a key, and specify the result key to return the value, ie search for an id key and return the name from that record.
Created 2024 August 20, by Mark Geerdes, Technology By Design LLC
Example - JSONSearchArray (JSONSetElement ( "{}" ; [ "part[0].id" ; 1 ; JSONString ]; [ "part[0].name" ; "John" ; JSONString ]; [ "part[1].id" ; 2 ; JSONString ]; [ "part[1].name" ; "Mary" ; JSONString ]) ;"part";"id";"1";"name") = "John"

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

JSONSearchArray ( ~json ; ~arrayKey ; ~searchKey ; ~searchValue ; ~resultKey )

Comments

Support this website.

Support this website.