Querying JSON Files

Section Mutating JSON Files demonstrated using interface JsonQL.Compilation.IJsonCompiler to load one or more JSON files that have child/parent relationship with JsonQL expressions (the expressions mutate JSON files to new JSON structure). JsonQL also has an interface JsonQL.Query.IQueryManager which can be used to execute queries against one or more JSON files that have child/parent relationship with JsonQL expressions.

Note

Some of JsonQL.Query.IQueryManager methods are extension methods in JsonQL.Query.QueryManagerExtensions

• Section Result as C# Object describes using JsonQL.Query.IQueryManager to query JSON files and convert the query result to a C# object.

• Section Result as JSON Structure describes using JsonQL.Query.IQueryManager to query JSON files and convert the query to JSON structure.

Note

For more examples of querying JSON files look at demo and unit test examples at these links:

• Examples in JsonQL.Demos project

• Examples in JsonQL.Tests project

• Result as C# Object
  • Examples
    • Example of querying for a C# reference type object
    • Example of querying for value type value
    • Example of converting root JSON with JsonQL expressions to a C# object
  • Empty Query to Convert Json to Object Without Filtering
  • Error Details
    • Examples
      • Compilation error
      • Conversion error
  • Type Binding
    • Examples
      • Convert to Classes
      • Convert to Classes Interfaces
      • Replace Interface Implementation
  • Nullable Value Support
    • Nullable Syntax in Query Result Type
      • Examples
        • Result as Value Type
        • Result as Reference Type
        • Result as List of Value Type Items
        • Result as Arrays of Reference Type Items
        • Result as List of Arrays of Value Type Items
        • Result as List of Lists of Reference Type Items
    • Nullable Syntax in Queried Object Properties
  • Conversion Settings
    • Setting ConversionErrorTypeConfigurations
      • Report Errors as Warnings Example
      • Ignore Errors Example
      • Report Errors Example
    • Setting FailOnFirstError
    • Setting JsonPropertyFormat
    • Setting TryMapJsonConversionType
      • Example
  • Sample Files
    • Countries.json
    • Companies.json
    • Parameters.json
    • FilteredCompanies.json
• Result as JSON Structure
  • Query Result Data Structure: JsonQL.Query.IJsonValueQueryResult
    • JsonQL.JsonObjects.IParsedValue
  • Examples
    • Example of querying for a JSON array
    • Example of querying for a JSON object
    • Example of querying for simple JSON value
  • Error Details
    • Examples
      • Missing closing brace in queried JSON file:
      • Invalid parameters in query
  • Sample Files
    • Countries.json
    • Companies.json
    • Parameters.json
    • FilteredCompanies.json
• Reusing Compiled JSON Files