@JSONFind_in_array ( json ; array_name ; return_column ; search_column ; search_value )

Extracts the value(s) for element 'return_column' from a JSON array row where element 'search_column' = 'searchvalue'

Be the first to rate this function Log in to vote

Oliver Reid - Show more from this author

Sample input:

("{\"Rows\" : [
{\"Row_id\":1,\"Value\":10},
{\"Row_id\":2,\"Value\":20},{\"Row_id\":3,\"Value\":30}]
}";
"Rows";
"Value";
"Row_id";
2)

Sample output:

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



Let(@count=@JSON_count_array_rows ( json ; array_name );

While([@i=0;@result=""];@i<@count;

[@result=List(@result;If(JSONGetElement(json;array_name&"["&@i&"]."&search_column )=search_value;JSONGetElement(json;array_name&"["&@i&"]."&return_column));"");
@i=@i+1]

; @result



)
)

analog of

Select Value from Rows where Row_id = search_value

Uses c.f. @JSON_count_array_rows ( json ; array_name )

Comments

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

@JSONFind_in_array ( json ; array_name ; return_column ; search_column ; search_value )

Comments

Support this website.

Support this website.