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

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
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