datatables.net is a good modular javascript library that handles pagination and child tables and export to csv/excel. you will still need to write some code for formatting the api calls into a useable format.
I gave it a try, and got something really basic to work. It took me several hours (part of it was my fault, part of it was the documentation and its defaults that expect the data in a particular format, and the error messages that weren't very helpful).
It's a complex tool, and it does a lot, but not what I need.
I agree. I've already written 1,000s of lines of code for this. I was trying to a) see if the problem had already been solved, b) see if it was worthwhile for me to continue trying to solve it.
The MS Power Query / BI tools come really close, but not quite.
As I like to say, they do the first 80%, but it's that last 80% that you still need :)
I gave it a try, and got something really basic to work. It took me several hours (part of it was my fault, part of it was the documentation and its defaults that expect the data in a particular format, and the error messages that weren't very helpful).
It's a complex tool, and it does a lot, but not what I need.