2 of 2 people found this helpful
Please move the thread to Products. "Community" in this case refers to the Marketo Nation website itself. Support questions go in the Products space (and yes, this is confusing!).
Anyway, this is more complex than you're hoping. The Marketo API does not easily (or, really, at all) allow for replication of in-built reporting via a single endpoint. The API gives access to raw data via numerous virtual tables (basically re-relationalizing an object model that's already on top of relational data). But it's going to be on you to pull all of the tables together.
In brief, what you probably want is to pair the Lead >> Activities endpoint with results from Lead >> Leads.
Thanks Sanford, I really appreciate the feedback. I'm going to take a shot at automating an import of the emailed report since it has everything I need, and will be (possibly) less prone to complexity issues with merging data. Even though we prefer APIs, this was all ending up in a sql database for reporting, so in some senses importing the csv will more native.
+1 if Marketo wants to shoot a beta API link my way :-)