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

This function checks for a license.

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

JSON.CurrentMatchPath - JSON.DeleteItemFromObject