Add 'GET Constituent attachment list (All constituents)'

How difficult would it be to get the attachment list for all constituents at once (5000 records per one API call?). We are currently working on a workflow that requires knowing if the constituent record has attachments or not, and that would require a nightly refresh. Our database has hundreds of thousands constituent records, and pulling attachment lists one at a time would not be an ideal solution.

Comments

  • Dmitry Khomyakov

    It is little bit difficult loop through next URL. Initial URL looks like below initial URL. You have loop through Next URL from the result set.

    I am using C# in SSIS script task.

    Initial URL

    string url = Dts.Variables["$Package::ServerURL"].Value.ToString() + "/constituent/v1/constituents?limit=4999&offset=0"

    Next URL:

    string url_1 = Dts.Variables["$Package::ServerURL"].Value.ToString() + "/constituent/v1/constituents?limit=4999&offset=4999"