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: 9.3   9.4   9.5   10.0   10.1   10.2   10.3   10.4   10.5   10.6    Statistic    FMM    Blog  

JSON.FindValueInObjectArray

Queries index of value in object array.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
JSON 9.0 Yes Yes Yes Yes Yes
MBS( "JSON.FindValueInObjectArray"; json; Label; find { ; byContent } )   More

Parameters

Parameter Description Example Flags
json A JSON text or reference. "[{\"key\": 1}]"
Label The label for the value in the object to compare. "key"
find A JSON text or reference to find. 1
byContent Compare JSON by content, so number can be found via text.
Default is 0, so type counts first.
1 Optional

Result

Returns index or error.

Description

Queries index of value in object array.
Returns zero based index or -1 if not found.
We look into each object in the array, check if it has a value for the given label and compare that to the one to find.

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

Examples

Find item:

MBS( "JSON.FindValueInObjectArray"; "[{\"key\": 1}]"; "key"; 1 )

Example result: 0

See also

Blog Entries

Release notes

Created 14th December 2018, last changed 10th January 2020


JSON.FindValueInArray   -   JSON.Format

Feedback: Report problem or ask question.




Links
MBS Xojo blog