How to find Relationship Id / Parent Record

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.

547e8f7462baf9326bb8c937ed468b67-huge-im

Comments

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

    @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…

  • @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
    Alex Wong Community All-Star
    Tenth Anniversary Kudos 5 Facilitator 4 bbcon 2025 Attendee Badge

    @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”)

Categories