Character Limits for Unique Fields in API

Troubleshooting: Index Size Limit Exceeded Error

Symptoms

• Receiving a 400 error when updating sheets

• Error message indicating index row size exceeds btree version 4 maximum 2704

Possible Causes

• Unique constraint on a field containing very large values

• Data size exceeding the database's index size limitations

Solutions

Solution 1: Remove Unique Constraint

Remove the Unique constraint from the breaking field in your sheet configuration. While this is the simplest solution, it may not be suitable if maintaining uniqueness is a requirement for your use case.

Solution 2: Implement a Record Hook

If you need to maintain uniqueness, implement a recordHook that verifies uniqueness programmatically instead of relying on database constraints. This allows you to maintain data integrity while avoiding the database index size limitations.

When to Contact Support

If the above solutions do not resolve the issue, please contact our support team with the following information:

• The complete error message

• Sample payload that triggered the error

• Your sheet configuration including any constraints