Hi,
We have bumped into the same issue as you had before while we are trying to extract Marketo data to SQL server database to build some analytic reports, but it turned out to be hared to achieve with Marketo standard API.
Finally, we developed our solution, and you can see my reply in the middle of this post: Replicate Marketo Database
Best Regards,
Vivian