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

      https://xxx-xxx-xxx.mktorest.com/identity/oauth/token?grant_type=client_credentials

       

      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?