asked on March 12, 2026
Hi,
We have the Custom Data Source API running on the backend, and we are supplying records to the UI through the Custom Data Source API.
I can see the data in the response payload for the select endpoint (Pivot table). However, I noticed that when the column slice is set to a field, the UI cuts off all rows and displays only the grand total.
Could you please help investigate why the row-level data is not being rendered in this scenario?
Thanks.
Slice:
{"reportFilters":[{"uniqueName":"randomName"}],"rows":[{"uniqueName":"Name"}],"columns":[{"uniqueName":"[Measures]"}, {"uniqueName":"invoiceDate.Year"}],"measures":[{"uniqueName":"avgCall","aggregation":"sum","format":"-15oji0lj8lum00"}]}
"fields": [],
"aggs": [
{
"values": {
"avgCall": {
"sum": 33
}
},
"keys": {}
},
"values": {
"avgCall": {
"sum": 120284.71
}
},
"keys": {
"Name": "Flexmonster test",
"invoiceDate.Year": 2026
}
},
{
"values": {
"avgCall": {
"sum": 104.7
}
},
"keys": {
"Name": "A\u0026A Test 222",
"invoiceDate.Year": 2026
}
},
⋅ March 13, 2026
Hello,
Thank you for your message.
We recreated a report with a similar slice on our side using our custom API server, and the grid renders correctly. You can check our example here: https://jsfiddle.net/flexmonster/v6qpney7/
From our experience, rows may not be rendered if the row totals are missing in the response. Please inspect your server’s response and check whether it contains similar objects:
{
"values": {
"avgCall": {
"sum": 100000
}
},
"keys": {
"Name": "Name1"
}
}
This object includes information about the total value of the row with member "Name1". If such records are missing, the corresponding rows will not be rendered.
This happens because Flexmonster relies on totals to evaluate whether a row exists. If the total for a row is not included in the response, Flexmonster treats that row as empty and does not render it on the grid.
If the suggestion with the empty totals does not work for you, could you please provide more information to help us further research the matter? This includes the entire Flexmonster report and full server responses when the issue occurs (/fields, /members and /select requests).
We are looking forward to hearing from you.
Best regards,
Maksym
⋅ March 25, 2026
Hello,
Hope you are doing well.
We are wondering if you reviewed our recommendations regarding the issue with displaying rows with the custom API.
Please let us know if the issue is resolved or if any further assistance is needed.
Best regards,
Maksym
⋅ April 23, 2026
Hello,
Just checking in to ask if you were able to resolve the issue with the rows not being rendered with the custom API.
We are looking forward to hearing your feedback.
Best regards,
Maksym
