Get Free Trial

How can I achieve Table Grouping with Custom API Data Source?

Rodrigo Arantes asked on March 24, 2021

I managed to enable the grouping functionality through grouping=true option (see screenshot)

options: {
grouping: true

But upon sending a request against /select, it sends a JSON structure that doesn’t seem to help.

"type": "select",
"query": {
"aggs": {
"by": {
"rows": [
"uniqueName": "My Field.groups"
"values": [
"func": "sum",
"field": {
"uniqueName": "another_field"
"page": 0,

How can this be achieved with Custom API Data Source?


1 answer

Vera Didenko Vera Didenko Flexmonster March 25, 2021

Hello, Rodrigo,
Thank you for reaching out to us. 
We would like to kindly explain that the grouping option is currently available only for CSV/JSON data source types.
However, it is possible to group several fields into multilevel hierarchies (see example). You are welcome to check out the following guide for more details on how to implement multilevel hierarchies for the custom data source API.
We hope this helps. Please feel free to reach out in case of questions.
Kind regards,

Please login or Register to Submit Answer