-
Re: Reporting / results through the API
Sanford Whiteman Dec 7, 2016 2:30 PM (in response to 83190a577e6a4d0c2976f96394a1831f73b5f7aa)2 of 2 people found this helpfulPlease 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.
-
Re: Reporting / results through the API
83190a577e6a4d0c2976f96394a1831f73b5f7aa Dec 19, 2016 12:00 PM (in response to Sanford Whiteman)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 :-)
-