JSONListToObject ( objectsList )

Converts a value list of existing JSON objects into a single object.

Be the first to rate this function Log in to vote

Stephan Casas - Show more from this author
http://www.stephancasas.com

Sample input:

JSONListToObject ( "{\"key0\": \"value0\"}¶{\"key1\": \"value1\"}" )

Sample output:

"{\"key0\": \"value0\", \"key1\": \"value1\"}"

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

//INFO
// dependencies: InsertValue ( valueList ; index ; value ) - available on _
                 briandunning.com
// min. version: FileMaker Pro 16
// return:       text

//PARAMETERS
// objectsList:  a ¶-delimited list of JSON objects

JSONSetElement ( $ ; $ ;

"{" &

Evaluate (

"Let([i = 0; json = $]; " & Substitute((10 ^ ValueCount(objectsList)) - 1; 9; "Let([i = i + 1; e = JSONFormatElements(GetValue(" & Quote(objectsList) & "; i)); e = InsertValue(e; 1; $); e = InsertValue(e; ValueCount(e); $); json = json & If(not IsEmpty(json); \",\") & Substitute(e; \¶; $)]; ") & "json" & Substitute((10 ^ ValueCount(objectsList)) - 1; 9; ")") & ")"

)

& "}" ; 3 )

This function is useful when merging existing JSON objects into one single object. For example, you could use the List() function on a field to collect the JSON representations of child records and then use JSONListToObject() to deliver the information as one JSON-accessible text element.

The function works by utilizing my nested Let() function method, which is well-documented in my InsertValue() function on this site.

Data passed into the objectsList parameter must be a value list of valid JSON objects, or the function will fail to evaluate correctly. Invalid parameter data will yield a '?' character at runtime.

Comments

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

JSONListToObject ( objectsList )

Comments

Support this website.

Support this website.