JSONPARSE

Extracts a single field from a json

Due to the complexity of parsing several rows of JSON, this function takes longer than the average AuditBoard Analytics function.

JSONPARSE( Column, Name )

Checks if a column contains an input name within the Json path

Arguments

Input	Description
column	Column of json to parse and extract field for name
name	String path to search for in column

Output

Outputs field found in json

See documentation for further details:

https://jsonpath-rw.readthedocs.io/en/latest/#jsonpath-syntax

Example

Json	JSONPARSE( { Json }, "first" )
{"first" : "John", "middle" : "K", "last" : "Doe"}	"John"
{"first" : "Jane", "middle" : "J", "last" : "Doe"}	"Jane"

Example 2

Json	JSONPARSE( { Json }, "name[0].middle" )
{"name": [{"first" : "John", "middle" : "K", "last" : "Doe"}]}	"K"
{"name": [{"first" : "Jane", "middle" : "J", "last" : "Doe"}]}	"J"