{
"CompiledJsonFiles":[
{
"TextIdentifier": "Parameters",
"CompiledParsedValue":
{
"FilteredCountryNames": [
"United States",
"Germany"
],
"FilteredCompanyNames": [
"Strange Things, Inc"
]
}
},
{
"TextIdentifier": "Countries",
"CompiledParsedValue":
{
"Countries": [
{
"Name": "United States",
"Population": 331000000,
"Area": 9833520,
"GDP": 21.43
},
{
"Name": "Canada",
"Population": 37590000,
"Area": 9984670,
"GDP": 1.64
},
{
"Name": "Germany",
"Population": 83000000,
"Area": 357022,
"GDP": 3.86
},
{
"Name": "Australia",
"Population": 25690000,
"Area": 7692024,
"GDP": 1.39
},
{
"Name": "India",
"Population": 1380000000,
"Area": 3287263,
"GDP": 2.87
}
]
}
},
{
"TextIdentifier": "Companies",
"CompiledParsedValue":
{
"Companies": [
{
"CompanyData": {
"Name": "Strange Things, Inc",
"CEO": "John Malkowich",
"Address": {
"Street": "123 Maple Street",
"City": "Springfield",
"State": "IL",
"ZipCode": "62701"
},
"CountryDetails": [
{
"Name": "United States",
"Population": 331000000,
"Area": 9833520,
"GDP": 21.43
}
]
},
"Employees": [
{
"Id": 100000001,
"Name": "John Smith",
"Address": {
"Street": "456 Oak Avenue",
"City": "Chicago",
"State": "IL",
"ZipCode": "60601"
},
"Salary": 99500,
"Age": 45
},
{
"Id": 100000002,
"Name": "Alice Johnson",
"Address": {
"Street": "123 Maple Street",
"City": "New York",
"State": "NY",
"ZipCode": "10001"
},
"Salary": 105000,
"Age": 38
},
{
"Id": 100000003,
"Name": "Michael Brown",
"Address": {
"Street": "789 Pine Lane",
"City": "Los Angeles",
"State": "CA",
"ZipCode": "90001"
},
"Salary": 89000,
"Age": 50
},
{
"Id": 100000004,
"Name": "Emily Davis",
"Address": {
"Street": "321 Elm Drive",
"City": "Houston",
"State": "TX",
"ZipCode": "77001"
},
"Salary": 92000,
"Age": 42
}
]
},
{
"CompanyData": {
"Name": "Sherwood Forest Timber, Inc",
"CEO": "Robin Wood",
"Address": {
"Street": "789 Pine Lane",
"City": "Denver",
"State": "CO",
"ZipCode": "80203"
},
"CountryDetails": [
{
"Name": "Germany",
"Population": 83000000,
"Area": 357022,
"GDP": 3.86
}
]
},
"Employees": [
{
"Id": 100000005,
"Name": "Christopher Garcia",
"Address": {
"Street": "654 Cedar Road",
"City": "Phoenix",
"State": "AZ",
"ZipCode": "85001"
},
"Salary": 111000,
"Age": 29,
"Logins": [
"cgarcia@sherwood.com",
"cgarcia@gmail.com"
]
},
{
"Id": 100000006,
"Name": "Sarah Wilson",
"Address": null,
"Salary": 78000,
"Age": 35
},
{
"Id": 100000007,
"Name": "David Martinez",
"Address": {
"Street": "147 Birch Street",
"City": "San Antonio",
"State": "TX",
"ZipCode": "78201"
},
"Salary": 95000,
"Age": 46,
"Logins": [
"dmartinez@sherwood.com",
"dmartinez@gmail.com"
]
}
]
},
{
"CompanyData": {
"Name": "Atlantic Transfers, Inc",
"CEO": "Black Beard",
"Address": {
"Street": "101 Elm Drive",
"City": "Dallas",
"State": "TX",
"ZipCode": "75201"
},
"CountryDetails": [
{
"Name": "United States",
"Population": 331000000,
"Area": 9833520,
"GDP": 21.43
}
]
},
"Employees": [
{
"Id": 100000008,
"Name": "Laura Lee",
"Address": {
"Street": "258 Willow Lane",
"City": "San Diego",
"State": "CA",
"ZipCode": "92101"
},
"Salary": 105500,
"Age": 32
},
{
"Id": 100000009,
"Name": "Andrew Harris",
"Address": {
"Street": "369 Spruce Drive",
"City": "Dallas",
"State": "TX",
"ZipCode": "75201"
},
"Salary": 88000,
"Age": 41
},
{
"Id": 100000010,
"Name": "Jessica Thompson",
"Address": {
"Street": "159 Cherry Lane",
"City": "Austin",
"State": "TX",
"ZipCode": "73301"
},
"Salary": 98700,
"Age": 37
},
{
"Id": 250150245,
"Name": "Jane Doe",
"Address": {
"Street": "Main St",
"City": "San Jose",
"State": "PA",
"ZipCode": "95101"
},
"Salary": 144186,
"Age": 63
},
{
"Id": 783328759,
"Name": "Robert Brown",
"Address": {
"Street": "Pine St",
"City": "Los Angeles",
"State": "CA",
"ZipCode": "90001"
},
"Salary": 122395,
"Age": 58
}
]
}
]
}
},
{
"TextIdentifier": "FilteredCompanies",
"CompiledParsedValue":
{
"AdditionalCompanyNames": [
"Atlantic Transfers, Inc"
],
"comments1": "'FilteredCompanyNames' is in parent JSON 'Parameters.json'.",
"comments2": "We filter companies that are either in FilteredCompanyNames or in AdditionalCompanyNames in this file.",
"FilteredCompanies": [
{
"CompanyData": {
"Name": "Strange Things, Inc",
"CEO": "John Malkowich",
"Address": {
"Street": "123 Maple Street",
"City": "Springfield",
"State": "IL",
"ZipCode": "62701"
},
"CountryDetails": [
{
"Name": "United States",
"Population": 331000000,
"Area": 9833520,
"GDP": 21.43
}
]
},
"Employees": [
{
"Id": 100000001,
"Name": "John Smith",
"Address": {
"Street": "456 Oak Avenue",
"City": "Chicago",
"State": "IL",
"ZipCode": "60601"
},
"Salary": 99500,
"Age": 45
},
{
"Id": 100000002,
"Name": "Alice Johnson",
"Address": {
"Street": "123 Maple Street",
"City": "New York",
"State": "NY",
"ZipCode": "10001"
},
"Salary": 105000,
"Age": 38
},
{
"Id": 100000003,
"Name": "Michael Brown",
"Address": {
"Street": "789 Pine Lane",
"City": "Los Angeles",
"State": "CA",
"ZipCode": "90001"
},
"Salary": 89000,
"Age": 50
},
{
"Id": 100000004,
"Name": "Emily Davis",
"Address": {
"Street": "321 Elm Drive",
"City": "Houston",
"State": "TX",
"ZipCode": "77001"
},
"Salary": 92000,
"Age": 42
}
]
},
{
"CompanyData": {
"Name": "Atlantic Transfers, Inc",
"CEO": "Black Beard",
"Address": {
"Street": "101 Elm Drive",
"City": "Dallas",
"State": "TX",
"ZipCode": "75201"
},
"CountryDetails": [
{
"Name": "United States",
"Population": 331000000,
"Area": 9833520,
"GDP": 21.43
}
]
},
"Employees": [
{
"Id": 100000008,
"Name": "Laura Lee",
"Address": {
"Street": "258 Willow Lane",
"City": "San Diego",
"State": "CA",
"ZipCode": "92101"
},
"Salary": 105500,
"Age": 32
},
{
"Id": 100000009,
"Name": "Andrew Harris",
"Address": {
"Street": "369 Spruce Drive",
"City": "Dallas",
"State": "TX",
"ZipCode": "75201"
},
"Salary": 88000,
"Age": 41
},
{
"Id": 100000010,
"Name": "Jessica Thompson",
"Address": {
"Street": "159 Cherry Lane",
"City": "Austin",
"State": "TX",
"ZipCode": "73301"
},
"Salary": 98700,
"Age": 37
},
{
"Id": 250150245,
"Name": "Jane Doe",
"Address": {
"Street": "Main St",
"City": "San Jose",
"State": "PA",
"ZipCode": "95101"
},
"Salary": 144186,
"Age": 63
},
{
"Id": 783328759,
"Name": "Robert Brown",
"Address": {
"Street": "Pine St",
"City": "Los Angeles",
"State": "CA",
"ZipCode": "90001"
},
"Salary": 122395,
"Age": 58
}
]
}
]
}
},
{
"TextIdentifier": "Example",
"CompiledParsedValue":
{
"FilteredCountryNames": [
"United States",
"Canada",
"Australia"
],
"FilteredCountryData": [
"Name:United States, Population:331000000",
"Name:Canada, Population:37590000",
"Name:Australia, Population:25690000"
],
"comments": "'FilteredCompanies' array used in JsonQL expressions below is in parent JSON FilteredCompanies.json",
"FilteredCompanyAddresses": {
"comments": "'FilteredCompanies' array is in parent JSON FilteredCompanies.json",
"addresses": [
]
},
"FilteredCompanyEmployees": [
{
"Id": 100000002,
"Name": "Alice Johnson",
"Address": {
"Street": "123 Maple Street",
"City": "New York",
"State": "NY",
"ZipCode": "10001"
},
"Salary": 105000,
"Age": 38
},
{
"Id": 100000003,
"Name": "Michael Brown",
"Address": {
"Street": "789 Pine Lane",
"City": "Los Angeles",
"State": "CA",
"ZipCode": "90001"
},
"Salary": 89000,
"Age": 50
},
{
"Id": 100000004,
"Name": "Emily Davis",
"Address": {
"Street": "321 Elm Drive",
"City": "Houston",
"State": "TX",
"ZipCode": "77001"
},
"Salary": 92000,
"Age": 42
},
{
"Id": 100000008,
"Name": "Laura Lee",
"Address": {
"Street": "258 Willow Lane",
"City": "San Diego",
"State": "CA",
"ZipCode": "92101"
},
"Salary": 105500,
"Age": 32
},
{
"Id": 100000009,
"Name": "Andrew Harris",
"Address": {
"Street": "369 Spruce Drive",
"City": "Dallas",
"State": "TX",
"ZipCode": "75201"
},
"Salary": 88000,
"Age": 41
},
{
"Id": 100000010,
"Name": "Jessica Thompson",
"Address": {
"Street": "159 Cherry Lane",
"City": "Austin",
"State": "TX",
"ZipCode": "73301"
},
"Salary": 98700,
"Age": 37
},
{
"Id": 250150245,
"Name": "Jane Doe",
"Address": {
"Street": "Main St",
"City": "San Jose",
"State": "PA",
"ZipCode": "95101"
},
"Salary": 144186,
"Age": 63
},
{
"Id": 783328759,
"Name": "Robert Brown",
"Address": {
"Street": "Pine St",
"City": "Los Angeles",
"State": "CA",
"ZipCode": "90001"
},
"Salary": 122395,
"Age": 58
}
],
"FilteredCompanyEmployeeAddresses": [
{
"Street": "456 Oak Avenue",
"City": "Chicago",
"State": "IL",
"ZipCode": "60601"
},
{
"Street": "123 Maple Street",
"City": "New York",
"State": "NY",
"ZipCode": "10001"
},
{
"Street": "789 Pine Lane",
"City": "Los Angeles",
"State": "CA",
"ZipCode": "90001"
},
{
"Street": "321 Elm Drive",
"City": "Houston",
"State": "TX",
"ZipCode": "77001"
},
{
"Street": "258 Willow Lane",
"City": "San Diego",
"State": "CA",
"ZipCode": "92101"
},
{
"Street": "369 Spruce Drive",
"City": "Dallas",
"State": "TX",
"ZipCode": "75201"
},
{
"Street": "159 Cherry Lane",
"City": "Austin",
"State": "TX",
"ZipCode": "73301"
},
{
"Street": "Main St",
"City": "San Jose",
"State": "PA",
"ZipCode": "95101"
},
{
"Street": "Pine St",
"City": "Los Angeles",
"State": "CA",
"ZipCode": "90001"
}
]
}
}
],
"CompilationErrors":
{
"$type": "System.Collections.Generic.List`1[[JsonQL.Compilation.ICompilationErrorItem, JsonQL]], System.Private.CoreLib",
"$values": []
}
}