JSONCombineObjects ( object1 ; object2 )

Combines two JSON objects into one JSON object.

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

Joshua Willing - Show more from this author
Willing Apps

Sample input:

JSONCombineObjects ( "{\"a\": 123}" ; "{\"b\": 234}" )

Sample output:

{"a":123,"b":234}

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

/*
JSONCombineObjects ( object1 ; object2 )
PURPOSE:
	Combines two valid JSON objects into one big JSON object
OUTPUT:
	A new valid json object.
	? if either input is not a valid JSON object.
	A standard json parse error if the resulting object is invalid. E.g. if it has duplicate keys.
REVISIONS:
	2018-11-10	Joshua Willing	jwillinghalpern@gmail.com
		- CREATED
*/

Let ([
	~isInvalid1 = Left ( JSONFormatElements ( object1 ) ; 1 ) <> "{";
	~posStart1 = Position ( object1 ; "{" ; 1 ; 1 );
	~posEnd1 = Position ( object1 ; "}" ; Length ( object1 ) ; -1 );
	~props1 = Middle ( object1 ; ~posStart1 + 1 ; ~posEnd1 - ~posStart1 - 1 );

	~isInvalid2 = Left ( JSONFormatElements ( object2 ) ; 1 ) <> "{";
	~posStart2 = Position ( object2 ; "{" ; 1 ; 1 );
	~posEnd2 = Position ( object2 ; "}" ; Length ( object2 ) ; -1 );
	~props2 = Middle ( object2 ; ~posStart2 + 1 ; ~posEnd2 - ~posStart2 - 1 );

	~newObj = "{" & ~props1 & "," & ~props2 & "}" ;
	~formatted = JSONFormatElements ( ~newObj );
	~result = 
		Case ( 
			Left ( ~formatted ; 1 ) = "?" ; 
				~formatted ; 
			~isInvalid1 or ~isInvalid2 ;
				"?" ;
			// Else
				~newObj 
		)
];
	~result
)

Combines two JSON objects into one JSON object without using recursion. The objects must not use the same keys or it will return a json "Duplicate key" error.

Comments

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

JSONCombineObjects ( object1 ; object2 )

Comments

Support this website.

Support this website.