JSON Path Functions

• JsonQL path functions are used along with one or more ‘.’ separators (i.e., multiple functions can be applied in sequence) to access values in JSON files.

• The sections below describe the available JsonQL path functions, but the example below is a simple example demonstrating use of multiple chained functions (i.e., ‘Where’ and ‘First’) along with chained access to JSON objects and fields (i.e, ‘Employees’, and ‘Address’) :

• There is no limit on how many times you may apply the JSON path functions, or access JSON objects and fields in chained manner.

• Summary
  • Common Characteristics
  • Usage Patterns
  • Key Differences: Arrays vs Collections
  • Example Limitation
  • Common Use Cases
  • Best Practices
  • Example
• Array Indexers
  • Example
• At
  • Function Parameters
  • Example
• First
  • Function Parameters
  • Example
• Last
  • Function Parameters
  • Example
• Where
  • Function Parameters
  • Example
• Select
  • Function Parameters
  • Example
• Flatten
  • Function Parameters
  • Example
• Reverse
  • Function Parameters
  • Example