Has two parameters: Source, Name

Description

From the Source JSON data, find the first matching name and return the value for that name.

As this function must parse the entire JSON data to validate the structure of the JSON data and look for a potential matching name behind any embedded content beyond the second level, this function should only be used when the JSON data is lightweight, or under low-performance requirements, or when the rest of the JSON data does not otherwise need to be parsed into the Work Query.

When used as a function in the Text command, this function is particularly useful for extracting data in the 3rd and further dimensions.

Although Source must be a valid, if Name is not found in the JSON Source an empty string is returned; it will not trigger a runtime error.