@michaelgantt thanks for the invite to your account to troubleshoot. The only other thing I needed to add was the “Override HTTP status code for last page”. Normally, an api would return a 404 for the last page, but in this case the api always returns a 200. So having the combination of that with the other fields seems to do the trick.
To troubleshoot, I just enabled debug logs on the export, changed some configurations, clicked preview, check logs for what calls were made, changed some configurations, and then found the combination that did the trick.