How to find Relationship Id / Parent Record

Bob Rowe

If I do a constituent search and see the “is_constituent” = false, then I know the “record_id” returned is a contact for an organization.

Which API call does a reverse lookup to see the relationship of the record_id given that is the only information that I have?

I have looked thru documentation and don't see it.

Alex Wong

@Bob Rowe
contact of an org is not the only type of non-constituent record. All relationship (spouse, children, etc) can be non-constituent record. At the minimal, there is event participant guest that can also be non-constituent record as well.

There is no reverse lookup, the only way you can work your way back is to call the API to get all constituent relationship records:

Then filter the result for the relation_id field that is the non-constituent id and you will find the “parent” constituent record's id in the constituent_id field.

For event participant guest record that is non-constituent record, you will have a much harder (if not impossible to do using SKY API). Not going to go into the details here…

Bob Rowe

@Alex Wong

Thanks Alex! I think I can make it work.

The entity relationships here could have been better designed to help out with some of these use cases. ?

Alex Wong

@Bob Rowe
Agree! I think the API should have more support for non-constituent record as well. But for now that's what we got (you can use Idea Bank, as they always tell you, but I think this may just get the “cold seat”)