Table of Contents

, , ,

PARSE_JSON2

Description

Returns the value of the specified attribute in the same node

Syntax

PARSE_JSON2 (json, path, attribute)

Parameters

  1. String in JSON format or expression producing such a string
  2. A path to a JSON attribute in the JSONPath format (as explained here https://github.com/json-path/JsonPath)\n
  3. The name of the JSON attribute in the same node, the value of which should be returned

Returns

Text: the value of the named attribute in the same JSON node that the path matches.

Example

Object.Value = PARSE_JSON2(Object.Attribute, `$.store.books[?(@.Name == 'Romeo and Juliet')]`, 'Author')

The above returns 'Shakespear'

PARSE_JSON, PARSE_XML, LIST_TO_JSON