How to get Fundraiser "date last changed" via Sky Api?

Carlos Pelay
Carlos Pelay
Third Anniversary Name Dropper Kudos 1 Facilitator 1
in SKY Developer General Discussions

Hi - I'm trying to pull in the "Date Last Changed" for fundraiser assignments via PowerAutomate but am having no luck finding where that parameter is exposed in the API.

I've looked at Constituents "Fundraiser Assignment List (single constituent)" but only the start/end dates of the assignment are included in the response - not the actual modifed date of the assignment record.

I know the field exists in NXT (screenshot from NXT query) below - maybe it's just not available via the API?

Thanks in advance for your help.

image.png
Tagged:

Answers

  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Facilitator 5 Kudos 5 bbcon 2025 Attendee Badge

    A fundraiser assignment is also a "relationship" (special type of relationship).

    So you should be able to get the date added and date last changed from the get relationship endpoint

  • Carlos Pelay
    Carlos Pelay
    Third Anniversary Name Dropper Kudos 1 Facilitator 1

    Hi @Alex Wong that's what we assumed as well, but testing via the console is showing that only family, friend, employer, etc. type relationships are returned through that "get relationship" endpoint - we're not getting any fundraiser relationships unfortunately.

    We do see fundraisers using the fundraiser list endpoint but - as mentioned above - modified date is not included in the response.

    Appreciate if you have any other ideas. Thanks :)

  • Erik Leaver
    Erik Leaver Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    @Carlos Pelay The list of available relationships is linked via the get relationship endpoint. I don't see fundraisers there.

    Could you use the Fundraiser Assignment list under the Fundraising API? There are Fundraiser start & end dates.

  • Carlos Pelay
    Carlos Pelay
    Third Anniversary Name Dropper Kudos 1 Facilitator 1

    Hi @Erik Leaver , I really need the modified date unfortunately because I need to capture any edits to that fundraiser relationship record. Thanks!

  • Erik Leaver
    Erik Leaver Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    @Carlos Pelay This may be a gap & should be entered into the idea bank. I took a look at Query to see if we could get it that way. I didn't have any luck but might be worth another look.

  • Carlos Pelay
    Carlos Pelay
    Third Anniversary Name Dropper Kudos 1 Facilitator 1

    Thanks Erik - yes I think I can get it via the Query API instead since modified date shows up there:

    image.png

Categories