Brian Dunning's FileMaker Custom Functions

ExplodeJSON ( JSON )

Converts JSON into a list that is easily searchable in Filemaker. I reccoment using this with the "FindValues" custom function available on this site.

  Average rating: 4.3 (4 votes) Log in to vote

Guy Wickenden   Guy Wickenden
TBSC
None.

Share on Facebook Share on Twitter

  Sample input:
ExplodeJSON ("{\"accountType\":\"CFD\",\"accountInfo\":{\"balance\":22677.03,\"deposit\":16167.52,\"profitLoss\":-4199.32,\"available\":2310.19}")
  Sample output:
accountType:CFD
accountInfo:
balance:22677.03
deposit:16167.52
profitLoss:-4199.32
available:2310.19

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

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

Log in to post comments.

 

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

Under construction. Email me your wish list for improvements.