How to resolve “The JSON request was too large to be deserialized” server error in Excel filter?
While performing server-side filter actions in Excel filter by selecting the filter values using checkbox, there are chances of confronting the following exception:
Figure 1: Exception
To de-serialize the large number of JSON data, you need to add the MaxJsonDeserializerMembers value to web.config.
You can add the following line to the Web.Config file appSettings to resolve the json deserialization server error.
<appSettings> <add key="aspnet:MaxJsonDeserializerMembers" value="150000" /> </appSettings>
Figure 2: Result