Fetch Report using API's | Community
Skip to main content
Aman_Chandel
Level 1
November 8, 2019
Question

Fetch Report using API's

  • November 8, 2019
  • 2 replies
  • 4464 views

Currently I am getting some email reports from Marketo to my gmail Account, Is it possible to fetch these Reports directly from the API using PHP ?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

SanfordWhiteman
Level 10
November 8, 2019

No, there's no API to fetch rendered reports.

Amit_Jain
Community Advisor
Community Advisor
November 8, 2019

No, there is no API for reports but what you can do is to fetch the activity data in database and use that to create reports.

Since Marketo have 90 days and 25 month data retention policy, it makes sense to have a backup database to have historical activity data.

Aman_Chandel
Level 1
December 9, 2019

Hi Amit,

Is there anyway to fetch stats data, most of the report which we are generating have stats like email name, delivered, open, bounce and etc.

so is there anyway to fetch this detail, and create the report at our end?

Thanks a lot 

Aman 

Amit_Jain
Community Advisor
Community Advisor
December 9, 2019

You cannot extract the stats directly but you can use Marketo bulk API to extract the activity data. The best part is that you can filter the data by activity type.

Lean more here and feel free to ask if you have any question.

https://developers.marketo.com/rest-api/bulk-extract/bulk-activity-extract

After extracting the raw activity data, slice and dice the same to create reports and dashboard in your external systems.