Oh my. Vendor central is such a pita one can't help thinking they do it on purpose. (Also, I had to write several puppeteer based scripts for different reporting web apps that don't expose an API and vendor central was definetly the most painful to write)
And ads API, is just so bad. And data is only available for the last 3 months.