Skip to content

Formula > Functions > JSON

json\retrieve

json\retrieve(JSON, [PATH])

Retrieves a specific attribute from a JSON string. PATH is a string, items are separated by dots. (as of v6.0)

If PATH is omitted, it will return the whole JSON parsed (as of v8.0.4).

Example

Retrieving id from {"id": "SOME_ID"}:

$value = json\retrieve($someJsonString, 'id');`

Example

Retrieving id from [{"id": "SOME_ID"}]:

$value = json\retrieve($someJsonString, '0.id');`

json\encode

json\encode(VALUE)

Encodes a VALUE to a json string. (as of v7.1)