Is there a JSON function so that we can get a count for certain field and group them by distinct values. So the JSON result have the following response:
{
name: John,
name: Kevin,
name: John,
name: Sara,
name: John
}
The output should be -
John(3), Kevin,(1),Sara(1)
Is there a JSON function that we can get a count for certain field/group them by distinct values.
+4
+1
Hey
@krunalm
The only way I can think of is using TemplateEngine to iterate the json results and format it to your desired format:
View files in slack
+1
And here's the json I used and jinja template:
Json:
{
"results": [
{"name": "John"},
{"name": "Kevin"},
{"name": "John"},
{"name": "Sara"},
{"name": "John"},
{"name": "Kevin"}
]
}
Jinja Template:
{% set names = [] %}
{% for item in input_json.results if item.name not in names %}
{% do names.append(item.name) %}
{% endfor %}
{% for name in names %}
{{ name }} ({{ input_json.results | selectattr("name", "equalto", name) | list | count }}){% if (loop.index) != names|length -%},{% endif -%}
{%- endfor -%}
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.