AnsweredAssumed Answered

Script for extracting all Lead Activities via Rest API?

Question asked by 488475c4c1ff476f6892d3874c04cbd627f0b611 on Nov 20, 2016
Latest reply on Nov 25, 2016 by sanford.whiteman

Looking for some help in getting a script that will extract all out Lead Activities. I've been successful in manually retrieving the data as a test, however our Lead Database has 120k customers. I'm trying to get Send Email, Open Email, Click Email plus more for at least 8 different sends, this could easily be 1.2M+ rows in total data. Obviously this is not feasible to do manually given the 300 record limit per API call. I'm also aware of the 10k API calls a day limit.

 

At the moment, I'm doing:

https://<endpoint>.mktorest.com/rest/v1/activities.json?access_token=<access_token>&nextPageToken=<nextPageToken&activityTypeIds=<activityTypeIds>

 

I'm not a developer but do have basic to intermediate programming skills. Is there any sort of script out there (no script language preference) that I can modify and use for my purposes to extract all the Lead Activities?

Outcomes