Monkeybread Software - MBS FileMaker Plugin: JSON.FindValueInArray

Topics All MacOS (Only) Windows (Only) Linux (Only, Not) iOS (Only, Not)
Components Crossplatform Mac & Win Server Client Old Deprecated Guides Examples Videos
New in version: 10.2 10.3 10.4 10.5 11.0 11.1 11.2 11.3 11.4 11.5 Statistic FMM Blog

JSON.FindValueInArray

Queries index of value in array.

Component	Version	macOS	Windows	Linux	Server	iOS SDK
JSON	9.0	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes

MBS( "JSON.FindValueInArray"; json; find { ; byContent; StartIndex } ) More

Parameters

Parameter Description Example Flags

json A JSON text or reference. {"key": "value"}

find A JSON text or reference to find. {"key": "value"}

byContent Compare JSON by content, so number can be found via text.
Default is 0, so type counts first. 1 Optional

StartIndex Available in MBS FileMaker Plugin 11.5 or newer.
Index of first element to check.
Zero if not specified.
If you like to continue searching, you can pass last result + 1. 0 Optional

Parameter	Description	Example	Flags
json	A JSON text or reference.	{"key": "value"}
find	A JSON text or reference to find.	{"key": "value"}
byContent	Compare JSON by content, so number can be found via text. Default is 0, so type counts first.	1	Optional
StartIndex	Available in MBS FileMaker Plugin 11.5 or newer. Index of first element to check. Zero if not specified. If you like to continue searching, you can pass last result + 1.	0	Optional

Result

Returns index or error.

Description

Queries index of value in array.
Returns zero based index or -1 if not found.

Version 10.0 or newer finds optionally by content, so number can be found via text.

Examples

Find value in an array of numbers:

MBS( "JSON.FindValueInArray"; "[5,6,7,1,4,3,7]"; 3)

Example result: 5

Find text:

MBS( "JSON.FindValueInArray"; "[\"Hello\", \"World\", \"Test\"]"; "\"World\"")

Example result: 1

Find objects:

MBS( "JSON.FindValueInArray"; "[{\"Hello\":123}, {\"World\":234}, {\"Test\":345}]"; "{\"World\":234}")

Example result: 1

Release notes

Version 11.5
- Added StartIndex parameter to JSON.FindValueInArray and JSON.FindValueInObjectArray functions, so you can repeat search until nothing more is found.
Version 10.0
- Added parameter to JSON.FindValueInArray and JSON.FindValueInObjectArray to compare by content.
Version 9.0
- Added JSON.CreateValue, JSON.Equals, JSON.FindValueInArray and JSON.FindValueInObjectArray functions.

Blog Entries

FileMaker Magazin

Ausgabe 5/2020, Seite 17, PDF

Created 14th December 2018, last changed 8th October 2021

JSON.Equals - JSON.FindValueInObjectArray

Feedback: Report problem or ask question.