How can I tell if a spouse is a constituent or not via SKY API?

Elizabeth Conn
Elizabeth Conn
Third Anniversary Facilitator 1
in Blackbaud Raiser's Edge NXT® APIs

I'm using the SKY API to access RE Constituent data, including relationships. I know that in the database view it is possible to add a spouse as a relationship without adding a constituent record. I can access that relationship data and record via the SKY API, but I can't tell if the relationship record is a constituent or not.

Is there a way to use the API to check if a relationship record is a constituent or not?

Comments

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

    @Elizabeth Conn
    threre are multiple indicator if a record is constituent or not.

    if you are using the get all relationships for a constituent api endpoint, there are properties: is_spouse_head_of_household and is_constituent_head_of_household. You can only have “head of household” indicator if both spouse is constituent record. Meaning, if you are looking at relationship of a constituent (John Smith), then you expect is_constituent_head_of_household to be true or is_spouse_head_of_household to be true if both spouse is constituent. if both these property is false, means the spouse is definitely not constituent.

    If you don't want to mess with the logic of this, one easy way is to use get constituent endpoint on the spouse relation_id property (the constituent system record id of the relationship). Every “record” (constituent or non-constituent) has a constituent system record id and can use get constituent endpoint on it. the returned data has a is_constituent indicator, true = constituent, false = nonconstituent.

Categories