How do I handle API data that exceeds the per-cell data limit?

Handling API Data That Exceeds Per-Cell Limits

When an API response returns data that exceeds Clay's per-cell data limit, it's typically due to large arrays or lengthy text strings.

Solution: Reduce Payload Size Before Mapping

Limit or chunk the response before sending it to another table:

• Map only specific fields — Instead of passing the full response body, select only the fields you actually need
• Slice arrays — Reduce array responses by taking only the first N items, or loop through items and send them as separate rows
• Extract or summarize text — For long text responses, extract or summarize the relevant portion before passing it forward

Once the payload is smaller, sending data to another table should process without errors.