Grid is empty with filtered data

Answered
jhshin asked on November 4, 2025

Hello I want to ask a question related to CustomApi.

Our flexmonster works with Custom Api.

With value filter, the grid is empty even when the response is not empty . (not always)

I guess the difference with normal case is whether response contains Grand Total and sub total . 

(Because Grand total and subtotal values are filtered!)

Can you tell me the specific reason?

 

without filter

w

 

with filter

request body 

 

response body

 

Grid is empty

2 answers

Public
Maksym Diachenko Maksym Diachenko Flexmonster November 5, 2025

Hello,

Thank you for contacting us.

You are right - the issue is indeed related to totals and grand totals not being returned. When Flexmonster loads the data, it uses the totals for rows and columns from the response to determine whether a row or column is empty. If those totals are missing, Flexmonster assumes that the entire row or column contains no valid data and hides it. So, it is necessary to include totals in the response to ensure that results appear on the grid.

Please let us know if our response was helpful to you.

Best regards,
Maksym

Public
Maksym Diachenko Maksym Diachenko Flexmonster 4 days ago

Hello,

Hope you are doing well.
We are wondering if you have tried adjusting the custom API logic to return totals.
Please let us know if this has solved the issue with the empty grid.

Best regards,
Maksym

Please sign in or register to submit your answer