ReferenceColumns Test
ReferenceData/ReferenceColumns?maintenanceMode={maintenanceMode}
Get all reference columns. For filtering on specific property value, pass the property name with value as query parameter. If the property is another non primitive object, pass PropertyName.Id and its value as query parameter.
Http Verb GET
Resource URL https://ts-stg-appgw.calacademy.org/TessituraService/ReferenceData/ReferenceColumns?maintenanceMode={maintenanceMode}

URI Parameters

Parameter Name Data Type Required Notes
maintenanceMode boolean N Ignore control grouping (default: false).

Request Body

None.
No request body.

Response object type : Collection of ReferenceColumn

Response object type Collection of ReferenceColumn has the following properties.
Property Name Data Type Length Required Readonly Notes
Checkbox string N
ColumnName string N
ColumnType string N
ColValid string N
CreatedBy string N
CreatedDateTime date N
CreateLocation string N
DropDownDescription string N
DropDownTable string N
DropDownValue string N
DropDownWhereClause string N
Id integer N
Inactive boolean N
IsDropDownNullable boolean N
OrderAcross integer N
ReferenceTable ReferenceTableSummary N
FK: TR_REFERENCE_TABLE.id   Resource: ReferenceTables
UpdatedBy string N
UpdatedDateTime date N 
[
  {
    "ReferenceTable": {
      "Id": 1,
      "TableName": "sample string 1"
    },
    "Checkbox": "sample string 1",
    "ColValid": "sample string 2",
    "ColumnName": "sample string 3",
    "ColumnType": "sample string 4",
    "CreatedDateTime": "2025-04-24T03:56:22.3118677-07:00",
    "CreateLocation": "sample string 5",
    "CreatedBy": "sample string 6",
    "DropDownDescription": "sample string 7",
    "IsDropDownNullable": true,
    "DropDownTable": "sample string 9",
    "DropDownValue": "sample string 10",
    "DropDownWhereClause": "sample string 11",
    "Id": 1,
    "Inactive": true,
    "UpdatedDateTime": "2025-04-24T03:56:22.3118677-07:00",
    "UpdatedBy": "sample string 12",
    "OrderAcross": 13
  },
  {
    "ReferenceTable": {
      "Id": 1,
      "TableName": "sample string 1"
    },
    "Checkbox": "sample string 1",
    "ColValid": "sample string 2",
    "ColumnName": "sample string 3",
    "ColumnType": "sample string 4",
    "CreatedDateTime": "2025-04-24T03:56:22.3118677-07:00",
    "CreateLocation": "sample string 5",
    "CreatedBy": "sample string 6",
    "DropDownDescription": "sample string 7",
    "IsDropDownNullable": true,
    "DropDownTable": "sample string 9",
    "DropDownValue": "sample string 10",
    "DropDownWhereClause": "sample string 11",
    "Id": 1,
    "Inactive": true,
    "UpdatedDateTime": "2025-04-24T03:56:22.3118677-07:00",
    "UpdatedBy": "sample string 12",
    "OrderAcross": 13
  }
]
<ReferenceColumns xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
  <ReferenceColumn>
    <Checkbox>sample string 1</Checkbox>
    <ColValid>sample string 2</ColValid>
    <ColumnName>sample string 3</ColumnName>
    <ColumnType>sample string 4</ColumnType>
    <CreateLocation>sample string 5</CreateLocation>
    <CreatedBy>sample string 6</CreatedBy>
    <CreatedDateTime>2025-04-24T03:56:22.3118677-07:00</CreatedDateTime>
    <DropDownDescription>sample string 7</DropDownDescription>
    <DropDownTable>sample string 9</DropDownTable>
    <DropDownValue>sample string 10</DropDownValue>
    <DropDownWhereClause>sample string 11</DropDownWhereClause>
    <Id>1</Id>
    <Inactive>true</Inactive>
    <IsDropDownNullable>true</IsDropDownNullable>
    <OrderAcross>13</OrderAcross>
    <ReferenceTable>
      <Id>1</Id>
      <TableName>sample string 1</TableName>
    </ReferenceTable>
    <UpdatedBy>sample string 12</UpdatedBy>
    <UpdatedDateTime>2025-04-24T03:56:22.3118677-07:00</UpdatedDateTime>
  </ReferenceColumn>
  <ReferenceColumn>
    <Checkbox>sample string 1</Checkbox>
    <ColValid>sample string 2</ColValid>
    <ColumnName>sample string 3</ColumnName>
    <ColumnType>sample string 4</ColumnType>
    <CreateLocation>sample string 5</CreateLocation>
    <CreatedBy>sample string 6</CreatedBy>
    <CreatedDateTime>2025-04-24T03:56:22.3118677-07:00</CreatedDateTime>
    <DropDownDescription>sample string 7</DropDownDescription>
    <DropDownTable>sample string 9</DropDownTable>
    <DropDownValue>sample string 10</DropDownValue>
    <DropDownWhereClause>sample string 11</DropDownWhereClause>
    <Id>1</Id>
    <Inactive>true</Inactive>
    <IsDropDownNullable>true</IsDropDownNullable>
    <OrderAcross>13</OrderAcross>
    <ReferenceTable>
      <Id>1</Id>
      <TableName>sample string 1</TableName>
    </ReferenceTable>
    <UpdatedBy>sample string 12</UpdatedBy>
    <UpdatedDateTime>2025-04-24T03:56:22.3118677-07:00</UpdatedDateTime>
  </ReferenceColumn>
</ReferenceColumns>

No entries in change log for this operation.