Migration API Mutation Error: Request Body Exceeds Limit of 4000000 Bytes

We are migrating all of our data from the old CMS to Sanity via API mutations, and some of the resources are throwing errors “Request body exceeds limit of 4000000 bytes”. Most of those are portable text. Any workaround suggestions?

Ooooh, tricky. 😅

I wonder if dedicated support could help you bypass them maybe?

You could try doing it in multiple smaller passes, but this could be tricky depending on what your schema looks like.

Can block content / portable text even be broken down?

I already reduced the batch sizes to 1 entry per request, so I am not sure how I would go about it. I guess patching the partable text array would be an option, but it’s a super complex migration logic, which iterates through a gazillion nodes, migrates assets et al.

With transactions, I am not sure how to safely split the transaction to ensure that item references do not throw errors.

Maybe json-ld import is better for this? 4mb is a lot though

What’s a json-ld import?

I have a ton of markdown that needs to be transformed into portable text, not sure what json-ld has to do with it

Looks like there are some long raw svgs, will try to optimize that part

Ok. It’s me stupid. There was no clean up happening after the page was imported, so it kept adding transactions to a stack for each new page, until it reached the limit, which now that I think about it is huge. False alarm.