get username from constituent system id

Ashley Gelderblom
Ashley Gelderblom
Tenth Anniversary Kudos 2 Name Dropper Participant
in Blackbaud Raiser's Edge NXT® APIs

is this possible, I want to use the username to send a notification in teams in a power automate flow where opportunities have been assigned to fundraisers

Comments

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

    @Ashley Gelderblom
    Unfortunately, this is not possible directly. Opportunity record is assigned to fundraiser, which from SKY API you can get the constituent_id of the constituent record of the fundraiser. Even though there is an API in the NXT Integration connector to get information about a user (including the info of user id), you need the user's system id. However, there is no API that will give you the “RE user record” that's link to the constituent record.

    As alternative, maybe you can add the staff's org email (b/c Teams message uses email of your staff in your org) into the constituent record as a specific email type, this will work.

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

    @Ashley Gelderblom
    The get info about a user API gives you 1 user at a time by the user system id, that's the problem right now. So if Blackbaud provide a new API that list all users in systems, the JSON given back from a user record has the constituent_id field, so that way you can filter to get to the user you want by constituent_id.

    This warrent a search in IdeaBank and see if it exist and vote up on, or make a new idea for Blackbaud.

  • Ashley Gelderblom
    Ashley Gelderblom
    Tenth Anniversary Kudos 2 Name Dropper Participant

    @Alex Wong Thanks Alex, yeah I had thought that. Also looked at maintaining a staff list in SP, so I could do a lookup on the system id and then return thier email. It might slow down the flow, just scoping now, thanks for the reply

Categories