ExplodeJSON ( JSON )

Converts JSON into a list that is easily searchable in Filemaker. I reccoment using this with the

Average rating: 4.4 (5 votes) Log in to vote

Guy - Show more from this author

Sample input:

ExplodeJSON ("{\"accountType\":\"CFD\",\"accountInfo\":{\"balance\":226.03,\"deposit\":161.52,\"pl\":-419.32,\"available\":231.19}")

Sample output:

accountType:CFD
accountInfo:
balance:226.03
deposit:161.52
profitLoss:-419.32
available:231.19

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

Let ( explodedjson = Substitute ( JSON ; ["\",\"";"¶"];["}";"¶"];["{";"¶"];["}";""];["\"";""];[",";"¶"];["[";""];["]";""] ) ; 

Middle ( explodedjson ; 2 ; Length (explodedjson) )

)

This function takes a multi layer JSON string and concerts it into a human readable list that can easily be searched using the "FindValues" function.

Comments

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

ExplodeJSON ( JSON )

Comments

Support this website.

Support this website.