Tools

JSON to FileMaker calc, both ways.

Edit either side and the other side updates. Paste a JSON object on the left to generate a JSONSetElement calculation, or paste an existing calc on the right to recover the JSON it would produce. No escape wrangling, no FileMaker required.

JSON

FileMaker calc

Reference

Type mapping

JSON	FileMaker value	Type constant
string	"value"	JSONString
number	42 / 3.14	JSONNumber
true / false	True / False	JSONBoolean
null	""	JSONNull
{} (empty)	"{}"	JSONObject
[] (empty)	"[]"	JSONArray

JSONRaw triples are also accepted on the calc side; their string value is parsed as JSON and inlined into the result.

Path notation

Nested values are flattened using FileMaker JSON path syntax: dot notation for simple object keys, bracket notation for array indices and keys that contain path characters. {"opts": {"fps": 24}} emits "opts.fps", while {"a.b": 1} uses "['a.b']". Array append and last-item references like "[+]" and "[:]" are also understood on the calc side.