Is there a good way to make the same change to a really large group of records?
My use case is that I need to duplicate a couple fields from one table onto a different table. I’ve got about 34,000 records that already exist that need the data duplicated.
I tried “make changes to a list of things” but it kept silently erroring out. I tried “schedule API on a list of things” but it also silently errored out.
So I tried limiting the search to the first 500 items and now it looks like something is happening.
I had hoped that the limitations on how long “lists” can be wouldn’t affect this since it should just be the results of a search, not stored as a list, but it looks like the process isn’t working on that many search results.
So do I have to break up the batch edit into small enough groups (500? 1000?) items and just keep running it until it eventually fixes all 34,000 records? @emmanuel