3 Replies Latest reply on Aug 3, 2017 10:46 PM by Sanford Whiteman

    REST API to get multiple lead by list id

      I am trying to get multiple leads by list id through Excel VBA.


      Get access token by running



      and run

      https://xxx-xxx-xxx.mktorest.com/rest/v1/list/{{listId}}/leads.json?access_token={{access token retrieved from previous step}}&nextPageToken={{next_page_token}}


      and re-run above until next_page_token is empty.


      When tested in a list of about 500 leads, it retrieves all data from a list.

      But when tested in a list containing about 13000 leads, it does not retrieve full list, always about 30 to 40 less.


      Anyone had similar experience?