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.DeleteItemFromArray

Deletes an item from an array.

Parameters

Parameter	Description	Example
json	A JSON text or reference.	[1,2,3]
index	The zero based index of the value.	1

Result

Returns JSON code.

Description

Examples

Create array with numbers and delete last entry:

Let(
[
      j = MBS( "JSON.CreateDoubleArray"; 1; 2; 3);
      r = MBS( "JSON.DeleteItemFromArray"; j; MBS( "JSON.GetArraySize"; j )-1 )
];
r)

Filter items in JSON:

Let([
// input may come from caller
input = "[{\"land\": \"CH\"}, {\"land\": \"CH\"}, {\"land\": \"DE\"}, {\"land\": \"AT\"}, {\"land\": \"CH\"}, {\"land\": \"CH\"}]";

// parse the JSON
j = MBS("JSON.Parse"; input);
// loop over items backwards
c = MBS("JSON.GetArraySize"; j);
r = While ( [ i = c-1 ] ; i >= 0 ; [
    // query a value and if it doesn't match
    r = If( MBS( "JSON.GetPathItem"; j; i & ¶ & "land"; 1 ) <> "CH" ;
        // remove an item
        MBS( "JSON.DeleteItemFromArray"; j; i ); ""); i = i - 1 ] ; "" );
// Format and return JSON
r = MBS("JSON.Format"; j);
x = MBS("JSON.Release"; j)
]; r)

See also

• JSON.CreateDoubleArray
• JSON.DeleteItemFromObject
• JSON.Format
• JSON.GetArraySize
• JSON.GetPathItem
• JSON.Parse
• JSON.Release

Blog Entries

• With JSON in excellent form

FileMaker Magazin

• Ausgabe 5/2020, Seite 17, PDF

Created 18th August 2014, last changed 5th November 2020

JSON.CreateValue   -   JSON.DeleteItemFromObject

Feedback: Report problem or ask question.