5 Replies Latest reply on Jul 18, 2017 8:25 PM by Kurt Koller

    Script for extracting all Lead Activities via Rest API?

    Carrie Flexmore

      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?