JSONMergeArrays ( array1 ; array2 )

Merge two JSON arrays

Average rating: 5.0 (1 vote) Log in to vote

Rob Poelking - Show more from this author
Kiza Solutions
https://kizasolutions.com

Sample input:

JSONMergeArrays ( "[1,2]" ; "[3,4]" )

Sample output:

[1,2,3,4]

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/**
 * ==================================================================
 * JSONMergeArrays ( array1 ; array2 )
 *
 * PARAMETERS:
 *            @array1 (JSONArray) 
 *            @array2 (JSONArray) 
 * RETURNS:
 *            (JSONArray) Merged array
 *            
 * DEPENDENCIES:
 *            FileMaker 18 or above
 * PURPOSE:
 *            Takes 2 properly formmated JSONArrays
 *            and merges them into one array
 * NOTES:
 *            does not validate JSON
 * AUTHOR:
 *            Rob Poelking rob@excelisys.com
 * REVISIONS:
 *            v1.0 2019-08-27 Rob Poelking - initial release
 * ==================================================================
 *
 */

While (
	//initial vars 
	[
		~newArray = array1 ;
		~array2Length = ValueCount ( JSONListKeys ( array2 ; "" ) ) ;
		~n = 0 ;
		~start = ValueCount ( JSONListKeys ( array1 ; "" ) )
	] ;
	//condition
	~n < ~array2Length ;
	//logic 
	[ 
		~n=~n+1 ;
		~newArray = JSONSetElement ( ~newArray ; "[" & ~start + ~n-1 & "]"   ; JSONGetElement ( array2 ; "[" & ~n-1 & "]" ) ; "" ) 
	] ;
	
	//result
	~newArray
)

Function takes two properly formatted JSON arrays and merges them into one. Function will not validate for syntax. No error will be returned if the input JSON is not properly formatted.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

JSONMergeArrays ( array1 ; array2 )

Comments

Support this website.

Support this website.