Add 'GET Constituent attachment list (All constituents)'

Dmitry Khomyakov
Dmitry Khomyakov
Fourth Anniversary Kudos 1 Facilitator 1
in Blackbaud Raiser's Edge NXT® APIs

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

  • Sivaiah Koppaka
    Sivaiah Koppaka
    Third Anniversary Name Dropper Facilitator 1

    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"


Categories