How to add Fundraiser Name from the Connector

Chris Zello

I'm working with a flow that emails a digest showing everyone with a birthdate this month.

I'd like to add the Fundraiser to the output that is emailed, and believe I simply need to add a Connector to get the name of the fundraiser. How do I do this?

I don't see the Name field I'm seeking with only the Connections for Blackbaud Raisers Edge NXT and Outlook. I believe it would be in the Fundraiser connection/endpoint, although I'm not seeing an option for Name there.

Thanks.

Alex Wong

@Chris Zello
there is a get fundraiser assignment action, which returns an array of fundraiser (only gives you fundraiser's system record id) for a constituent. You will then need to use the fundraiser system record id and call get a constituent endpoint to get the fundraiser's name.

However, one constituent can have more than one fundraiser, so you will need to determine if (1) org-wide policy only have one fundraiser per constituent, then you can use “first()" expression without using loop or (2) you are going to use a for each loop to loop through each fundraiser.

below is the “steps” for option (2).

1. initialize an array variable for constituent
2. initialize an array variable for fundraiser name
3. list constituent
4. apply to each constituent
   1. list constituent fundraisers
   2. apply to each fundraiser
      1. get a constituent on the fundraiser system id
      2. append name from get a constituent action to array variable for fundraiser name
   3. append to array variable for constituent info you want from the constituent, and use expression to join the potentially multiple fundraiser separated by a semi-colon
      join(variables('fundraiser name'), ‘; ’)
   4. reset varaible fundraiser name by setting it to empty array []
5. create html table
6. send email