How to import all emails and activities?

[iritg1]

Using PyPardot version 4 to pull emails and activities (click, open, send ect.) Looking for an example of pulling all emails and their activities.

[mneedham91]

Hi @iritg1 there is no API route to get all sent list emails. What I would recommend is to export your sent emails as a csv file, then read that in and query individual emails based on their Id.

[iritg1]

Thank you. Is there a way to pull the csv file using automated process?

[mneedham91]

None that I am aware of, unfortunately.

[iritg1]

Is there any difference between visitor activities when applying the 'email_only' filter to email activities?

[creuzerm]

We should be able to get all the emails sent by doing a Visitor Activity of type 6 - sent, 1 - click, 2 view. http://developer.pardot.com/kb/object-field-references/#visitor-activity (scroll down a bit for the secret decoder ring)

We have a brand new Visitor Activity Bulk Export method in the API http://developer.pardot.com/kb/api-version-4/export/ which I am working on writing a method for in this library (unless somebody beats me to it)