Associations Test
CRM/Associations?constituentId={constituentId}&associatedConstituentId={associatedConstituentId}&startActiveDate={startActiveDate}&endActiveDate={endActiveDate}
Get details of all the association of the specified constituent id or get all the associations of the specified associated constituent id. If both constituent id and associated constituent id are specified get all the associations between them. To filter the associations that are active within certain date then pass values for start date and end date.
Http Verb GET
Resource URL https://ts-stg-appgw.calacademy.org/TessituraService/CRM/Associations?constituentId={constituentId}&associatedConstituentId={associatedConstituentId}&startActiveDate={startActiveDate}&endActiveDate={endActiveDate}

URI Parameters

Parameter Name Data Type Required Notes
constituentId integer Y Limit results by constituent.
associatedConstituentId integer N
startActiveDate date N
endActiveDate date N

Request Body

None.
No request body.

Response object type : Collection of Association

Response object type Collection of Association has the following properties.
Property Name Data Type Length Required Readonly Notes
AssociatedConstituent Entity
AssociatedName string N
AssociationType AssociationTypeSummary N
BirthDate date N
Constituent Entity
CreatedBy string N
CreatedDateTime date N
CreateLocation string N
EditIndicator boolean
EndDate date N
Gender GenderSummary N
Id integer N
Inactive boolean N
IsIncludedInSearchResults boolean N
Note string N
ReciprocalAssociation Entity N
FK: T_ASSOCIATION.association_no   Resource: Associations
StartDate date N
UpdatedBy string N
UpdatedDateTime date N 
[
  {
    "AssociatedConstituent": {
      "Id": 1
    },
    "AssociatedName": "sample string 1",
    "Id": 1,
    "AssociationType": {
      "Description": "sample string 1",
      "Id": 1,
      "Inactive": true,
      "ReciprocalType": {
        "Id": 1
      },
      "RelationshipCategory": {
        "Description": "sample string 1",
        "Id": 1,
        "Inactive": true
      }
    },
    "CreatedDateTime": "2025-04-24T09:39:10.6371951-07:00",
    "CreateLocation": "sample string 2",
    "CreatedBy": "sample string 3",
    "Constituent": {
      "Id": 1
    },
    "EndDate": "2025-04-24T09:39:10.6371951-07:00",
    "Inactive": true,
    "IsIncludedInSearchResults": true,
    "UpdatedBy": "sample string 4",
    "UpdatedDateTime": "2025-04-24T09:39:10.6371951-07:00",
    "Note": "sample string 5",
    "BirthDate": "2025-04-24T09:39:10.6371951-07:00",
    "Gender": {
      "Id": 1,
      "Description": "sample string 1",
      "ShortDescription": "sample string 2",
      "Inactive": true
    },
    "ReciprocalAssociation": {
      "Id": 1
    },
    "StartDate": "2025-04-24T09:39:10.6371951-07:00",
    "EditIndicator": true
  },
  {
    "AssociatedConstituent": {
      "Id": 1
    },
    "AssociatedName": "sample string 1",
    "Id": 1,
    "AssociationType": {
      "Description": "sample string 1",
      "Id": 1,
      "Inactive": true,
      "ReciprocalType": {
        "Id": 1
      },
      "RelationshipCategory": {
        "Description": "sample string 1",
        "Id": 1,
        "Inactive": true
      }
    },
    "CreatedDateTime": "2025-04-24T09:39:10.6371951-07:00",
    "CreateLocation": "sample string 2",
    "CreatedBy": "sample string 3",
    "Constituent": {
      "Id": 1
    },
    "EndDate": "2025-04-24T09:39:10.6371951-07:00",
    "Inactive": true,
    "IsIncludedInSearchResults": true,
    "UpdatedBy": "sample string 4",
    "UpdatedDateTime": "2025-04-24T09:39:10.6371951-07:00",
    "Note": "sample string 5",
    "BirthDate": "2025-04-24T09:39:10.6371951-07:00",
    "Gender": {
      "Id": 1,
      "Description": "sample string 1",
      "ShortDescription": "sample string 2",
      "Inactive": true
    },
    "ReciprocalAssociation": {
      "Id": 1
    },
    "StartDate": "2025-04-24T09:39:10.6371951-07:00",
    "EditIndicator": true
  }
]
<Associations xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
  <Association>
    <AssociatedConstituent>
      <Id>1</Id>
    </AssociatedConstituent>
    <AssociatedName>sample string 1</AssociatedName>
    <AssociationType>
      <Description>sample string 1</Description>
      <Id>1</Id>
      <Inactive>true</Inactive>
      <ReciprocalType>
        <Id>1</Id>
      </ReciprocalType>
      <RelationshipCategory>
        <Description>sample string 1</Description>
        <Id>1</Id>
        <Inactive>true</Inactive>
      </RelationshipCategory>
    </AssociationType>
    <BirthDate>2025-04-24T09:39:10.6371951-07:00</BirthDate>
    <Constituent>
      <Id>1</Id>
    </Constituent>
    <CreateLocation>sample string 2</CreateLocation>
    <CreatedBy>sample string 3</CreatedBy>
    <CreatedDateTime>2025-04-24T09:39:10.6371951-07:00</CreatedDateTime>
    <EditIndicator>true</EditIndicator>
    <EndDate>2025-04-24T09:39:10.6371951-07:00</EndDate>
    <Gender>
      <Description>sample string 1</Description>
      <Id>1</Id>
      <Inactive>true</Inactive>
      <ShortDescription>sample string 2</ShortDescription>
    </Gender>
    <Id>1</Id>
    <Inactive>true</Inactive>
    <IsIncludedInSearchResults>true</IsIncludedInSearchResults>
    <Note>sample string 5</Note>
    <ReciprocalAssociation>
      <Id>1</Id>
    </ReciprocalAssociation>
    <StartDate>2025-04-24T09:39:10.6371951-07:00</StartDate>
    <UpdatedBy>sample string 4</UpdatedBy>
    <UpdatedDateTime>2025-04-24T09:39:10.6371951-07:00</UpdatedDateTime>
  </Association>
  <Association>
    <AssociatedConstituent>
      <Id>1</Id>
    </AssociatedConstituent>
    <AssociatedName>sample string 1</AssociatedName>
    <AssociationType>
      <Description>sample string 1</Description>
      <Id>1</Id>
      <Inactive>true</Inactive>
      <ReciprocalType>
        <Id>1</Id>
      </ReciprocalType>
      <RelationshipCategory>
        <Description>sample string 1</Description>
        <Id>1</Id>
        <Inactive>true</Inactive>
      </RelationshipCategory>
    </AssociationType>
    <BirthDate>2025-04-24T09:39:10.6371951-07:00</BirthDate>
    <Constituent>
      <Id>1</Id>
    </Constituent>
    <CreateLocation>sample string 2</CreateLocation>
    <CreatedBy>sample string 3</CreatedBy>
    <CreatedDateTime>2025-04-24T09:39:10.6371951-07:00</CreatedDateTime>
    <EditIndicator>true</EditIndicator>
    <EndDate>2025-04-24T09:39:10.6371951-07:00</EndDate>
    <Gender>
      <Description>sample string 1</Description>
      <Id>1</Id>
      <Inactive>true</Inactive>
      <ShortDescription>sample string 2</ShortDescription>
    </Gender>
    <Id>1</Id>
    <Inactive>true</Inactive>
    <IsIncludedInSearchResults>true</IsIncludedInSearchResults>
    <Note>sample string 5</Note>
    <ReciprocalAssociation>
      <Id>1</Id>
    </ReciprocalAssociation>
    <StartDate>2025-04-24T09:39:10.6371951-07:00</StartDate>
    <UpdatedBy>sample string 4</UpdatedBy>
    <UpdatedDateTime>2025-04-24T09:39:10.6371951-07:00</UpdatedDateTime>
  </Association>
</Associations>
Change Version Description Contract Old New
Property Changed 15.1.0 Gender has changed from String to GenderSummary Association String GenderSummary
Parameter Changed 15.0.0 constituentId has been marked as required. Required