JSONata Tutorial
Simple Mapping
Nested Object
Concatenation
Array Mapping
Simple Array Access
Array Mapping
Array Filtering
Calculation & Aggregation
Counts
Sums
Calculations
⭐
Composition
⭐
Advanced Composition
⭐
Advanced Composition 2
⭐
Conditionals
Simple Conditional
Advanced Conditional
⭐
Functions
Lookup
Numeric Functions
⭐
Counts
Calculation & Aggregation
← Previous
Next →
Counts
Task
Count the number of sub_line_items.
Your Expression
Reset
Your Result
No data
Input JSON
{
line_items:
[
{
product_id:
1
,
quantity:
1
,
sub_line_items:
[
{
product_id:
3
,
quantity:
1
}
]
}
,
{
product_id:
2
,
quantity:
1
,
sub_line_items:
[
{
product_id:
4
,
quantity:
1
}
,
{
product_id:
5
,
quantity:
1
}
]
}
]
}
Expected Output
{
count:
3
}