Relationship Address in Power Automate for Raiser's Edge NXT

Catherine Colvin

We are using Power Automate with Raiser's Edge NXT to create acknowledgement letters. Is it possible to pull the address associated with a relationship?

I have no problem getting an organization's contacts using the "List constituent relationships" action, and then using the "List constituent addresses" action, but neither of these return what I need. The only addresses I'm able to pull are the ones listed under a record's Contact Info in the web view (instead of the address specified under Relationships).

Thank you!

Alex Wong

@Catherine Colvin
I have no problem getting the contact person's address. question did you call the right info.

Steps:

1. call list constituent relationships API on the org record
2. from the returned information, filter on is_organization_contact=true, which “CAN” give you more than 1 record that is a contact
3. call the “get a constituent” API on the relation_id, it is not the “id” nor the “constituent_id” property

this will work regardless of if your contact record is a constituent or non-constituent record.

Catherine Colvin

@Alex Wong
Thanks for your reply! This returned the contact's preferred address (which we do use for some of our letters), but I wasn't able to find the address specific to the relationship.

Our organization updates and relies on the address listed within the relationship for most of our letters, instead of referencing the preferred/home/business addresses associated with the individual's record. So far I've only been able to see this relationship address in RE's web view.

I've also tried these IDs (referencing both the organization and the contact) with the "List constituent addresses", but I don't see the relationship address as an output.

Any thoughts? Thanks in advance!

Alex Wong

@Catherine Colvin
SKY API does not have endpoint for relationship's specific address

So the only option that “may” work is to use the Query API, but it is not fully accessible to all client yet.

Catherine Colvin

@Alex Wong
Okay, I'll see if we have access to Query API - thanks again for taking the time to help, I appreciate it!