JSON.FindValueInArray

Queries index of value in array.

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

Result

Returns index or error.

Description

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

Find the apple:

MBS( "JSON.FindValueInArray";
// some json with an emoji
"[\"Test\",\"🍎\",\"Other\"]";
// and we can find it with unicode escape (or by passing the emoji again)
"\"\uD83C\uDF4E\"")

See also

• JSON.AddValueToArray
• JSON.FindValueInObjectArray

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

• MBS FileMaker Plugin, version 11.5pr2
• MBS FileMaker Plugin, version 10.0pr8
• With JSON in excellent form
• MBS FileMaker Plugin, version 8.6pr4

This function checks for a license.

Created 14th December 2018, last changed 31st January 2023

JSON.FilterObjectArray - JSON.FindValueInObjectArray