Affiliations Test
CRM/Affiliations?individualConstituentId={individualConstituentId}&groupConstituentId={groupConstituentId}&startActiveDate={startActiveDate}&endActiveDate={endActiveDate}&primaryOnly={primaryOnly}&showWithGroup={showWithGroup}
Get details of all the affiliation of the specified individual constituent id or get all the affiliations of the specified group constituent id. If both individual constituent id and group constituent id are specified get all the affiliations between them. To filter the affiliations that are active within certain date then pass values for start date and end date.To fetch primary affiliations alone pass primaryOnly=true. To limit the associations returned to those that are primary or that are marked as showWithGroup, pass showWithGroup=true.
Http Verb GET
Resource URL https://ts-stg-appgw.calacademy.org/TessituraService/CRM/Affiliations?individualConstituentId={individualConstituentId}&groupConstituentId={groupConstituentId}&startActiveDate={startActiveDate}&endActiveDate={endActiveDate}&primaryOnly={primaryOnly}&showWithGroup={showWithGroup}

URI Parameters

Parameter Name Data Type Required Notes
individualConstituentId integer N
groupConstituentId integer N
startActiveDate date N
endActiveDate date N
primaryOnly boolean N
showWithGroup boolean N

Request Body

None.
No request body.

Response object type : Collection of Affiliation

