How to resolve “The JSON request was too large to be deserialized” server error in Excel filter?

1 min read

Problem

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

Solution

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>

Output

Figure 2: Result

Did you find this information helpful?

Yes

Comments (0)

How to resolve “The JSON request was too large to be deserialized” server error in Excel filter?

Access denied