Response object type Collection of Affiliation has the following properties.
Property Name Data Type Length Required Readonly Notes
AddressId integer N
FK: T_ADDRESS.address_no   Resource: Addresses
AffiliatedName string N
AffiliationType AffiliationTypeSummary N
FK: TR_AFFILIATION_TYPE.id   Resource: AffiliationTypes
CreatedBy string N
CreatedDateTime date N
CreateLocation string N
EditIndicator boolean
ElectronicAddressId integer N
FK: T_EADDRESS.eaddress_no   Resource: ElectronicAddresses
EndDate date N
FK: T_CUSTOMER.customer_no   Resource: Constituents
GroupConstituent Entity
GroupConstituentName string N
GroupConstituentSortName string N
Id integer N
Inactive boolean N
FK: T_CUSTOMER.customer_no   Resource: Constituents
IndividualConstituent Entity
IndividualConstituentName string N
IndividualConstituentSortName string N
IsAllowedToTransact (DEPRECATED) boolean N Obsolete:
IsIncludedInSearchResults boolean N
NameIndicator integer N
Note string N
PrimaryIndicator boolean N
Salary decimal number N
SalutationId integer N
FK: TX_CUST_SAL.salutation_no   Resource: Salutations
StartDate date N
Title string N
UpdatedBy string N
UpdatedDateTime date N 
[
  {
    "Id": 1,
    "AffiliationType": {
      "Description": "sample string 1",
      "Id": 1,
      "Inactive": true,
      "UseSalary": true,
      "UseTitle": true,
      "IsIncludedInSearchResultsDefault": true,
      "RelationshipCategory": {
        "Description": "sample string 1",
        "Id": 1,
        "Inactive": true
      }
    },
    "AffiliatedName": "sample string 1",
    "CreatedDateTime": "2025-04-24T05:25:25.3740926-07:00",
    "CreatedBy": "sample string 2",
    "EndDate": "2025-04-24T05:25:25.3740926-07:00",
    "GroupConstituent": {
      "Id": 1
    },
    "Inactive": true,
    "IndividualConstituent": {
      "Id": 1
    },
    "IsAllowedToTransact": true,
    "IsIncludedInSearchResults": true,
    "UpdatedBy": "sample string 3",
    "UpdatedDateTime": "2025-04-24T05:25:25.3740926-07:00",
    "CreateLocation": "sample string 4",
    "Note": "sample string 5",
    "IndividualConstituentName": "sample string 6",
    "GroupConstituentName": "sample string 7",
    "IndividualConstituentSortName": "sample string 8",
    "GroupConstituentSortName": "sample string 9",
    "Salary": 1.0,
    "StartDate": "2025-04-24T05:25:25.3740926-07:00",
    "Title": "sample string 10",
    "PrimaryIndicator": true,
    "EditIndicator": true,
    "NameIndicator": 1,
    "AddressId": 1,
    "ElectronicAddressId": 1,
    "SalutationId": 1
  },
  {
    "Id": 1,
    "AffiliationType": {
      "Description": "sample string 1",
      "Id": 1,
      "Inactive": true,
      "UseSalary": true,
      "UseTitle": true,
      "IsIncludedInSearchResultsDefault": true,
      "RelationshipCategory": {
        "Description": "sample string 1",
        "Id": 1,
        "Inactive": true
      }
    },
    "AffiliatedName": "sample string 1",
    "CreatedDateTime": "2025-04-24T05:25:25.3740926-07:00",
    "CreatedBy": "sample string 2",
    "EndDate": "2025-04-24T05:25:25.3740926-07:00",
    "GroupConstituent": {
      "Id": 1
    },
    "Inactive": true,
    "IndividualConstituent": {
      "Id": 1
    },
    "IsAllowedToTransact": true,
    "IsIncludedInSearchResults": true,
    "UpdatedBy": "sample string 3",
    "UpdatedDateTime": "2025-04-24T05:25:25.3740926-07:00",
    "CreateLocation": "sample string 4",
    "Note": "sample string 5",
    "IndividualConstituentName": "sample string 6",
    "GroupConstituentName": "sample string 7",
    "IndividualConstituentSortName": "sample string 8",
    "GroupConstituentSortName": "sample string 9",
    "Salary": 1.0,
    "StartDate": "2025-04-24T05:25:25.3740926-07:00",
    "Title": "sample string 10",
    "PrimaryIndicator": true,
    "EditIndicator": true,
    "NameIndicator": 1,
    "AddressId": 1,
    "ElectronicAddressId": 1,
    "SalutationId": 1
  }
]
<Affiliations xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
  <Affiliation>
    <AddressId>1</AddressId>
    <AffiliatedName>sample string 1</AffiliatedName>
    <AffiliationType>
      <Description>sample string 1</Description>
      <Id>1</Id>
      <Inactive>true</Inactive>
      <IsIncludedInSearchResultsDefault>true</IsIncludedInSearchResultsDefault>
      <RelationshipCategory>
        <Description>sample string 1</Description>
        <Id>1</Id>
        <Inactive>true</Inactive>
      </RelationshipCategory>
      <UseSalary>true</UseSalary>
      <UseTitle>true</UseTitle>
    </AffiliationType>
    <CreateLocation>sample string 4</CreateLocation>
    <CreatedBy>sample string 2</CreatedBy>
    <CreatedDateTime>2025-04-24T05:25:25.3740926-07:00</CreatedDateTime>
    <EditIndicator>true</EditIndicator>
    <ElectronicAddressId>1</ElectronicAddressId>
    <EndDate>2025-04-24T05:25:25.3740926-07:00</EndDate>
    <GroupConstituent>
      <Id>1</Id>
    </GroupConstituent>
    <GroupConstituentName>sample string 7</GroupConstituentName>
    <GroupConstituentSortName>sample string 9</GroupConstituentSortName>
    <Id>1</Id>
    <Inactive>true</Inactive>
    <IndividualConstituent>
      <Id>1</Id>
    </IndividualConstituent>
    <IndividualConstituentName>sample string 6</IndividualConstituentName>
    <IndividualConstituentSortName>sample string 8</IndividualConstituentSortName>
    <IsAllowedToTransact>true</IsAllowedToTransact>
    <IsIncludedInSearchResults>true</IsIncludedInSearchResults>
    <NameIndicator>1</NameIndicator>
    <Note>sample string 5</Note>
    <PrimaryIndicator>true</PrimaryIndicator>
    <Salary>1</Salary>
    <SalutationId>1</SalutationId>
    <StartDate>2025-04-24T05:25:25.3740926-07:00</StartDate>
    <Title>sample string 10</Title>
    <UpdatedBy>sample string 3</UpdatedBy>
    <UpdatedDateTime>2025-04-24T05:25:25.3740926-07:00</UpdatedDateTime>
  </Affiliation>
  <Affiliation>
    <AddressId>1</AddressId>
    <AffiliatedName>sample string 1</AffiliatedName>
    <AffiliationType>
      <Description>sample string 1</Description>
      <Id>1</Id>
      <Inactive>true</Inactive>
      <IsIncludedInSearchResultsDefault>true</IsIncludedInSearchResultsDefault>
      <RelationshipCategory>
        <Description>sample string 1</Description>
        <Id>1</Id>
        <Inactive>true</Inactive>
      </RelationshipCategory>
      <UseSalary>true</UseSalary>
      <UseTitle>true</UseTitle>
    </AffiliationType>
    <CreateLocation>sample string 4</CreateLocation>
    <CreatedBy>sample string 2</CreatedBy>
    <CreatedDateTime>2025-04-24T05:25:25.3740926-07:00</CreatedDateTime>
    <EditIndicator>true</EditIndicator>
    <ElectronicAddressId>1</ElectronicAddressId>
    <EndDate>2025-04-24T05:25:25.3740926-07:00</EndDate>
    <GroupConstituent>
      <Id>1</Id>
    </GroupConstituent>
    <GroupConstituentName>sample string 7</GroupConstituentName>
    <GroupConstituentSortName>sample string 9</GroupConstituentSortName>
    <Id>1</Id>
    <Inactive>true</Inactive>
    <IndividualConstituent>
      <Id>1</Id>
    </IndividualConstituent>
    <IndividualConstituentName>sample string 6</IndividualConstituentName>
    <IndividualConstituentSortName>sample string 8</IndividualConstituentSortName>
    <IsAllowedToTransact>true</IsAllowedToTransact>
    <IsIncludedInSearchResults>true</IsIncludedInSearchResults>
    <NameIndicator>1</NameIndicator>
    <Note>sample string 5</Note>
    <PrimaryIndicator>true</PrimaryIndicator>
    <Salary>1</Salary>
    <SalutationId>1</SalutationId>
    <StartDate>2025-04-24T05:25:25.3740926-07:00</StartDate>
    <Title>sample string 10</Title>
    <UpdatedBy>sample string 3</UpdatedBy>
    <UpdatedDateTime>2025-04-24T05:25:25.3740926-07:00</UpdatedDateTime>
  </Affiliation>
</Affiliations>
Change Version Description Contract Old New
Property Added 15.1.0 GroupConstituentSortName has been added to Affiliation Affiliation Affiliation.GroupConstituentSortName
Property Added 15.1.0 IndividualConstituentSortName has been added to Affiliation Affiliation Affiliation.IndividualConstituentSortName
Parameter Added 15.1.0 New parameter added showWithGroup showWithGroup
Property Deprecated 15.0.0 IsAllowedToTransact has been marked as deprecated. Affiliation Deprecated