A

AccountTypes
postput

Get the details of an account type by id.

Usage:
tq get AccountTypes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all account types. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all account types.

Accounts
postput

Get details of a specific credit card account

Usage:
tq get Accounts
Query:
{"AccountID":"string"}
[{"AccountID":"string"}]
AccountID
"""string"""

Flags:

  • --All
    Get details of all the credit card, direct debit, and SEPA accounts for the specified constituent id and all its visible affiliates' accounts as well. To exclude accounts of the visible affiliates pass includeAffiliations=false.
Query:
{"AccountTypeID":"string", "ConstituentID":"string", "IncludeAffiliates":"string", "IncludeInactive":"string"}
[{"AccountTypeID":"string","ConstituentID":"string","IncludeAffiliates":"string","IncludeInactive":"string"}]
AccountTypeID,ConstituentID,IncludeAffiliates,IncludeInactive
"""string""","""string""","""string""","""string"""

ActionTypes
postput

Get the details of an action type by id.

Usage:
tq get ActionTypes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all action types. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all action types.

Actions
postput

Get details of an issue action.

Usage:
tq get Actions
Query:
{"IssueActionID":"string"}
[{"IssueActionID":"string"}]
IssueActionID
"""string"""

Flags:

  • --All
    Get details of all the actions for the given constituent or issue.
Query:
{"ConstituentID":"string", "IssueID":"string"}
[{"ConstituentID":"string","IssueID":"string"}]
ConstituentID,IssueID
"""string""","""string"""

ActivityCategories
postput

Get the details of an activity category by id.

Usage:
tq get ActivityCategories
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all activity categories. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all activity categories.

ActivityTypes
postput

Get the details of an activity type by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get ActivityTypes
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all activity types. To get only the resources for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all activity types.

AddressTypes
postput

Get the details of an address type by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get AddressTypes
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all address types. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all address types.

Addresses
postput

Get details of an address using addressId as a URL query parameter. Returns 404 Not Found if an address with the specified Id is not found.

Usage:
tq get Addresses
Query:
{"AddressID":"string"}
[{"AddressID":"string"}]
AddressID
"""string"""

Flags:

  • --All
    Get details of all the addresses for the specified constituent id and all its visible affiliation's addresses as well. To exclude addresses of the visible affiliations pass includeAffiliations=false. To get only the primary addresses, pass primaryOnly=true.
Query:
{"ConstituentID":"string", "IncludeAffiliations":"string", "IncludeFromAffiliations":"string", "PrimaryOnly":"string"}
[{"ConstituentID":"string","IncludeAffiliations":"string","IncludeFromAffiliations":"string","PrimaryOnly":"string"}]
ConstituentID,IncludeAffiliations,IncludeFromAffiliations,PrimaryOnly
"""string""","""string""","""string""","""string"""

AffiliationTypes
postput

Get the details of an affiliation type by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get AffiliationTypes
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
Query:
{"ConstituentTypeID":"string", "Filter":"string", "MaintenanceMode":"string"}
[{"ConstituentTypeID":"string","Filter":"string","MaintenanceMode":"string"}]
ConstituentTypeID,Filter,MaintenanceMode
"""string""","""string""","""string"""

  • --Summaries
    Get a summary representation of all affiliation types.

Affiliations
postput

Get details of an affiliation.

Usage:
tq get Affiliations
Query:
{"AffiliationID":"string"}
[{"AffiliationID":"string"}]
AffiliationID
"""string"""

Flags:

  • --All
    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.
Query:
{"EndActiveDate":"string", "GroupConstituentID":"string", "IndividualConstituentID":"string", "PrimaryOnly":"string", "ShowWithGroup":"string", "StartActiveDate":"string"}
[{"EndActiveDate":"string","GroupConstituentID":"string","IndividualConstituentID":"string","PrimaryOnly":"string","ShowWithGroup":"string","StartActiveDate":"string"}]
EndActiveDate,GroupConstituentID,IndividualConstituentID,PrimaryOnly,ShowWithGroup,StartActiveDate
"""string""","""string""","""string""","""string""","""string""","""string"""

AliasTypes
postput

Get the details of an alias type by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get AliasTypes
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all alias types. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all alias types.

Aliases
postput

Get details of an alias.

Usage:
tq get Aliases
Query:
{"AliasID":"string"}
[{"AliasID":"string"}]
AliasID
"""string"""

Flags:

  • --All
    Get details of all the aliases for the specified constituent id and all its visible affiliation's aliases as well. To exclude aliases of the visible affiliations pass includeAffiliations=false.
Query:
{"ConstituentID":"string", "IncludeAffiliations":"string"}
[{"ConstituentID":"string","IncludeAffiliations":"string"}]
ConstituentID,IncludeAffiliations
"""string""","""string"""

AnalyticsCubes

Get the details of an analytics cube.

Usage:
tq get AnalyticsCubes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all analytics cubes. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

AnalyticsReports
postput

Get a single SSRS Report for display in Analytics.

Usage:
tq get AnalyticsReports
Query:
{"AnalyticsReportID":"string"}
[{"AnalyticsReportID":"string"}]
AnalyticsReportID
"""string"""

Flags:

  • --All
    Get all SSRS Reports for display in Analytics.

AppScreenTexts
put

Get the details of an App Screen Text by id. To get the resource in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get AppScreenTexts
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get details of all App Screen Texts. To get them in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all App Screen Texts.

AppealCategories
postput

Get the details of an appeal category by id.

Usage:
tq get AppealCategories
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all appeal categories. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all appeal categories.

Appeals

Get details of an Appeal.

Usage:
tq get Appeals
Query:
{"AppealID":"string"}
[{"AppealID":"string"}]
AppealID
"""string"""

Flags:

  • --Summaries
    Get summary of all Appeals.
Query:
{"ActiveOnly":"string"}
[{"ActiveOnly":"string"}]
ActiveOnly
"""string"""

ApplicationObjects

Get all application objects valid for the context usergroup.

Usage:
tq get ApplicationObjects
Query:



Artists
postput

Get details of an existing artist.

Usage:
tq get Artists
Query:
{"ArtistID":"string"}
[{"ArtistID":"string"}]
ArtistID
"""string"""

Flags:

  • --All
    Get details of all artists.

AssetTypes
postput

Get the details of an asset type by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get AssetTypes
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all asset types. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all asset types.

Assets
postput

Get details of an asset.

Usage:
tq get Assets
Query:
{"AssetID":"string"}
[{"AssetID":"string"}]
AssetID
"""string"""

Flags:

  • --All
    Get details of all the assets for the specified constituent id and all its visible affiliations' assets as well. To exclude assets of the visible affiliations pass includeAffiliations=false.
Query:
{"ConstituentID":"string", "IncludeAffiliations":"string"}
[{"ConstituentID":"string","IncludeAffiliations":"string"}]
ConstituentID,IncludeAffiliations
"""string""","""string"""

AssociationTypes
postput

Get the details of an association type by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get AssociationTypes
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all association types. To get only the resources for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all association types.

Associations
postput

Get details of an association.

Usage:
tq get Associations
Query:
{"AssociationID":"string"}
[{"AssociationID":"string"}]
AssociationID
"""string"""

Flags:

  • --All
    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.
Query:
{"AssociatedConstituentID":"string", "ConstituentID":"string", "EndActiveDate":"string", "StartActiveDate":"string"}
[{"AssociatedConstituentID":"string","ConstituentID":"string","EndActiveDate":"string","StartActiveDate":"string"}]
AssociatedConstituentID,ConstituentID,EndActiveDate,StartActiveDate
"""string""","""string""","""string""","""string"""

AttendanceHistory

Attendance History for a selected constituent optionally including primary affiliates. Does not return history based on recipient for the selected constituent(s).

Usage:
tq get AttendanceHistory
Query:
{"ConstituentID":"string", "IncludeAffiliations":"string"}
[{"ConstituentID":"string","IncludeAffiliations":"string"}]
ConstituentID,IncludeAffiliations
"""string""","""string"""

Attributes
postput

Get details of an attribute.

Usage:
tq get Attributes
Query:
{"AttributeID":"string"}
[{"AttributeID":"string"}]
AttributeID
"""string"""

Flags:

  • --All
    Get details of all the attributes for the specified constituent id and all its visible affiliation's attributes as well. To exclude attributes of the visible affiliations pass includeAffiliations=false.
Query:
{"ConstituentID":"string", "IncludeAffiliations":"string"}
[{"ConstituentID":"string","IncludeAffiliations":"string"}]
ConstituentID,IncludeAffiliations
"""string""","""string"""

AuditLogs

Get details of a audit log.

Usage:
tq get AuditLogs
Query:
{"AuditLog":"string"}
[{"AuditLog":"string"}]
AuditLog
"""string"""

Flags:

  • --All
    Get all audit logs. The audit log response is paginated with default pageIndex = 1 and pageSize = 100. To get the audit log between a specific time interval specify auditStartTime and auditEndTime. If only auditStartTime is specified then all audit entries after that time would be returned. If only auditEndTime is specified then all audit entries before that time would be returned.
Query:
{"Action":"string", "AuditEndTime":"string", "AuditStartTime":"string", "EntityIds":"string", "IncludeSubEntities":"string", "PageIndex":"string", "PageSize":"string", "Table":"string"}
[{"Action":"string","AuditEndTime":"string","AuditStartTime":"string","EntityIds":"string","IncludeSubEntities":"string","PageIndex":"string","PageSize":"string","Table":"string"}]
Action,AuditEndTime,AuditStartTime,EntityIds,IncludeSubEntities,PageIndex,PageSize,Table
"""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string"""

  • --Details
    Get audit log details.
Query:
{"Action":"string", "AuditEndTime":"string", "AuditStartTime":"string", "EntityIds":"string", "IncludeSubEntities":"string", "PageIndex":"string", "PageSize":"string", "Table":"string"}
[{"Action":"string","AuditEndTime":"string","AuditStartTime":"string","EntityIds":"string","IncludeSubEntities":"string","PageIndex":"string","PageSize":"string","Table":"string"}]
Action,AuditEndTime,AuditStartTime,EntityIds,IncludeSubEntities,PageIndex,PageSize,Table
"""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string"""

Authenticate
post

This is a no-op operation for windows authentication diagnostics.

Usage:
tq get Authenticate
Query:



B

BatchMaintenance
post

Get a single Batch

Usage:
tq get BatchMaintenance
Query:
{"BatchID":"string"}
[{"BatchID":"string"}]
BatchID
"""string"""

Flags:

  • --Active
    Returns all open or held batches owned by the service user. Optionally filters out controlled batches
Query:
{"IncludeControlled":"string"}
[{"IncludeControlled":"string"}]
IncludeControlled
"""string"""

BatchTypeGroups
postput

Get the details of a batch type group by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get BatchTypeGroups
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all batch type groups. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all batch type groups.

BatchTypeUserGroup

Get all batch type/user group mappings.

Usage:
tq get BatchTypeUserGroup
Query:
{"UserGroup":"string"}
[{"UserGroup":"string"}]
UserGroup
"""string"""

BatchTypes
postput

Get the details of a batch type by id.

Usage:
tq get BatchTypes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all batch types. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all batch types.

BillingSchedules
postput

Get the details of a Billing Schedule. To get only the resources for which the user has write/edit access, pass filter="writeonly". To get the resource in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get BillingSchedules
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all Billing Schedules. To get only the resources for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all Billing Schedules.

BillingTypes
postput

Get the details of a Billing Type by id. To get the resource in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get BillingTypes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get details of all Billing Types. To get them in maintenance mode (which ignores Control Groups), pass maintenanceMode="true".
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all Billing Types.

BookingCategories
postput

Get the details of a Booking Category by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get BookingCategories
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all Booking Categories. To get only the resources for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all Booking Categories.

BookingTemplates
postput

Get a Booking Template by ID

Usage:
tq get BookingTemplates
Query:
{"BookingTemplateID":"string"}
[{"BookingTemplateID":"string"}]
BookingTemplateID
"""string"""

Flags:

  • --Summaries
    Get summary of all Booking Templates, filtered optionally by category.
Query:
{"CategoryID":"string"}
[{"CategoryID":"string"}]
CategoryID
"""string"""

Bookings
postput

Get a Booking by id

Usage:
tq get Bookings
Query:
{"BookingID":"string"}
[{"BookingID":"string"}]
BookingID
"""string"""

Flags:

  • --AllDocumentSummaries
    Get summary of all the documents associated with the booking. (Excluding the file contents)
Query:
{"BookingID":"string"}
[{"BookingID":"string"}]
BookingID
"""string"""

  • --AllDocuments
    Get all the documents associated with the booking (Including the file contents).
Query:
{"BookingID":"string"}
[{"BookingID":"string"}]
BookingID
"""string"""

  • --Document
    Get the document associated with the documentId (Including the file contents).
Query:
{"BookingID":"string", "DocumentID":"string"}
[{"BookingID":"string","DocumentID":"string"}]
BookingID,DocumentID
"""string""","""string"""

  • --Summary
    Get a summary for a single Booking.
Query:
{"BookingID":"string"}
[{"BookingID":"string"}]
BookingID
"""string"""

BulkCopySets
postput

Get a bulk copy set by Id.

Usage:
tq get BulkCopySets
Query:
{"BulkCopySetID":"string"}
[{"BulkCopySetID":"string"}]
BulkCopySetID
"""string"""

Flags:

  • --All
    Get all bulk copy sets.
  • --DayForCopy
    Returns the packages and performances that will be copied for the daily bulk copy set
Query:
{"BulkCopySetID":"string"}
[{"BulkCopySetID":"string"}]
BulkCopySetID
"""string"""

  • --Summaries
    Get a summary of all bulk copy sets.

BulkDailyCopyExclusions
postput

Get a bulk daily copy exclusion by id.

Usage:
tq get BulkDailyCopyExclusions
Query:
{"BulkDailyCopyExclusionID":"string"}
[{"BulkDailyCopyExclusionID":"string"}]
BulkDailyCopyExclusionID
"""string"""

Flags:

  • --All
    Get all bulk daily copy exclusions for a given bulk copy set.
Query:
{"BulkCopySetID":"string"}
[{"BulkCopySetID":"string"}]
BulkCopySetID
"""string"""

BusinessUnits
postput

Get the details of a business unit by id.

Usage:
tq get BusinessUnits
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all business units. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all business units.

C

Cache

Usage:
tq get Cache
Query:



CampaignDesignations
postput

Get a single Designation associated to a Campaign.

Usage:
tq get CampaignDesignations
Query:
{"CampaignDesignationID":"string"}
[{"CampaignDesignationID":"string"}]
CampaignDesignationID
"""string"""

Flags:

  • --All
    Get all Designations associated to a Campaign.
Query:
{"CampaignID":"string"}
[{"CampaignID":"string"}]
CampaignID
"""string"""

CampaignFunds
postput

Get a single Fund associated to a Campaign.

Usage:
tq get CampaignFunds
Query:
{"CampaignFundID":"string"}
[{"CampaignFundID":"string"}]
CampaignFundID
"""string"""

Flags:

  • --All
    Get all Funds associated to a Campaign.
Query:
{"AsOfDateTime":"string", "CampaignID":"string"}
[{"AsOfDateTime":"string","CampaignID":"string"}]
AsOfDateTime,CampaignID
"""string""","""string"""

Campaigns

Get summary of a specific campaign.

Usage:
tq get Campaigns
Query:
{"CampaignID":"string"}
[{"CampaignID":"string"}]
CampaignID
"""string"""

Flags:

  • --Summaries
    Return a collection of all campaigns in summary, optionally excluding inactive campaigns.
Query:
{"ActiveOnly":"string"}
[{"ActiveOnly":"string"}]
ActiveOnly
"""string"""

CardReaderTypes
postput

Get the details of a Card Reader Type by id. To get the resource in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get CardReaderTypes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get details of all Card Reader Types. To get them in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all Card Reader Types.

Cart
postput

Gets the cart details

Usage:
tq get Cart
Query:
{"MessageTypes":"string", "SavedCart":"string", "SessionKey":"string"}
[{"MessageTypes":"string","SavedCart":"string","SessionKey":"string"}]
MessageTypes,SavedCart,SessionKey
"""string""","""string""","""string"""

Flags:

  • --CartProperties
    Returns cart properties
Query:
{"SessionKey":"string"}
[{"SessionKey":"string"}]
SessionKey
"""string"""

  • --Messages
    Gets the pricing rule messages for the current cart. Both Message Only and Rule messages are returned.
Query:
{"MessageTypes":"string", "SavedCart":"string", "SessionKey":"string"}
[{"MessageTypes":"string","SavedCart":"string","SessionKey":"string"}]
MessageTypes,SavedCart,SessionKey
"""string""","""string""","""string"""

  • --ReceiptString
    Returns a formatted receipt for a cart
Query:
{"ReceiptSettingsID":"string", "SessionKey":"string", "TargetFormat":"string"}
[{"ReceiptSettingsID":"string","SessionKey":"string","TargetFormat":"string"}]
ReceiptSettingsID,SessionKey,TargetFormat
"""string""","""string""","""string"""

  • --Summary
    Gets the cart summary Used by TRBO. Returns the cart with product lines summarized by price type, zone and price.
Query:
{"MessageTypes":"string", "SavedCart":"string", "SessionKey":"string"}
[{"MessageTypes":"string","SavedCart":"string","SessionKey":"string"}]
MessageTypes,SavedCart,SessionKey
"""string""","""string""","""string"""

Colors
postput

Get the details of a color by id.

Usage:
tq get Colors
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all colors. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all colors.

Composers
postput

Get the details of a composer by id.

Usage:
tq get Composers
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all composers. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all composers.

Constituencies
postput

Get details of constituency.

Usage:
tq get Constituencies
Query:
{"ConstituencyID":"string"}
[{"ConstituencyID":"string"}]
ConstituencyID
"""string"""

Flags:

  • --All
    Get details of all the constituencies for the specified constituent id and all its visible affiliation's constituencies as well. To exclude constituencies of the visible affiliations pass includeAffiliations=false.
Query:
{"ConstituentID":"string", "IncludeAffiliations":"string"}
[{"ConstituentID":"string","IncludeAffiliations":"string"}]
ConstituentID,IncludeAffiliations
"""string""","""string"""

ConstituencyTypes
postput

Get the details of a constituency type by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get ConstituencyTypes
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all constituency types. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all constituency types.

ConstituentContributions

Get contributions for a constituent.

Usage:
tq get ConstituentContributions
Query:
{"CampaignIds":"string", "ConstituentID":"string", "EndDate":"string", "FundIds":"string", "IncludeAffiliations":"string", "StartDate":"string"}
[{"CampaignIds":"string","ConstituentID":"string","EndDate":"string","FundIds":"string","IncludeAffiliations":"string","StartDate":"string"}]
CampaignIds,ConstituentID,EndDate,FundIds,IncludeAffiliations,StartDate
"""string""","""string""","""string""","""string""","""string""","""string"""

ConstituentDocuments
postput

Get the details of a document for a constituent.

Usage:
tq get ConstituentDocuments
Query:
{"DocumentID":"string"}
[{"DocumentID":"string"}]
DocumentID
"""string"""

Flags:

  • --All
    Get all the documents for a particular constituent including file contents.
Query:
{"ConstituentID":"string", "IncludeAffiliations":"string"}
[{"ConstituentID":"string","IncludeAffiliations":"string"}]
ConstituentID,IncludeAffiliations
"""string""","""string"""

  • --AllSummary
    Get summary of all the documents for the constituent. Only a summary of file information is returned.
Query:
{"ConstituentID":"string", "IncludeAffiliations":"string"}
[{"ConstituentID":"string","IncludeAffiliations":"string"}]
ConstituentID,IncludeAffiliations
"""string""","""string"""

ConstituentGroups
postput

Get the details of a constituent group by id.

Usage:
tq get ConstituentGroups
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all constituent groups. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all constituent groups.

ConstituentInactives
postput

Get the details of a constituent inactive by id.

Usage:
tq get ConstituentInactives
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all constituent inactives. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all constituent inactives.

ConstituentProtectionTypes
postput

Get the details of a constituent protection type by id.

Usage:
tq get ConstituentProtectionTypes
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all constituent protection types. 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all constituent protection types.

ConstituentTypeAffiliates
postput

Get the details of a constituent type affiliate by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get ConstituentTypeAffiliates
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all constituent type affiliates. To get only the resources for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all constituent type affiliates.

ConstituentTypes
postput

Get the details of a constituent type by id.

Usage:
tq get ConstituentTypes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all constituent types. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all constituent types.

Constituents
postput

Get the details of a Constituent using id.

Usage:
tq get Constituents
Query:
{"ConstituentID":"string"}
[{"ConstituentID":"string"}]
ConstituentID
"""string"""

Flags:

  • --Constituent
    Get constituent details with addresses, electronicAddresses, salutations and phones. To exclude information about visible affiliations pass includeAffiliations="false"
Query:
{"ConstituentID":"string", "IncludeAffiliations":"string"}
[{"ConstituentID":"string","IncludeAffiliations":"string"}]
ConstituentID,IncludeAffiliations
"""string""","""string"""

  • --ConstituentDevelopmentInfo
    Get constituent information for fundraising.
Query:
{"ConstituentID":"string"}
[{"ConstituentID":"string"}]
ConstituentID
"""string"""

  • --ConstituentSnapshot
    Get constituent details along with primary address, primary salutation, primary electronic address, phones and affiliates information.
Query:
{"ConstituentID":"string"}
[{"ConstituentID":"string"}]
ConstituentID
"""string"""

  • --Constituents
    Get multiple Constituents given a set of constituentIds.
Query:
{"ConstituentIds":"string"}
[{"ConstituentIds":"string"}]
ConstituentIds
"""string"""

  • --DefaultHeader
    Return the default header for the constituent, including configured flexible header names and values.
Query:
{"ConstituentID":"string"}
[{"ConstituentID":"string"}]
ConstituentID
"""string"""

  • --FlexHeader
    Get the details of a flex header for a constituent
Query:
{"ConstituentID":"string", "HeaderID":"string"}
[{"ConstituentID":"string","HeaderID":"string"}]
ConstituentID,HeaderID
"""string""","""string"""

  • --Header
    Return constituent header details, including configured flexible header names and values.
Query:
{"ConstituentID":"string", "HeaderID":"string"}
[{"ConstituentID":"string","HeaderID":"string"}]
ConstituentID,HeaderID
"""string""","""string"""

  • --PrimaryHousehold
    Get primary household constituent details for a provided constituentId.
Query:
{"ConstituentID":"string"}
[{"ConstituentID":"string"}]
ConstituentID
"""string"""

  • --Search
    Search for constituents using one of four possible search modes. Querystring parameters are valid based on the "type" parameter value. Single Line (type=fluent) Sample: CRM/Constituents/Search?type=fluent&q=Huff Single Line search type (or fluent) is the default search if not provided in querystring. Single line search works on string patterns in the passed search value ("q" param). Patterns are as follows: Value contains only alpha characters - interpreted as a last name search. To search with first name, pass comma then additional search value ("last, first"). Text enclosed in quotes is interpreted as a search for name ("ACE 123 Corporation"). value containing an @ symbol is interpreted as an email address. Value starting with # is interpreted as a phone number search. Value containing alpha and numeric characters is interpreted as a postal code. UK and other countries should omit spaces for postal code search values. Basic search type permits parameters constituentId, ln, fn, street, and post. Sample URL: CRM/Constituents/Search?type=basic&ln=Huff&fn=Frank&post=20746 Advanced search type permits parameters atype, op, and value. Sample URL: CRM/Constituents/Search?type=advanced&atype=Email&op=Like&value=%25@gmail.com Attribute search type permits parameters key, op, value. Sample URL: CRM/Constituents/Search?type=attribute&key=Board+Affiliation&op=Equals&value=Association+Member
Query:
{"Atype":"string", "ConstituencyIds":"string", "ConstituentGroups":"string", "ConstituentID":"string", "Dup":"string", "Fn":"string", "IncludeAffiliates":"string", "Key":"string", "ListID":"string", "Ln":"string", "Op":"string", "Page":"string", "PageSize":"string", "Post":"string", "Q":"string", "Street":"string", "Type":"string", "Value":"string"}
[{"Atype":"string","ConstituencyIds":"string","ConstituentGroups":"string","ConstituentID":"string","Dup":"string","Fn":"string","IncludeAffiliates":"string","Key":"string","ListID":"string","Ln":"string","Op":"string","Page":"string","PageSize":"string","Post":"string","Q":"string","Street":"string","Type":"string","Value":"string"}]
Atype,ConstituencyIds,ConstituentGroups,ConstituentID,Dup,Fn,IncludeAffiliates,Key,ListID,Ln,Op,Page,PageSize,Post,Q,Street,Type,Value
"""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string"""

ContactPermissionCategories
postput

Get the details of a contact permission category. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resource in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get ContactPermissionCategories
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all contact permission categories. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all contact permission categories.

ContactPermissionTypes
postput

Get the details of a contact permission type. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resource in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get ContactPermissionTypes
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all contact permission types. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --ForProductionSeasons
    Get all contact permission types assigned to a set of production seasons.
Query:
{"ProductionSeasonIds":"string"}
[{"ProductionSeasonIds":"string"}]
ProductionSeasonIds
"""string"""

  • --Summaries
    Get a summary representation of all contact permission types.

ContactPermissions
postput

Get details of a contact permission

Usage:
tq get ContactPermissions
Query:
{"ContactPermissionID":"string"}
[{"ContactPermissionID":"string"}]
ContactPermissionID
"""string"""

Flags:

  • --All
    Get all the contact permissions for the specified constituent and its affiliations if requested
Query:
{"ActiveOnly":"string", "ConstituentID":"string", "IncludeAffiliations":"string"}
[{"ActiveOnly":"string","ConstituentID":"string","IncludeAffiliations":"string"}]
ActiveOnly,ConstituentID,IncludeAffiliations
"""string""","""string""","""string"""

ContactPointCategories
postput

Get the details of a contact point category by id.

Usage:
tq get ContactPointCategories
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all contact point categories. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all contact point categories.

ContactPointCategoryPurposes
postput

Get the details of a contact point category purpose by id.

Usage:
tq get ContactPointCategoryPurposes
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all contact point category purposes. 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all contact point category purposes.

ContactPointPurposeCategories
postput

Get the details of a contact point purpose category by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get ContactPointPurposeCategories
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all contact point purpose categories. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all contact point purpose categories.

ContactPointPurposeMaps
postput

Get details of a contact point purpose.

Usage:
tq get ContactPointPurposeMaps
Query:
{"ContactPointPurposeMapID":"string"}
[{"ContactPointPurposeMapID":"string"}]
ContactPointPurposeMapID
"""string"""

Flags:

  • --All
    Get details of all the contact point purposes for the specified constituent (constituentId) and all its visible affiliation's contact point purposes as well. To exclude contact point purposes of the visible affiliations pass includeAffiliations=false. To get contact point purposes for a contact point pass contactPointId.
Query:
{"ConstituentID":"string", "ContactPointCategoryID":"string", "ContactPointID":"string", "IncludeAffiliations":"string", "PurposeID":"string"}
[{"ConstituentID":"string","ContactPointCategoryID":"string","ContactPointID":"string","IncludeAffiliations":"string","PurposeID":"string"}]
ConstituentID,ContactPointCategoryID,ContactPointID,IncludeAffiliations,PurposeID
"""string""","""string""","""string""","""string""","""string"""

ContactPointPurposes
postput

Get the details of a contact point purpose by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get ContactPointPurposes
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all contact point purposes. To get only the resources for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all contact point purposes.

ContactPoints

Get all the delivery points for the specified constituent (constituentId) and all its visible affiliation's delivery point purposes as well. To exclude delivery point purposes of the visible affiliations pass includeAffiliations=false.

Usage:
tq get ContactPoints
Query:
{"ConstituentID":"string", "IncludeAffiliations":"string"}
[{"ConstituentID":"string","IncludeAffiliations":"string"}]
ConstituentID,IncludeAffiliations
"""string""","""string"""

ContactTypes
postput

Get the details of a contact type by id.

Usage:
tq get ContactTypes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all contact types. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all contact types.

ContextInformation

Get a commonly used set of default values for the user and usergroup in the current security context.

Usage:
tq get ContextInformation
Query:



ContributionDesignations
postput

Get the details of a contribution designation by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get ContributionDesignations
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all contribution designations. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all contribution designations.

ContributionImportSets
postput

Get the details of a contributionImportSet by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get ContributionImportSets
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all contributionImportSets. To get only the resources for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups if this is a secured resource), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all contributionImportSets.

ControlGroupUserGroups
postput

Get the details of a control group/user group mapping by id.

Usage:
tq get ControlGroupUserGroups
Query:
{"ID":"string"}
[{"ID":"string"}]
ID
"""string"""

Flags:

  • --All
    Get all control group/user group mappings.
  • --Summaries
    Get a summary representation of all control group/user group mappings.

ControlGroups
postput

Get the details of a control group by id.

Usage:
tq get ControlGroups
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all control groups. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all control groups.

CoreIdentity
post

Usage:
tq get CoreIdentity
Query:



Countries
postput

Get the details of a country by id.

Usage:
tq get Countries
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all countries. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all countries.

CrediteeTypes
postput

Get the details of a crediteeType by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get CrediteeTypes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all crediteeTypes. To get only the resources for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups if this is a secured resource), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all crediteeTypes.

Credits

Returns all credits for the requested production element, and all credits from above it in the production hierarchy.

Usage:
tq get Credits
Query:
{"ProductionElementIds":"string"}
[{"ProductionElementIds":"string"}]
ProductionElementIds
"""string"""

CriterionOperators

Get the details of a criterion operator by id.

Usage:
tq get CriterionOperators
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all criterion operators. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all criterion operators.

CumulativeGivingReceipts

Get details of an cumulativeGivingReceipt.

Usage:
tq get CumulativeGivingReceipts
Query:
{"CumulativeGivingReceiptID":"string"}
[{"CumulativeGivingReceiptID":"string"}]
CumulativeGivingReceiptID
"""string"""

Flags:

  • --All
    Get Cumulative Giving Receipts for the specified constituent id and affiliation Cumulative Giving Receipts as well. To exclude receipts of the visible affiliations pass includeAffiliations=false.
Query:
{"ConstituentID":"string", "IncludeAffiliations":"string"}
[{"ConstituentID":"string","IncludeAffiliations":"string"}]
ConstituentID,IncludeAffiliations
"""string""","""string"""

  • --ForSession
    To retrieve a specific receipt for a session, pass sessionId and constituentId.
Query:
{"ConstituentID":"string", "SessionID":"string"}
[{"ConstituentID":"string","SessionID":"string"}]
ConstituentID,SessionID
"""string""","""string"""

CurrencyTypes
postput

Get the details of a currency type by id.

Usage:
tq get CurrencyTypes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all currency types. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all currency types.

Custom
post

Get the metadata information of a custom table as defined by TR_DATASERVICE_TABLES and TR_DATASERVICE_COLUMNS.

Usage:
tq get Custom
Query:



CustomDefaultCategories
postput

Get the details of a custom default category by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get CustomDefaultCategories
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all custom default categories. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all custom default categories.

CustomDefaults
postput

Get the details of a custom default by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get CustomDefaults
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all custom defaults. To get only the resources for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all custom defaults.

D

DeliveryMethods
postput

Get the details of a delivery method by id.

Usage:
tq get DeliveryMethods
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all delivery methods. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all delivery methods.

DesignationCodes
postput

Get the details of a designation code by id.

Usage:
tq get DesignationCodes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all designation codes. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all designation codes.

Designs

Get the details of a design by id.

Usage:
tq get Designs
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all designs. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all designs.

Diagnostics
postput

Validates Encryption Key Dates.

Usage:
tq get Diagnostics
Query:



Flags:

  • --SeatServerStatus
    Returns status of the seat server connection.
  • --Status
    Returns status of the application connection to database and service version information.
  • --StatusReport
    Returns status of the application connection to database and service version information as an html page.

DirectDebitAccountTypes
postput

Get the details of a direct debit account type by id.

Usage:
tq get DirectDebitAccountTypes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all direct debit currency types.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all direct debit account types.

DiscountTypes
postput

Get the details of a discount type by id.

Usage:
tq get DiscountTypes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all discount types. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all discount types.

Divisions

Get the control group/division mappings for the specified division.

Usage:
tq get Divisions
Query:



Flags:

  • --ForDivision
    Get the control group/division mappings for the specified division.
Query:
{"DivisionID":"string"}
[{"DivisionID":"string"}]
DivisionID
"""string"""

DocumentCategories
postput

Get the details of a documentCategory by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get DocumentCategories
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all documentCategories. To get only the resources for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all documentCategories.

Documents

Get the details of a document.

Usage:
tq get Documents
Query:
{"DocumentID":"string"}
[{"DocumentID":"string"}]
DocumentID
"""string"""

Flags:

  • --All
    Get all the documents for a particular resource including file contents. Only documents associated with steps may be returned at this time.
Query:
{"StepID":"string"}
[{"StepID":"string"}]
StepID
"""string"""

  • --AllSummary
    Get summary of all the documents for the step. Only a summary of file information is returned.
Query:
{"StepID":"string"}
[{"StepID":"string"}]
StepID
"""string"""

  • --Settings
    Get configuration settings for uploading documents.

DonationLevels
postput

Get the details of a donation level by id.

Usage:
tq get DonationLevels
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all donation levels. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all donation levels.

E

EMV
postput

Retrieve information on all lanes associated with merchant

Usage:
tq get EMV
Query:
{"Cert":"string", "Merchant":"string"}
[{"Cert":"string","Merchant":"string"}]
Cert,Merchant
"""string""","""string"""

Flags:

  • --ConnectionStatus
    Get connection status for a lane
Query:
{"Cert":"string", "LaneID":"string", "Merchant":"string"}
[{"Cert":"string","LaneID":"string","Merchant":"string"}]
Cert,LaneID,Merchant
"""string""","""string""","""string"""

  • --ConnectionStatusHistory
    Get connection status history for a lane
Query:
{"Cert":"string", "LaneID":"string", "Merchant":"string"}
[{"Cert":"string","LaneID":"string","Merchant":"string"}]
Cert,LaneID,Merchant
"""string""","""string""","""string"""

  • --IdleMessage
    Retrieve idle message for a specific lane
Query:
{"Cert":"string", "LaneID":"string", "Merchant":"string"}
[{"Cert":"string","LaneID":"string","Merchant":"string"}]
Cert,LaneID,Merchant
"""string""","""string""","""string"""

  • --Lane
    Retrieve information for a specific lane
Query:
{"Cert":"string", "LaneID":"string", "Merchant":"string"}
[{"Cert":"string","LaneID":"string","Merchant":"string"}]
Cert,LaneID,Merchant
"""string""","""string""","""string"""

ElectronicAddressTypes
postput

Get the details of an electronic address type by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get ElectronicAddressTypes
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all electronic address types. To get only the resources for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all electronic address types.

ElectronicAddresses
postput

Get details of an electronic address.

Usage:
tq get ElectronicAddresses
Query:
{"ElectronicAddressID":"string"}
[{"ElectronicAddressID":"string"}]
ElectronicAddressID
"""string"""

Flags:

  • --All
    Get electronic addresses for constituent(s) or query general public electronic addresses for a specific address.

Either constituentIds, useGeneralPublic, or address must be specified in request. For constituent electronic address, visible affiliation electronic addresses can be included with includeAffiliations=true. To exclude electronic addresses of the visible affiliations pass includeAffiliations=false. To retrieve only the primary electronic addresses, pass primaryOnly=true.

Query:
{"Address":"string", "ConstituentIds":"string", "ElectronicAddressTypeID":"string", "IncludeAffiliations":"string", "IncludeFromAffiliations":"string", "PrimaryOnly":"string", "UseGeneralPublic":"string"}
[{"Address":"string","ConstituentIds":"string","ElectronicAddressTypeID":"string","IncludeAffiliations":"string","IncludeFromAffiliations":"string","PrimaryOnly":"string","UseGeneralPublic":"string"}]
Address,ConstituentIds,ElectronicAddressTypeID,IncludeAffiliations,IncludeFromAffiliations,PrimaryOnly,UseGeneralPublic
"""string""","""string""","""string""","""string""","""string""","""string""","""string"""

  • --IsAttachedToLogin
    Check if the specified electronic address is attached to a web login.
Query:
{"ElectronicAddressID":"string"}
[{"ElectronicAddressID":"string"}]
ElectronicAddressID
"""string"""

EmailProfiles
postput

Get the details of an email profile by id

Usage:
tq get EmailProfiles
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all email profiles
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get summary of all email profiles

EmarketIndicators
postput

Get the details of an emarket indicator by id.

Usage:
tq get EmarketIndicators
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all emarket indicators. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all emarket indicators.

Eras
postput

Get the details of an era by id.

Usage:
tq get Eras
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all eras. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all eras.

EventControl

Returns a response containing a list of EventControl rows for the N-Scan event control table.

Usage:
tq get EventControl
Query:
{"EndDate":"string", "StartDate":"string"}
[{"EndDate":"string","StartDate":"string"}]
EndDate,StartDate
"""string""","""string"""

F

Facilities
postput

Get details of a Facility.

Usage:
tq get Facilities
Query:
{"ID":"string"}
[{"ID":"string"}]
ID
"""string"""

Flags:

  • --All
    Get details of all the Facilities.
  • --Screens
    Returns details of all screens and the HouseMap for the facility. The screen details include which other screens are assigned to each screen navigation arrow button.
Query:
{"FacilityID":"string"}
[{"FacilityID":"string"}]
FacilityID
"""string"""

  • --Summaries
    Get summary representation of all Facilities.

Fees

Get details of a fee.

Usage:
tq get Fees
Query:
{"ID":"string"}
[{"ID":"string"}]
ID
"""string"""

Flags:

  • --All
    Get all fees.
Query:
{"FeeCategoryIds":"string", "SeasonID":"string", "UserDefined":"string"}
[{"FeeCategoryIds":"string","SeasonID":"string","UserDefined":"string"}]
FeeCategoryIds,SeasonID,UserDefined
"""string""","""string""","""string"""

  • --Summaries
    Get summary representation of all fees.
Query:
{"FeeCategoryIds":"string", "SeasonID":"string", "UserDefined":"string"}
[{"FeeCategoryIds":"string","SeasonID":"string","UserDefined":"string"}]
FeeCategoryIds,SeasonID,UserDefined
"""string""","""string""","""string"""

FinanceContributions

Get details of a contribution.

Usage:
tq get FinanceContributions
Query:
{"ContributionID":"string"}
[{"ContributionID":"string"}]
ContributionID
"""string"""

Flags:

  • --All
    Get details of all the contributions for the specified plan.
Query:
{"PlanID":"string"}
[{"PlanID":"string"}]
PlanID
"""string"""

Formats

Get the details of a format by id.

Usage:
tq get Formats
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all formats. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all formats.

Funds

Get details of a specific fund

Usage:
tq get Funds
Query:
{"FundID":"string"}
[{"FundID":"string"}]
FundID
"""string"""

Flags:

  • --Summaries
    Get summary of all funds.
Query:
{"TicketingIndicator":"string"}
[{"TicketingIndicator":"string"}]
TicketingIndicator
"""string"""

G

GLAccounts

Get the details of a gl account by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get GLAccounts
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all gl accounts. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all gl accounts.

Genders
postput

Get the details of a gender by id.

Usage:
tq get Genders
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all available gender values. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all gender values.

GiftAidContactMethods
postput

Get the details of a gift aid contact method by id.

Usage:
tq get GiftAidContactMethods
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all gift aid contact methods. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all gift aid contact methods.

GiftAidDeclarations
postput

Gets a single Gift Aid Declaration.

Usage:
tq get GiftAidDeclarations
Query:
{"GiftAidDeclarationID":"string"}
[{"GiftAidDeclarationID":"string"}]
GiftAidDeclarationID
"""string"""

Flags:

  • --All
    Gets all Gift Aid Declarations for a provided constituent including primary affiliates by default.
Query:
{"ConstituentID":"string", "IncludeAffiliations":"string"}
[{"ConstituentID":"string","IncludeAffiliations":"string"}]
ConstituentID,IncludeAffiliations
"""string""","""string"""

GiftAidDocumentStatuses
postput

Get the details of a gift aid document status by id.

Usage:
tq get GiftAidDocumentStatuses
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all gift aid document statuses. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all gift aid document statuses.

GiftAidIneligibleReasons
postput

Get the details of a gift aid ineligible reason by id.

Usage:
tq get GiftAidIneligibleReasons
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all gift aid ineligible reasons. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all gift aid ineligible reasons.

GiftAidRates
postput

Get the details of a gift aid rate by id.

Usage:
tq get GiftAidRates
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all gift aid rates. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all gift aid rates.

GiftAidStatuses
postput

Get the details of a gift aid status by id.

Usage:
tq get GiftAidStatuses
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all gift aid statuses. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all gift aid statuses.

GiftAidTypes
postput

Get the details of a gift aid type by id.

Usage:
tq get GiftAidTypes
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all gift aid types. 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all gift aid types.

GiftCertificates
post

Get details of a specific gift certificate. The original amount, amount used and balance are all returned. Amounts applied to a current web session are included.

Usage:
tq get GiftCertificates
Query:
{"GiftCertificateNumber":"string"}
[{"GiftCertificateNumber":"string"}]
GiftCertificateNumber
"""string"""

H

HoldCodeCategories
postput

Get the details of a Hold Code Category by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get HoldCodeCategories
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all Hold Code Categories. To get only the resources for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all Hold Code Categories.

HoldCodeUserGroups
postput

Get the details of a hold code/user group mapping by id.

Usage:
tq get HoldCodeUserGroups
Query:
{"HoldCodeUserGroupID":"string"}
[{"HoldCodeUserGroupID":"string"}]
HoldCodeUserGroupID
"""string"""

Flags:

  • --All
    Get all hold code/user group mappings. Optional filter for a UserGroup or HoldCode.
Query:
{"HoldCode":"string", "UserGroup":"string"}
[{"HoldCode":"string","UserGroup":"string"}]
HoldCode,UserGroup
"""string""","""string"""

  • --Summaries
    Get a summary representation of all hold code/user group mappings. Optional filter for a UserGroup or HoldCode.
Query:
{"HoldCode":"string", "UserGroup":"string"}
[{"HoldCode":"string","UserGroup":"string"}]
HoldCode,UserGroup
"""string""","""string"""

  • --Summary
    Get summary representation of a hold code/user group mapping by id.
Query:
{"HoldCodeUserGroupID":"string"}
[{"HoldCodeUserGroupID":"string"}]
HoldCodeUserGroupID
"""string"""

HoldCodes
postput

Get details of a Hold Code.

Usage:
tq get HoldCodes
Query:
{"HoldCodeID":"string"}
[{"HoldCodeID":"string"}]
HoldCodeID
"""string"""

Flags:

  • --All
    Get details of all Hold Codes.

I

InactiveReasons
postput

Get the details of an inactive reason by id.

Usage:
tq get InactiveReasons
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all inactive reasons. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all inactive reasons.

IntegrationDefaults
postput

Get the details of an Integration Default by id.

Usage:
tq get IntegrationDefaults
Query:
{"ID":"string"}
[{"ID":"string"}]
ID
"""string"""

Flags:

  • --All
    Get all Integration Defaults. 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.
  • --Summaries
    Get a summary representation of all Integration Defaults.

Integrations
postput

Get the details of an action type by id.

Usage:
tq get Integrations
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all action types. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all action types.

InterestCategories
postput

Get the details of an interest category by id.

Usage:
tq get InterestCategories
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all interest categories. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all interest categories.

InterestTypes
postput

Get the details of an interest type by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get InterestTypes
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all interest types. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all interest types.

Interests
postput

Get details of an interest.

Usage:
tq get Interests
Query:
{"InterestID":"string"}
[{"InterestID":"string"}]
InterestID
"""string"""

Flags:

  • --All
    Get all the interests of the specified constituent id. To exclude attributes of the visible affiliations pass includeAffiliations=false. To filter the interests of specific categories pass comma separted values under categories.
Query:
{"CategoryIds":"string", "ConstituentID":"string", "IncludeAffiliations":"string"}
[{"CategoryIds":"string","ConstituentID":"string","IncludeAffiliations":"string"}]
CategoryIds,ConstituentID,IncludeAffiliations
"""string""","""string""","""string"""

Internal
postput

Get details of an address and all the phones attached to it.

Usage:
tq get Internal
Query:
{"AddressID":"string"}
[{"AddressID":"string"}]
AddressID
"""string"""

Flags:

  • --All
    Get details of all the addresses and the phones attached to them of the constituent id. To exclude addresses and the phones of the visible affiliations pass includeAffiliations=false.
Query:
{"ConstituentID":"string", "IncludeAffiliations":"string", "IncludeFromAffiliations":"string"}
[{"ConstituentID":"string","IncludeAffiliations":"string","IncludeFromAffiliations":"string"}]
ConstituentID,IncludeAffiliations,IncludeFromAffiliations
"""string""","""string""","""string"""

  • --ConstituentMiniSnapshot
    Get constituent details along with primary address, primary salutation, primary electronic address, primary & general phones.
Query:
{"ConstituentID":"string"}
[{"ConstituentID":"string"}]
ConstituentID
"""string"""

InventoryContactPermissionTypes
postput

Get details of an inventoryContactPermissionType.

Usage:
tq get InventoryContactPermissionTypes
Query:
{"InventoryContactPermissionTypeID":"string"}
[{"InventoryContactPermissionTypeID":"string"}]
InventoryContactPermissionTypeID
"""string"""

Flags:

  • --All
    Get details of all the Contact Permission Types associated to Production Seasons. Inventory Contact Permission Type is a mapping of a Contact Permission Type to a Production Season.
Query:
{"ProductionSeasonIds":"string"}
[{"ProductionSeasonIds":"string"}]
ProductionSeasonIds
"""string"""

InventoryWebContents
postput

Get details of an inventoryWebContent.

Usage:
tq get InventoryWebContents
Query:
{"InventoryWebContentID":"string"}
[{"InventoryWebContentID":"string"}]
InventoryWebContentID
"""string"""

Flags:

  • --All
    Get details of all the inventoryWebContents.
Query:
{"ContentTypeIds":"string", "ProductionElementIds":"string"}
[{"ContentTypeIds":"string","ProductionElementIds":"string"}]
ContentTypeIds,ProductionElementIds
"""string""","""string"""

  • --AllSummaries
    Get details of all the inventoryWebContents.
Query:
{"ContentTypeIds":"string", "ProductionElementIds":"string"}
[{"ContentTypeIds":"string","ProductionElementIds":"string"}]
ContentTypeIds,ProductionElementIds
"""string""","""string"""

InvoiceBilling
post

Get status of a processing automated billing run.

Usage:
tq get InvoiceBilling
Query:
{"ID":"string"}
[{"ID":"string"}]
ID
"""string"""

Issues
postput

Get details of a customer issue.

Usage:
tq get Issues
Query:
{"IssueID":"string"}
[{"IssueID":"string"}]
IssueID
"""string"""

Flags:

  • --All
    Get all the details of all the issues for the specified constituent id. If you want to filter the issues based on date pass in the values for 'startDate' and 'endDate'. If you want to filter issues based on contact type, category, activity type, origin, performance number or package number pass in the corresponding values in comma separated values.
Query:
{"ActivityTypeIds":"string", "CategoryIds":"string", "ConstituentID":"string", "ContactTypeIds":"string", "EndDate":"string", "IncludeAffiliations":"string", "OriginIds":"string", "PackageIds":"string", "PerformanceIds":"string", "Resolved":"string", "StartDate":"string"}
[{"ActivityTypeIds":"string","CategoryIds":"string","ConstituentID":"string","ContactTypeIds":"string","EndDate":"string","IncludeAffiliations":"string","OriginIds":"string","PackageIds":"string","PerformanceIds":"string","Resolved":"string","StartDate":"string"}]
ActivityTypeIds,CategoryIds,ConstituentID,ContactTypeIds,EndDate,IncludeAffiliations,OriginIds,PackageIds,PerformanceIds,Resolved,StartDate
"""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string"""

K

KeywordCategories
postput

Get the details of a keyword category by id.

Usage:
tq get KeywordCategories
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all keyword categories. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all keyword categories.

Keywords
postput

Get the details of a keyword by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get Keywords
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all keywords. To get only the resources for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --DataFor
    Gets potential values for a Keyword as KeywordDataItems.
Query:
{"KeywordID":"string"}
[{"KeywordID":"string"}]
KeywordID
"""string"""

  • --Summaries
    Get a summary representation of all keywords.

L

Languages
postput

Get the details of a language by id.

Usage:
tq get Languages
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all languages. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all languages.

ListCategories
postput

Get the details of a list category by id.

Usage:
tq get ListCategories
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all list categories. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all list categories.

Lists
postput

Get a single List without contents.

Usage:
tq get Lists
Query:
{"ListID":"string"}
[{"ListID":"string"}]
ListID
"""string"""

Flags:

  • --Contents
    Gets Constituent ids for the contents of a List.
Query:
{"ListID":"string"}
[{"ListID":"string"}]
ListID
"""string"""

  • --ContentsDetail
    Gets Constituent details for the contents of a List.
Query:
{"ListID":"string"}
[{"ListID":"string"}]
ListID
"""string"""

  • --ListCriterionMatchReasons
    Returns list criteria match reasons for a constituent in a list.
Query:
{"ConstituentID":"string", "ListID":"string"}
[{"ConstituentID":"string","ListID":"string"}]
ConstituentID,ListID
"""string""","""string"""

  • --Summaries
    Get a summary of all Lists.
Query:
{"ListIds":"string"}
[{"ListIds":"string"}]
ListIds
"""string"""

LoginTypes
postput

Get the details of a login type by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get LoginTypes
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all login types. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all login types.

M

MachineSettings
postput

Get the details of a Machine Setting by id. To get the resource in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get MachineSettings
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get details of all Machine Settings. To get them in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all Machine Settings.

MailIndicators
postput

Get the details of a mail indicator by id.

Usage:
tq get MailIndicators
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all mail indicators. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all mail indicators.

MediaTypes
postput

Get the details of a media type by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get MediaTypes
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all media types. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all media types.

MembershipLevelCategories
postput

Get the details of a membership level category by id.

Usage:
tq get MembershipLevelCategories
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all membership level categories. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all membership level categories.

MembershipLevels

Get a specific membership level. NOTE: As part of the upcoming changes to membership functionality, this resource will be removed in an upcoming major Tessitura release. Please make a note that code that references it will need to be revisited as part of that upgrade process.

Usage:
tq get MembershipLevels
Query:
{"MembershipLevelID":"string"}
[{"MembershipLevelID":"string"}]
MembershipLevelID
"""string"""

Flags:

  • --All
    Get a summary list of all membership levels. MembershipOrgId is required. NOTE: As part of the upcoming changes to membership functionality, this resource will be removed in an upcoming major Tessitura release. Please make a note that code that references it will need to be revisited as part of that upgrade process.
Query:
{"MembershipOrgID":"string"}
[{"MembershipOrgID":"string"}]
MembershipOrgID
"""string"""

  • --Summaries
    Get a list of membership levels. MembershipOrgId is required. NOTE: As part of the upcoming changes to membership functionality, this resource will be removed in an upcoming major Tessitura release. Please make a note that code that references it will need to be revisited as part of that upgrade process.
Query:
{"MembershipOrgID":"string"}
[{"MembershipOrgID":"string"}]
MembershipOrgID
"""string"""

MembershipOrganizations

Get a specific membership organization. NOTE: As part of the upcoming changes to membership functionality, this resource will be removed in an upcoming major Tessitura release. Please make a note that code that references it will need to be revisited as part of that upgrade process.

Usage:
tq get MembershipOrganizations
Query:
{"ID":"string"}
[{"ID":"string"}]
ID
"""string"""

Flags:

  • --All
    Get a list of all membership organizations. NOTE: As part of the upcoming changes to membership functionality, this resource will be removed in an upcoming major Tessitura release. Please make a note that code that references it will need to be revisited as part of that upgrade process.
  • --Summaries
    Get a list of all membership organizations in summary. NOTE: As part of the upcoming changes to membership functionality, this resource will be removed in an upcoming major Tessitura release. Please make a note that code that references it will need to be revisited as part of that upgrade process.

MembershipStandings

Get a specific MembershipStanding by id.

Usage:
tq get MembershipStandings
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all Membership Standings.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all MembershipStandings.

Memberships
post

Returns membership details for a constituent. NOTE: As part of the upcoming changes to membership functionality, this resource will change significantly in an upcoming major Tessitura release and likely break code that references it. Please make a note that code that references it will need to be revisited as part of that upgrade process.

Usage:
tq get Memberships
Query:
{"ConstituentID":"string", "IncludeAffiliations":"string", "MembershipOrgIds":"string", "OnlyShowCurrent":"string", "OnlyShowDefault":"string"}
[{"ConstituentID":"string","IncludeAffiliations":"string","MembershipOrgIds":"string","OnlyShowCurrent":"string","OnlyShowDefault":"string"}]
ConstituentID,IncludeAffiliations,MembershipOrgIds,OnlyShowCurrent,OnlyShowDefault
"""string""","""string""","""string""","""string""","""string"""

MerchantReferences

Usage:
tq get MerchantReferences
Query:
{"MerchantAccount":"string", "PaymentID":"string"}
[{"MerchantAccount":"string","PaymentID":"string"}]
MerchantAccount,PaymentID
"""string""","""string"""

Merchants

Retrieve Merchant List

Usage:
tq get Merchants
Query:



ModeOfSaleCategories
postput

Get details of a mode of sale category.

Usage:
tq get ModeOfSaleCategories
Query:
{"ModeOfSaleCategoryID":"string"}
[{"ModeOfSaleCategoryID":"string"}]
ModeOfSaleCategoryID
"""string"""

Flags:

  • --All
    Get all mode of sale categories.

ModeOfSaleOffers
postput

Get details of a mode of sale offer.

Usage:
tq get ModeOfSaleOffers
Query:
{"ModeOfSaleOfferID":"string"}
[{"ModeOfSaleOfferID":"string"}]
ModeOfSaleOfferID
"""string"""

Flags:

  • --All
    Get all mode of sale offers. The mode of sale id, performace ids, or package ids is required. Performance ids and package ids used together will return no results.
Query:
{"AsOfDateTime":"string", "ModeOfSaleID":"string", "PackageIds":"string", "PerformanceIds":"string"}
[{"AsOfDateTime":"string","ModeOfSaleID":"string","PackageIds":"string","PerformanceIds":"string"}]
AsOfDateTime,ModeOfSaleID,PackageIds,PerformanceIds
"""string""","""string""","""string""","""string"""

ModeOfSalePriceTypes
postput

Get details of a mode of sale price type.

Usage:
tq get ModeOfSalePriceTypes
Query:
{"ModeOfSalePriceTypeID":"string"}
[{"ModeOfSalePriceTypeID":"string"}]
ModeOfSalePriceTypeID
"""string"""

Flags:

  • --All
    Get all mode of sale price types.
Query:
{"ModeOfSaleID":"string", "PriceTypeID":"string"}
[{"ModeOfSaleID":"string","PriceTypeID":"string"}]
ModeOfSaleID,PriceTypeID
"""string""","""string"""

ModeOfSaleSurveyQuestions
postput

Get details of a mode of sale survey question.

Usage:
tq get ModeOfSaleSurveyQuestions
Query:
{"ModeOfSaleSurveyQuestionID":"string"}
[{"ModeOfSaleSurveyQuestionID":"string"}]
ModeOfSaleSurveyQuestionID
"""string"""

Flags:

  • --All
    Get all mode of sale survey questions.
Query:
{"ModeOfSaleID":"string"}
[{"ModeOfSaleID":"string"}]
ModeOfSaleID
"""string"""

ModeOfSaleUserGroups
postput

Get the details of a mode of sale/user group mapping by id.

Usage:
tq get ModeOfSaleUserGroups
Query:
{"ModeOfSaleUserGroupID":"string"}
[{"ModeOfSaleUserGroupID":"string"}]
ModeOfSaleUserGroupID
"""string"""

Flags:

  • --All
    Get all mode of sale/user group mappings.

ModesOfSale
postput

Get details of an existing mode of sale.

Usage:
tq get ModesOfSale
Query:
{"ModeOfSaleID":"string"}
[{"ModeOfSaleID":"string"}]
ModeOfSaleID
"""string"""

Flags:

  • --All
    Get all modes of sale.
  • --Summaries
    Get summary of all modes of sale.

N

NScanAccessAreas
postput

Get the details of an NScan Access Area by id. To get the resource only if the user has write/edit access, pass filter="writeonly".. To get the resource in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get NScanAccessAreas
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get details of all NScan Access Areas. To get only the resources for which the user has write/edit access, pass filter="writeonly". To get them in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all NScan Access Areas.

NameStatuses
postput

Get the details of a name status by id.

Usage:
tq get NameStatuses
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all name statuses. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all name statuses.

O

ObjectPermissions
postput

Get the details of an object permission by id.

Usage:
tq get ObjectPermissions
Query:
{"ID":"string"}
[{"ID":"string"}]
ID
"""string"""

Flags:

  • --All
    Get all object permissions.
  • --Summaries
    Get a summary representation of all object permissions.

OrderBilling
post

Reprint Order billing

Usage:
tq get OrderBilling
Query:
{"OrderBillingID":"string"}
[{"OrderBillingID":"string"}]
OrderBillingID
"""string"""

Flags:

  • --Status
    Get status of a processing automated billing run.
Query:
{"OrderBillingID":"string"}
[{"OrderBillingID":"string"}]
OrderBillingID
"""string"""

OrderCategories
postput

Get the details of an order category by id.

Usage:
tq get OrderCategories
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all order categories. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all order categories.

Orders
postput

Get the details of an existing Order as the contract OrderProductsView, which mirrors the structure of the Cart response entity from GET Web/{sessionKey}/Cart. This resource can be used to fetch any saved order in this view. Order HTML templates use this response contract (OrdersProductsView) as the model within the template. Orders actively in a session/cart will not be available here until after checkout.

Usage:
tq get Orders
Query:
{"OrderID":"string"}
[{"OrderID":"string"}]
OrderID
"""string"""

Organizations
postput

Get the details of an organization by ID. To get the resource in maintenance mode (ignoring control groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get Organizations
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all organizations. To get the resources in maintenance mode (ignoring control groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all organizations.

OriginalSources
postput

Get the details of an original source by id.

Usage:
tq get OriginalSources
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all original sources. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all original sources.

Origins
postput

Get the details of an origin by id.

Usage:
tq get Origins
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all origins. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all origins.

OutputSets
postput

Get a single Output Set.

Usage:
tq get OutputSets
Query:
{"OutputSetID":"string"}
[{"OutputSetID":"string"}]
OutputSetID
"""string"""

Flags:

  • --Summaries
    Get a summary of all Output Sets.
Query:
{"MineOnly":"string"}
[{"MineOnly":"string"}]
MineOnly
"""string"""

P

PackageHistory

Gets history information for packages

Usage:
tq get PackageHistory
Query:
{"ConstituentID":"string", "IncludeAffiliations":"string", "OrderEndDate":"string", "OrderStartDate":"string", "PackageID":"string", "PackageTypeID":"string", "SeasonID":"string"}
[{"ConstituentID":"string","IncludeAffiliations":"string","OrderEndDate":"string","OrderStartDate":"string","PackageID":"string","PackageTypeID":"string","SeasonID":"string"}]
ConstituentID,IncludeAffiliations,OrderEndDate,OrderStartDate,PackageID,PackageTypeID,SeasonID
"""string""","""string""","""string""","""string""","""string""","""string""","""string"""

PackagePriceTypes
postput

Get details of a specific package price type.

Usage:
tq get PackagePriceTypes
Query:
{"PackagePriceTypeID":"string"}
[{"PackagePriceTypeID":"string"}]
PackagePriceTypeID
"""string"""

Flags:

  • --All
    Get all package price types.
Query:
{"PackageIds":"string"}
[{"PackageIds":"string"}]
PackageIds
"""string"""

PackageTypes
postput

Get the details of a package type by id.

Usage:
tq get PackageTypes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all package types. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all package types.

PackageWebContents
postput

Get details of a packageWebContent.

Usage:
tq get PackageWebContents
Query:
{"PackageWebContentID":"string"}
[{"PackageWebContentID":"string"}]
PackageWebContentID
"""string"""

Flags:

  • --All
    Get full package web contents for passed packageIds or contentTypeIds. At least on parameter value is required. For production element web contents, use TXN/InventoryWebContents. To filter based on useWebAPI flag on content type and other parameters, use Txn/WebContents. This is mainly used for PackageWebContent setup.
Query:
{"ContentTypeIds":"string", "PackageIds":"string"}
[{"ContentTypeIds":"string","PackageIds":"string"}]
ContentTypeIds,PackageIds
"""string""","""string"""

  • --AllSummaries
    Get summary package web contents for passed packageIds and contentTypeIds. At least on parameter value is required. For production element web contents, use TXN/InventoryWebContents. To filter based on useWebAPI flag on content type and other parameters, use Txn/WebContents. This is mainly used for PackageWebContent setup.
Query:
{"ContentTypeIds":"string", "PackageIds":"string"}
[{"ContentTypeIds":"string","PackageIds":"string"}]
ContentTypeIds,PackageIds
"""string""","""string"""

Packages
post

Get details of a package.

Usage:
tq get Packages
Query:
{"PackageID":"string"}
[{"PackageID":"string"}]
PackageID
"""string"""

Flags:

  • --All
    Get all packages filtered by a selected season.
Query:
{"SeasonID":"string"}
[{"SeasonID":"string"}]
SeasonID
"""string"""

  • --PackageDetail
    Gets detailed information about the package including sub packages and performance groups.
Query:
{"AsOfDateTime":"string", "ModeOfSaleID":"string", "PackageID":"string", "PriceTypeID":"string", "SourceID":"string"}
[{"AsOfDateTime":"string","ModeOfSaleID":"string","PackageID":"string","PriceTypeID":"string","SourceID":"string"}]
AsOfDateTime,ModeOfSaleID,PackageID,PriceTypeID,SourceID
"""string""","""string""","""string""","""string""","""string"""

  • --PerformanceGroupDetails
    Get details of Performance Groups and their Performances for flex package selection.
Query:
{"AsOfDateTime":"string", "ModeOfSaleID":"string", "PackageID":"string", "PriceTypeID":"string", "SourceID":"string"}
[{"AsOfDateTime":"string","ModeOfSaleID":"string","PackageID":"string","PriceTypeID":"string","SourceID":"string"}]
AsOfDateTime,ModeOfSaleID,PackageID,PriceTypeID,SourceID
"""string""","""string""","""string""","""string""","""string"""

  • --Prices
    Get the package and its pricing details. Mode Of Sale and Price Type parameters can be used to filter the returned prices.
Query:
{"AsOfDateTime":"string", "ExpandPerformancePriceType":"string", "IncludeOnlyBasePrice":"string", "ModeOfSaleID":"string", "PackageID":"string", "PerformanceIds":"string", "PriceTypeID":"string", "SourceID":"string"}
[{"AsOfDateTime":"string","ExpandPerformancePriceType":"string","IncludeOnlyBasePrice":"string","ModeOfSaleID":"string","PackageID":"string","PerformanceIds":"string","PriceTypeID":"string","SourceID":"string"}]
AsOfDateTime,ExpandPerformancePriceType,IncludeOnlyBasePrice,ModeOfSaleID,PackageID,PerformanceIds,PriceTypeID,SourceID
"""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string"""

  • --SeatFees
    Returns price, per seat fees, for each zone and price type for the specified package.
Query:
{"AsOfDateTime":"string", "ModeOfSaleID":"string", "PackageID":"string", "PriceTypeIds":"string"}
[{"AsOfDateTime":"string","ModeOfSaleID":"string","PackageID":"string","PriceTypeIds":"string"}]
AsOfDateTime,ModeOfSaleID,PackageID,PriceTypeIds
"""string""","""string""","""string""","""string"""

  • --SeatSummaries
    Returns summary for seats in a package. Seat availability is summarized by screen, section and zone. The seats returned can be filtered by screen, section, or price zone. Allocation is returned based on MOS and constituent. Available seats can be filtered by price type availability, causing any seats that are not available for the specified price types to be listed with a status of 5, Not In Allocation.
Query:
{"CheckPriceTypeIds":"string", "ConstituentID":"string", "ModeOfSaleID":"string", "PackageID":"string", "ScreenIds":"string", "SectionIds":"string", "ZoneIds":"string"}
[{"CheckPriceTypeIds":"string","ConstituentID":"string","ModeOfSaleID":"string","PackageID":"string","ScreenIds":"string","SectionIds":"string","ZoneIds":"string"}]
CheckPriceTypeIds,ConstituentID,ModeOfSaleID,PackageID,ScreenIds,SectionIds,ZoneIds
"""string""","""string""","""string""","""string""","""string""","""string""","""string"""

  • --Seats
    Returns details for seats in a fixed-seat package. The seats returned can be filtered by screen, section, or price zone. Allocation is returned based on MOS and constituent. Available seats can be filtered by price type availability, causing any seats that are not available for the specified price types to be listed with a status of 5, Not In Allocation.
Query:
{"CheckPriceTypeIds":"string", "ConstituentID":"string", "ModeOfSaleID":"string", "PackageID":"string", "ReturnNonSeats":"string", "ScreenIds":"string", "SectionIds":"string", "ZoneIds":"string"}
[{"CheckPriceTypeIds":"string","ConstituentID":"string","ModeOfSaleID":"string","PackageID":"string","ReturnNonSeats":"string","ScreenIds":"string","SectionIds":"string","ZoneIds":"string"}]
CheckPriceTypeIds,ConstituentID,ModeOfSaleID,PackageID,ReturnNonSeats,ScreenIds,SectionIds,ZoneIds
"""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string"""

  • --Summaries
    Get summary of all packages filtered by a selected season.
Query:
{"SeasonID":"string"}
[{"SeasonID":"string"}]
SeasonID
"""string"""

PaymentGatewayActivities
postput

Get a single Payment Gateway Activity

Usage:
tq get PaymentGatewayActivities
Query:
{"PaymentGatewayActivityID":"string"}
[{"PaymentGatewayActivityID":"string"}]
PaymentGatewayActivityID
"""string"""

Flags:

  • --All
    Retrieve all Payment Gateway Activity

PaymentGatewayConfiguration

Retrieve Payment Gateway Configuration

Usage:
tq get PaymentGatewayConfiguration
Query:



PaymentGatewayNotifications
postput

Get all notification events by reference.

Usage:
tq get PaymentGatewayNotifications
Query:
{"NotificationType":"string", "Reference":"string"}
[{"NotificationType":"string","Reference":"string"}]
NotificationType,Reference
"""string""","""string"""

Flags:

  • --Check
Query:
{"MerchantReference":"string", "SinceDateTime":"string"}
[{"MerchantReference":"string","SinceDateTime":"string"}]
MerchantReference,SinceDateTime
"""string""","""string"""

  • --Notification
    Retrieve notification events from Tessitura Merchant Services for a given merchant (PSP) reference.
Query:
{"MerchantReference":"string"}
[{"MerchantReference":"string"}]
MerchantReference
"""string"""

  • --NotificationEvent
    Get notification event by Id.
Query:
{"NotificationEventID":"string"}
[{"NotificationEventID":"string"}]
NotificationEventID
"""string"""

PaymentGatewayTransactionTypes
postput

Get the details of a Payment Gateway Transaction Type by id. To get the resource in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get PaymentGatewayTransactionTypes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get details of all Payment Gateway Transaction Types. To get them in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all Payment Gateway Transaction Types.

PaymentHistory

Gets history information for payments by constituent.

Usage:
tq get PaymentHistory
Query:
{"ConstituentID":"string", "EndDate":"string", "IncludeAffiliates":"string", "Page":"string", "PageSize":"string", "PaymentTypeID":"string", "SortByDirection":"string", "SortByField":"string", "StartDate":"string", "TransactionID":"string"}
[{"ConstituentID":"string","EndDate":"string","IncludeAffiliates":"string","Page":"string","PageSize":"string","PaymentTypeID":"string","SortByDirection":"string","SortByField":"string","StartDate":"string","TransactionID":"string"}]
ConstituentID,EndDate,IncludeAffiliates,Page,PageSize,PaymentTypeID,SortByDirection,SortByField,StartDate,TransactionID
"""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string"""

PaymentMethodGroups
postput

Get the details of a payment method group by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get PaymentMethodGroups
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all payment method groups. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all payment method groups.

PaymentMethodUserGroups
postput

Get details of a payment method/user group mapping by id.

Usage:
tq get PaymentMethodUserGroups
Query:
{"PaymentMethodUserGroupID":"string"}
[{"PaymentMethodUserGroupID":"string"}]
PaymentMethodUserGroupID
"""string"""

Flags:

  • --All
    Get all payment method/user group mappings. Optional filter on UserGroup, Amount and MaintenanceMode (which overrides the filter on UserGroup)
Query:
{"Amount":"string", "MaintenanceMode":"string", "UserGroup":"string"}
[{"Amount":"string","MaintenanceMode":"string","UserGroup":"string"}]
Amount,MaintenanceMode,UserGroup
"""string""","""string""","""string"""

PaymentMethods
postput

Get details of a payment method.

Usage:
tq get PaymentMethods
Query:
{"PaymentMethodID":"string"}
[{"PaymentMethodID":"string"}]
PaymentMethodID
"""string"""

Flags:

  • --All
    Get all payment methods. This resource looks similar to referenceData resources, but is functionally different. When maintenanceMode is false, control groups are considered when returning payment methods. The default for maintenanceMode is false. This endpoint should not generally be used for transaction based screens because it does not account for assigned payment methods based on user group security. For cart available payment methods, consider Security/PaymentMethods?amount={amount}.
Query:
{"MaintenanceMode":"string", "PaymentTypeIds":"string"}
[{"MaintenanceMode":"string","PaymentTypeIds":"string"}]
MaintenanceMode,PaymentTypeIds
"""string""","""string"""

  • --Check
    Check PaymentMethod setup for EMV or Hosted Payment charges.
Query:
{"CardReaderTypeID":"string"}
[{"CardReaderTypeID":"string"}]
CardReaderTypeID
"""string"""

  • --TranslateMnemonic
    Translate a card mnemonic into the matching system PaymentMethod or the default fallback PaymentMethod for that CardReaderType
Query:
{"CardReaderTypeID":"string", "Mnemonic":"string"}
[{"CardReaderTypeID":"string","Mnemonic":"string"}]
CardReaderTypeID,Mnemonic
"""string""","""string"""

PaymentSignatures
postput

Get details of a payment signature.

Usage:
tq get PaymentSignatures
Query:
{"PaymentSignatureID":"string"}
[{"PaymentSignatureID":"string"}]
PaymentSignatureID
"""string"""

Flags:

  • --All
    Get all payment signatures.
Query:
{"PaymentID":"string"}
[{"PaymentID":"string"}]
PaymentID
"""string"""

PaymentTypes
postput

Get the details of a payment type by id.

Usage:
tq get PaymentTypes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all payment types. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all payment types.

Payments
post

Get a single payment.

Usage:
tq get Payments
Query:
{"ID":"string"}
[{"ID":"string"}]
ID
"""string"""

Flags:

  • --All
    Get payments for a specified referenceId (order or contribution id).
Query:
{"ReferenceID":"string"}
[{"ReferenceID":"string"}]
ReferenceID
"""string"""

  • --AvailableForRefund
    Retrieve cc payments available for refund by processor reference number
Query:
{"OrderIdsOrContributionIds":"string"}
[{"OrderIdsOrContributionIds":"string"}]
OrderIdsOrContributionIds
"""string"""

  • --OnAccountBalances
    Gets a constituent's balance(s) for on-account payment methods
Query:
{"ConstituentID":"string", "PaymentMethodID":"string"}
[{"ConstituentID":"string","PaymentMethodID":"string"}]
ConstituentID,PaymentMethodID
"""string""","""string"""

PerformanceGroups
postput

Get details of a Performance Group.

Usage:
tq get PerformanceGroups
Query:
{"ID":"string"}
[{"ID":"string"}]
ID
"""string"""

Flags:

  • --All
    Get all performance groups.
Query:
{"SeasonID":"string"}
[{"SeasonID":"string"}]
SeasonID
"""string"""

  • --Summaries
    Get a summary representation of all performance groups.
Query:
{"SeasonID":"string"}
[{"SeasonID":"string"}]
SeasonID
"""string"""

PerformancePackageModeOfSales
postput

Get details of a performance package mode of sale.

Usage:
tq get PerformancePackageModeOfSales
Query:
{"PerformancePackageModeOfSaleID":"string"}
[{"PerformancePackageModeOfSaleID":"string"}]
PerformancePackageModeOfSaleID
"""string"""

Flags:

  • --All
    Get all performance package mode of sales. This entity shows the Mode of Sale assignment to either a package or a performance. Filter using at least one parameter. All parameters work to filter the result set collectively, so passing packageIds and performanceIds in the same request will retrieve no rows.
Query:
{"AsOfDateTime":"string", "ModeOfSaleID":"string", "PackageIds":"string", "PerformanceIds":"string"}
[{"AsOfDateTime":"string","ModeOfSaleID":"string","PackageIds":"string","PerformanceIds":"string"}]
AsOfDateTime,ModeOfSaleID,PackageIds,PerformanceIds
"""string""","""string""","""string""","""string"""

PerformancePriceLayers
postput

Get details of a performance price layer.

Usage:
tq get PerformancePriceLayers
Query:
{"AsOfDateTime":"string", "PerformancePriceLayerID":"string"}
[{"AsOfDateTime":"string","PerformancePriceLayerID":"string"}]
AsOfDateTime,PerformancePriceLayerID
"""string""","""string"""

Flags:

  • --Counts
    Get count of performance price layers for a set of performances.
Query:
{"PerformanceIds":"string"}
[{"PerformanceIds":"string"}]
PerformanceIds
"""string"""

  • --PriceCount
    Gets the total count of price objects that will be collected when calling for the full price layer contract on these performanceIds.
Query:
{"PerformanceIds":"string"}
[{"PerformanceIds":"string"}]
PerformanceIds
"""string"""

PerformancePriceTypes
postput

Get details of a performance price type.

Usage:
tq get PerformancePriceTypes
Query:
{"AsOfDateTime":"string", "PerformancePriceTypeID":"string"}
[{"AsOfDateTime":"string","PerformancePriceTypeID":"string"}]
AsOfDateTime,PerformancePriceTypeID
"""string""","""string"""

Flags:

  • --All
    Get all performance price type for the list of performances. (Pass comma separated list of performance Ids as parameter)
Query:
{"AsOfDateTime":"string", "PerformanceIds":"string", "PriceTypeIds":"string"}
[{"AsOfDateTime":"string","PerformanceIds":"string","PriceTypeIds":"string"}]
AsOfDateTime,PerformanceIds,PriceTypeIds
"""string""","""string""","""string"""

PerformancePrices
postput

Get details of a performance price.

Usage:
tq get PerformancePrices
Query:
{"AsOfDateTime":"string", "PerformancePriceID":"string"}
[{"AsOfDateTime":"string","PerformancePriceID":"string"}]
AsOfDateTime,PerformancePriceID
"""string""","""string"""

Flags:

  • --All
    Get all performance prices for a set of performance price types. Pass in asOfDateTime to get prices effective for that date/time.
Query:
{"AsOfDateTime":"string", "PerformancePriceTypeIds":"string"}
[{"AsOfDateTime":"string","PerformancePriceTypeIds":"string"}]
AsOfDateTime,PerformancePriceTypeIds
"""string""","""string"""

  • --AllWithEvents
    Get details of a set of performance prices along with events associated with those prices.
Query:
{"PerformancePriceIds":"string"}
[{"PerformancePriceIds":"string"}]
PerformancePriceIds
"""string"""

  • --Audit
    Get the performance price audit entries for a set of performance prices.
Query:
{"PerformancePriceIds":"string"}
[{"PerformancePriceIds":"string"}]
PerformancePriceIds
"""string"""

PerformanceStatuses
postput

Get the details of a performance status by id.

Usage:
tq get PerformanceStatuses
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all performance statuses. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all performance statuses.

PerformanceTypes
postput

Get the details of a performance type by id.

Usage:
tq get PerformanceTypes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all performance types. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all performance types.

Performances
postput

Get details of a performance.

Usage:
tq get Performances
Query:
{"PerformanceID":"string"}
[{"PerformanceID":"string"}]
PerformanceID
"""string"""

Flags:

  • --All
    Get performance detail information For single production season, a comma separated list of performances, seasons, or a single production season. At least one filter parameter is required.
Query:
{"PerformanceIds":"string", "ProductionSeasonID":"string", "SeasonIds":"string"}
[{"PerformanceIds":"string","ProductionSeasonID":"string","SeasonIds":"string"}]
PerformanceIds,ProductionSeasonID,SeasonIds
"""string""","""string""","""string"""

  • --AuditEntries
    Audit log entries for changes to Performance properties such as descriptions, publish dates, and the production season. This does not include sub performance/event setup items like pricing or modes of sale.
Query:
{"Actions":"string", "Columns":"string", "EndDateTime":"string", "GreaterThanID":"string", "OrderByIDAsc":"string", "Page":"string", "PageSize":"string", "PerformanceIds":"string", "StartDateTime":"string", "Tables":"string"}
[{"Actions":"string","Columns":"string","EndDateTime":"string","GreaterThanID":"string","OrderByIDAsc":"string","Page":"string","PageSize":"string","PerformanceIds":"string","StartDateTime":"string","Tables":"string"}]
Actions,Columns,EndDateTime,GreaterThanID,OrderByIDAsc,Page,PageSize,PerformanceIds,StartDateTime,Tables
"""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string"""

  • --PerformanceZoneAvailabilities
    Get performance zone availability for a set of performances. If sectionIds are specified only zones with matching sections will be returned and the SectionSummaries node will be populated.
Query:
{"PerformanceIds":"string", "SectionIds":"string"}
[{"PerformanceIds":"string","SectionIds":"string"}]
PerformanceIds,SectionIds
"""string""","""string"""

  • --PerformanceZoneAvailabilityWithConstituent
    Get performance zone availability for a set of performances. If ConstituentId and MOS are provided, will also return availability based on allocations and constituent rank.
Query:
{"ConstituentID":"string", "ModeOfSaleID":"string", "PerformanceIds":"string"}
[{"ConstituentID":"string","ModeOfSaleID":"string","PerformanceIds":"string"}]
ConstituentID,ModeOfSaleID,PerformanceIds
"""string""","""string""","""string"""

  • --Prices
    Get pricing details for a set of performances. Mode Of Sale and Price Type parameters can be used to filter the returned prices.
Query:
{"AsOfDateTime":"string", "ExpandPerformancePriceType":"string", "IncludeOnlyBasePrice":"string", "ModeOfSaleID":"string", "PerformanceIds":"string", "PriceTypeID":"string", "SourceID":"string"}
[{"AsOfDateTime":"string","ExpandPerformancePriceType":"string","IncludeOnlyBasePrice":"string","ModeOfSaleID":"string","PerformanceIds":"string","PriceTypeID":"string","SourceID":"string"}]
AsOfDateTime,ExpandPerformancePriceType,IncludeOnlyBasePrice,ModeOfSaleID,PerformanceIds,PriceTypeID,SourceID
"""string""","""string""","""string""","""string""","""string""","""string""","""string"""

  • --SeatFees
    Returns price, per seat fees, for each zone and price type for a the specified performance
Query:
{"AsOfDateTime":"string", "ModeOfSaleID":"string", "PerformanceID":"string", "PriceTypeIds":"string"}
[{"AsOfDateTime":"string","ModeOfSaleID":"string","PerformanceID":"string","PriceTypeIds":"string"}]
AsOfDateTime,ModeOfSaleID,PerformanceID,PriceTypeIds
"""string""","""string""","""string""","""string"""

  • --SeatHoldDetails
    Get seat holds for a performance
Query:
{"HoldCodeIds":"string", "IncludeAllHolds":"string", "PerformanceID":"string", "SeatIds":"string"}
[{"HoldCodeIds":"string","IncludeAllHolds":"string","PerformanceID":"string","SeatIds":"string"}]
HoldCodeIds,IncludeAllHolds,PerformanceID,SeatIds
"""string""","""string""","""string""","""string"""

  • --SeatSummaries
    Returns summary for seats in a performance Seat availability is summarized by screen, section and zone. The seats returned can be filtered by screen, section, or price zone. Allocation is returned based on MOS and constituent. Available seats can be filtered by price type availability, causing any seats that are not available for the specified price types to be listed with a status of 5, Not In Allocation.
Query:
{"CheckPriceTypeIds":"string", "ConstituentID":"string", "ModeOfSaleID":"string", "PerformanceID":"string", "ScreenIds":"string", "SectionIds":"string", "ZoneIds":"string"}
[{"CheckPriceTypeIds":"string","ConstituentID":"string","ModeOfSaleID":"string","PerformanceID":"string","ScreenIds":"string","SectionIds":"string","ZoneIds":"string"}]
CheckPriceTypeIds,ConstituentID,ModeOfSaleID,PerformanceID,ScreenIds,SectionIds,ZoneIds
"""string""","""string""","""string""","""string""","""string""","""string""","""string"""

  • --Seats
    Returns details for seats in a performance The seats returned can be filtered by screen, section, or price zone. Allocation is returned based on MOS and constituent. Available seats can be filtered by price type availability, causing any seats that are not available for the specified price types to be listed with a status of 5, Not In Allocation.
Query:
{"CheckPriceTypeIds":"string", "ConstituentID":"string", "ModeOfSaleID":"string", "PerformanceID":"string", "ReturnNonSeats":"string", "ScreenIds":"string", "SectionIds":"string", "ZoneIds":"string"}
[{"CheckPriceTypeIds":"string","ConstituentID":"string","ModeOfSaleID":"string","PerformanceID":"string","ReturnNonSeats":"string","ScreenIds":"string","SectionIds":"string","ZoneIds":"string"}]
CheckPriceTypeIds,ConstituentID,ModeOfSaleID,PerformanceID,ReturnNonSeats,ScreenIds,SectionIds,ZoneIds
"""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string"""

  • --Summaries
    Get Summary performance information For single production season, a comma separated list of performances, seasons, or a single production season. At least one filter parameter is required.
Query:
{"PerformanceIds":"string", "ProductionSeasonID":"string", "SeasonIds":"string"}
[{"PerformanceIds":"string","ProductionSeasonID":"string","SeasonIds":"string"}]
PerformanceIds,ProductionSeasonID,SeasonIds
"""string""","""string""","""string"""

Philanthropy
postput

Get details of an philanthropyEntry.

Usage:
tq get Philanthropy
Query:
{"PhilanthropyEntryID":"string"}
[{"PhilanthropyEntryID":"string"}]
PhilanthropyEntryID
"""string"""

Flags:

  • --All
    Get details of all the philanthropyEntries for the specified constituent id and all its visible affiliation's philanthropyEntries as well. To exclude philanthropyEntries of the visible affiliations pass includeAffiliations=false.
Query:
{"ConstituentID":"string", "IncludeAffiliations":"string"}
[{"ConstituentID":"string","IncludeAffiliations":"string"}]
ConstituentID,IncludeAffiliations
"""string""","""string"""

PhilanthropyTypes
postput

Get the details of philosophy type by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get PhilanthropyTypes
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all philosophy types. To get only the resources for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all philosophy types.

PhoneIndicators
postput

Get the details of a phone indicator by id.

Usage:
tq get PhoneIndicators
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all phone indicators. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all phone indicators.

PhoneTypes
postput

Get the details of a phone type by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get PhoneTypes
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all phone types. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all phone types.

Phones
postput

Get details of a phone.

Usage:
tq get Phones
Query:
{"PhoneID":"string"}
[{"PhoneID":"string"}]
PhoneID
"""string"""

Flags:

  • --All
    Get details of all the phones for the specified constituent (constituentId) and all its visible affiliation's phones as well or address (addressId). To exclude phones of the visible affiliations pass includeAffiliations=false. If addressId is passed, constituentId or includeAffiliations parameters are ignored. To Get the phones attached to the primary address pass primary=true.
Query:
{"AddressID":"string", "ConstituentID":"string", "IncludeAffiliations":"string", "PrimaryOnly":"string"}
[{"AddressID":"string","ConstituentID":"string","IncludeAffiliations":"string","PrimaryOnly":"string"}]
AddressID,ConstituentID,IncludeAffiliations,PrimaryOnly
"""string""","""string""","""string""","""string"""

PlanPriorities
postput

Get the details of a plan priority by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get PlanPriorities
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all plan priorities. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all plan priorities.

PlanSources
postput

Get the details of a plan source by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get PlanSources
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all plan sources. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all plan sources.

PlanStatuses
postput

Get the details of a plan status by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get PlanStatuses
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all plan statuses. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all plan statuses.

PlanTypes
postput

Get the details of a plan type by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get PlanTypes
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all plan types. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all plan types.

PlanWorkers
postput

Get details of a plan worker.

Usage:
tq get PlanWorkers
Query:
{"PlanWorkerID":"string"}
[{"PlanWorkerID":"string"}]
PlanWorkerID
"""string"""

Flags:

  • --All
    Get details of all the plan workers for the specified constituent.
Query:
{"PlanID":"string"}
[{"PlanID":"string"}]
PlanID
"""string"""

Plans
postput

Get details of a plan.

Usage:
tq get Plans
Query:
{"PlanID":"string"}
[{"PlanID":"string"}]
PlanID
"""string"""

Flags:

  • --All
    Get details of all the plans for the specified constituent, campaign, worker or fund.
Query:
{"CampaignID":"string", "ConstituentID":"string", "ContributionDesignationID":"string", "FundID":"string", "IncludeAffiliations":"string", "IncludeAssociates":"string", "ListID":"string", "OnlyNullFund":"string", "WorkerID":"string"}
[{"CampaignID":"string","ConstituentID":"string","ContributionDesignationID":"string","FundID":"string","IncludeAffiliations":"string","IncludeAssociates":"string","ListID":"string","OnlyNullFund":"string","WorkerID":"string"}]
CampaignID,ConstituentID,ContributionDesignationID,FundID,IncludeAffiliations,IncludeAssociates,ListID,OnlyNullFund,WorkerID
"""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string"""

PledgeBilling
post

Get status of a pledge billing run. Job is finished processing when IsCompleted is true. Only billing runs using automated billing will be running after the response from a POST to Txn/PledgeBilling.

Usage:
tq get PledgeBilling
Query:
{"ID":"string"}
[{"ID":"string"}]
ID
"""string"""

PortfolioCustomElements
postput

Get the details of a portfolio custom element by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get PortfolioCustomElements
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all portfolio custom elements. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all portfolio custom elements.

Portfolios

Get portfolio for a constituent.

Usage:
tq get Portfolios
Query:
{"ConstituentID":"string", "Page":"string", "PageSize":"string", "PlanCustomColumns":"string", "PortfolioCustomColumns":"string", "PrimaryOnly":"string", "StatusIds":"string", "WorkerRoleIds":"string"}
[{"ConstituentID":"string","Page":"string","PageSize":"string","PlanCustomColumns":"string","PortfolioCustomColumns":"string","PrimaryOnly":"string","StatusIds":"string","WorkerRoleIds":"string"}]
ConstituentID,Page,PageSize,PlanCustomColumns,PortfolioCustomColumns,PrimaryOnly,StatusIds,WorkerRoleIds
"""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string"""

Flags:

  • --PortfolioEntry
    Get details of a portfolio entry for a plan.
Query:
{"PlanID":"string"}
[{"PlanID":"string"}]
PlanID
"""string"""

Prefixes
postput

Get the details of a prefix by id.

Usage:
tq get Prefixes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all prefixes. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all prefixes.

Premieres
postput

Get the details of a premiere by id.

Usage:
tq get Premieres
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all premieres. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all premieres.

PriceCategories
postput

Get the details of a price category by id.

Usage:
tq get PriceCategories
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all price categories. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all price categories.

PriceEvents
put

Get details of a price event.

Usage:
tq get PriceEvents
Query:
{"PriceEventID":"string"}
[{"PriceEventID":"string"}]
PriceEventID
"""string"""

Flags:

  • --All
    Get all price events for a performance, performance price type or performance price detail. From and To Date parameters can be used to filter the events. If both are specified, then events between those dates would be returned. If only fromDate is specified then all events with a startDate greater than that date would be returned. If only toDate is specified then all events with a startDate less than that date would be returned.
Query:
{"FromDate":"string", "PerformanceIds":"string", "PerformancePriceIds":"string", "PerformancePriceLayerIds":"string", "PerformancePriceTypeIds":"string", "ToDate":"string"}
[{"FromDate":"string","PerformanceIds":"string","PerformancePriceIds":"string","PerformancePriceLayerIds":"string","PerformancePriceTypeIds":"string","ToDate":"string"}]
FromDate,PerformanceIds,PerformancePriceIds,PerformancePriceLayerIds,PerformancePriceTypeIds,ToDate
"""string""","""string""","""string""","""string""","""string""","""string"""

  • --Dates
    Gets a distinct set of dates that contain events for the given list of performances.
Query:
{"PerformanceIds":"string"}
[{"PerformanceIds":"string"}]
PerformanceIds
"""string"""

PriceLayerTypes
postput

Get the details of a price layer type by id.

Usage:
tq get PriceLayerTypes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all price layer types. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all price layer types.

PriceTemplates
postput

Get details of a price template.

Usage:
tq get PriceTemplates
Query:
{"PriceTemplateID":"string"}
[{"PriceTemplateID":"string"}]
PriceTemplateID
"""string"""

Flags:

  • --All
    Get all price templates. Optionally filtered by zoneMap and/or facility.
Query:
{"FacilityID":"string", "ZoneMapID":"string"}
[{"FacilityID":"string","ZoneMapID":"string"}]
FacilityID,ZoneMapID
"""string""","""string"""

  • --Summaries
    Get summary of all price templates. Optionally filtered by zoneMap and/or facility.
Query:
{"FacilityID":"string", "ZoneMapID":"string"}
[{"FacilityID":"string","ZoneMapID":"string"}]
FacilityID,ZoneMapID
"""string""","""string"""

PriceTypeCategories
postput

Get the details of a price type category by id.

Usage:
tq get PriceTypeCategories
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all price type categories. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all price type categories.

PriceTypeGroups
postput

Get the details of a price type group by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get PriceTypeGroups
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all price type groups. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all price type groups.

PriceTypeReasons
postput

Get the details of a price type reason by id.

Usage:
tq get PriceTypeReasons
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all price type reasons. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all price type categories.

PriceTypeUserGroups
postput

Get details of a price type/user group mapping by id.

Usage:
tq get PriceTypeUserGroups
Query:
{"PriceTypeUserGroupID":"string"}
[{"PriceTypeUserGroupID":"string"}]
PriceTypeUserGroupID
"""string"""

Flags:

  • --All
    Get all price type/user group mappings. Optional filter on UserGroup and PriceType.
Query:
{"PriceTypeID":"string", "UserGroup":"string"}
[{"PriceTypeID":"string","UserGroup":"string"}]
PriceTypeID,UserGroup
"""string""","""string"""

PriceTypes
postput

Get details of a price type.

Usage:
tq get PriceTypes
Query:
{"PriceTypeID":"string"}
[{"PriceTypeID":"string"}]
PriceTypeID
"""string"""

Flags:

  • --All
    Get all price types.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Reasons
    Gets valid price type reasons for the specified price type
Query:
{"PriceTypeID":"string"}
[{"PriceTypeID":"string"}]
PriceTypeID
"""string"""

  • --Summaries
    Get summary of all price types.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --ValidPriceTypes
    Get all valid price types for a performance/package and a mode of sale. A comma separated list of performance ids can be specified for a flex package.
Query:
{"ModeOfSaleID":"string", "OrderDateTime":"string", "PackageID":"string", "PerformanceIds":"string", "SourceID":"string"}
[{"ModeOfSaleID":"string","OrderDateTime":"string","PackageID":"string","PerformanceIds":"string","SourceID":"string"}]
ModeOfSaleID,OrderDateTime,PackageID,PerformanceIds,SourceID
"""string""","""string""","""string""","""string""","""string"""

  • --ValidZones
    Get valid zones for a set of performances or packages.
Query:
{"OrderDateTime":"string", "PackageID":"string", "PerformanceID":"string", "PriceTypeID":"string"}
[{"OrderDateTime":"string","PackageID":"string","PerformanceID":"string","PriceTypeID":"string"}]
OrderDateTime,PackageID,PerformanceID,PriceTypeID
"""string""","""string""","""string""","""string"""

PricingRuleCategories
postput

Get the details of a pricing rule category by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get PricingRuleCategories
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all pricing rule categories. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all pricing rule categories.

PricingRuleMessageTypes
postput

Get the details of a pricing rule message type by id.

Usage:
tq get PricingRuleMessageTypes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all pricing rule message types. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all pricing rule message types.

PricingRuleSets
postput

Get details of a pricing rule set.

Usage:
tq get PricingRuleSets
Query:
{"PricingRuleSetID":"string"}
[{"PricingRuleSetID":"string"}]
PricingRuleSetID
"""string"""

Flags:

  • --All
    Get all pricing rule sets.
  • --Summaries
    Get a summary of all pricing rule sets.

PricingRuleTypes

Get the details of a pricing rule type by id.

Usage:
tq get PricingRuleTypes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all pricing rule types. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all pricing rule types.

PricingRules
postput

Get details of a pricing rule.

Usage:
tq get PricingRules
Query:
{"PricingRuleID":"string"}
[{"PricingRuleID":"string"}]
PricingRuleID
"""string"""

Flags:

  • --All
    Gets all pricing rules or filtered set
Query:
{"ModeOfSaleID":"string", "OrderDate":"string", "PackageIds":"string", "PerformanceIds":"string"}
[{"ModeOfSaleID":"string","OrderDate":"string","PackageIds":"string","PerformanceIds":"string"}]
ModeOfSaleID,OrderDate,PackageIds,PerformanceIds
"""string""","""string""","""string""","""string"""

  • --AllSummary
    Get a summary of all pricing rules.

Printers
postput

Get the details of a printer by id.

Usage:
tq get Printers
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all printers. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all printers.

ProductKeywords

Returns keywords for the requested production elements or packages.

For Production Elements: If the keyword is found, returns the keyword and the lowest level at which it was found in the production hierarchy (Title, Production, Production Season, Performance) for the requested element. Optionally, all matching keywords anywhere above the requested element in the production hierarchy can be returned with the ShowAll parameter.

Usage:
tq get ProductKeywords
Query:
{"KeywordIds":"string", "PackageIds":"string", "ProductionElementIds":"string", "ShowAll":"string"}
[{"KeywordIds":"string","PackageIds":"string","ProductionElementIds":"string","ShowAll":"string"}]
KeywordIds,PackageIds,ProductionElementIds,ShowAll
"""string""","""string""","""string""","""string"""

ProductionSeasonMembershipOrganizations
postput

Get details of a specific production season membership organization.

Usage:
tq get ProductionSeasonMembershipOrganizations
Query:
{"ID":"string"}
[{"ID":"string"}]
ID
"""string"""

Flags:

  • --All
    Get all production season membership organizations for a production season.
Query:
{"ProductionSeasonID":"string"}
[{"ProductionSeasonID":"string"}]
ProductionSeasonID
"""string"""

  • --Summaries
    Get a summary of all production season membership organizations for a production season.
Query:
{"ProductionSeasonID":"string"}
[{"ProductionSeasonID":"string"}]
ProductionSeasonID
"""string"""

ProductionSeasons
post

Get details of a specific production season. Returns the full details for a single production season, including description and short description, season, first and last performance date, and the four ticket text lines.

Usage:
tq get ProductionSeasons
Query:
{"ID":"string"}
[{"ID":"string"}]
ID
"""string"""

Flags:

  • --All
    Get production season details. Returns the full details for multiple production seasons (based on a string of production IDs or season IDs), including description and short description, season, first and last performance date, and the four ticket text lines.
Query:
{"Ids":"string", "ProductionIds":"string", "SeasonIds":"string"}
[{"Ids":"string","ProductionIds":"string","SeasonIds":"string"}]
Ids,ProductionIds,SeasonIds
"""string""","""string""","""string"""

  • --Summaries
    Get production season summaries. Returns the production season summary (description, ID, and related production and season summaries) for all production seasons, all production seasons of a string of specific productions, or all production seasons in a string of specified seasons.
Query:
{"Ids":"string", "ProductionIds":"string", "SeasonIds":"string"}
[{"Ids":"string","ProductionIds":"string","SeasonIds":"string"}]
Ids,ProductionIds,SeasonIds
"""string""","""string""","""string"""

Productions

Get details of a specific production.

Usage:
tq get Productions
Query:
{"ID":"string"}
[{"ID":"string"}]
ID
"""string"""

Flags:

  • --All
    Get all productions, Optionally filtered by one or more titles.
Query:
{"TitleIds":"string"}
[{"TitleIds":"string"}]
TitleIds
"""string"""

  • --Summaries
    Get all production summaries, Optionally filtered by one or more titles.
Query:
{"TitleIds":"string"}
[{"TitleIds":"string"}]
TitleIds
"""string"""

ProgramListings
postput

Get details of a program listing.

Usage:
tq get ProgramListings
Query:
{"ProgramListingID":"string"}
[{"ProgramListingID":"string"}]
ProgramListingID
"""string"""

Flags:

  • --All
    Get details of all the program listings for the specified constituent id and all its visible affiliation's program listings as well. To exclude program listings of the visible affiliations pass includeAffiliations=false. To Get The primary program listings alone, pass primaryOnly=true.
Query:
{"ConstituentID":"string", "IncludeAffiliations":"string"}
[{"ConstituentID":"string","IncludeAffiliations":"string"}]
ConstituentID,IncludeAffiliations
"""string""","""string"""

Programs
postput

Get the details of a program by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get Programs
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all programs. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all programs.

Pronouns
postput

Usage:
tq get Pronouns
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries

Q

QualificationCategories
postput

Get the details of a Qualification Category by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resource in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get QualificationCategories
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get the details of all Qualification Categories. To get the resources only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all Qualification Categories.

Qualifications
postput

Get the details of a Qualification by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get Qualifications
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all Qualifications. To get only the resources for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).S
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all Qualifications.

QueryElementFilters
postput

Get a specific query element filter.

Usage:
tq get QueryElementFilters
Query:
{"QueryElementFilterID":"string"}
[{"QueryElementFilterID":"string"}]
QueryElementFilterID
"""string"""

Flags:

  • --All
    Get available query element filters for one or more query element groups.
Query:
{"GroupIds":"string"}
[{"GroupIds":"string"}]
GroupIds
"""string"""

  • --DataFor
    Get values for a query element filter.
Query:
{"QueryElementFilterID":"string"}
[{"QueryElementFilterID":"string"}]
QueryElementFilterID
"""string"""

  • --Summaries
    Get summary of query element filters for one or more query element groups.
Query:
{"GroupIds":"string"}
[{"GroupIds":"string"}]
GroupIds
"""string"""

QueryElementGroups
postput

Get the details of a query element group by id.

Usage:
tq get QueryElementGroups
Query:
{"QueryElementGroupID":"string"}
[{"QueryElementGroupID":"string"}]
QueryElementGroupID
"""string"""

Flags:

  • --All
    Get all query element groups.

QueryElements
postput

Get details of a query element by id.

Usage:
tq get QueryElements
Query:
{"ID":"string"}
[{"ID":"string"}]
ID
"""string"""

Flags:

  • --All
    Get a list of query elements optionally filtered by one or more GroupIds or if they're active only.
Query:
{"ActiveOnly":"string", "GroupIds":"string"}
[{"ActiveOnly":"string","GroupIds":"string"}]
ActiveOnly,GroupIds
"""string""","""string"""

  • --Summaries
    Get a list of query elements in summary optionally filtered by one or more GroupIds or if they're active only.
Query:
{"ActiveOnly":"string", "GroupIds":"string"}
[{"ActiveOnly":"string","GroupIds":"string"}]
ActiveOnly,GroupIds
"""string""","""string"""

R

RankTypes
postput

Get the details of a rank type by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get RankTypes
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all rank types. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all rank types.

Rankings
postput

Get details of a ranking.

Usage:
tq get Rankings
Query:
{"RankingID":"string"}
[{"RankingID":"string"}]
RankingID
"""string"""

Flags:

  • --All
    Get details of all the rankings for the specified constituent id and all its visible affiliation's rankings as well. To exclude rankings of the visible affiliations pass includeAffiliations=false. To Get The primary rankings alone, pass primaryOnly=true.
Query:
{"ConstituentID":"string", "IncludeAffiliations":"string"}
[{"ConstituentID":"string","IncludeAffiliations":"string"}]
ConstituentID,IncludeAffiliations
"""string""","""string"""

ReceiptSettings
postput

Get the details of a Receipt Setting by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get ReceiptSettings
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all Receipt Settings. To get only the resources for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all Receipt Settings.

ReferenceColumns

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.

Usage:
tq get ReferenceColumns
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

Flags:

  • --Summaries
    Get a summary representation of all reference columns.

ReferenceTableUserGroups
postput

Get the details of a reference table/user group mapping by id.

Usage:
tq get ReferenceTableUserGroups
Query:
{"ID":"string"}
[{"ID":"string"}]
ID
"""string"""

Flags:

  • --All
    Get all the reference table/user group mappings.
  • --Summaries
    Get a summary representation of all reference table/user group mappings.

ReferenceTables

Get details for a reference table by Id.

Usage:
tq get ReferenceTables
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all reference tables. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all reference tables.

RelationshipCategories
postput

Get the details of a relationship category by id.

Usage:
tq get RelationshipCategories
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all relationship categories. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all relationship categories.

Relationships

Get all affiliations and associations of the specified constituent id or get all affiliations and associations of the specified associated constituent id. If both are specified get all the associations and affiliations between them.

Usage:
tq get Relationships
Query:
{"ActiveOnly":"string", "AssociatedConstituentID":"string", "ConstituentID":"string", "EndActiveDate":"string", "IncludeAffiliations":"string", "StartActiveDate":"string"}
[{"ActiveOnly":"string","AssociatedConstituentID":"string","ConstituentID":"string","EndActiveDate":"string","IncludeAffiliations":"string","StartActiveDate":"string"}]
ActiveOnly,AssociatedConstituentID,ConstituentID,EndActiveDate,IncludeAffiliations,StartActiveDate
"""string""","""string""","""string""","""string""","""string""","""string"""

ReportRequests
postput

Get a report request.

Usage:
tq get ReportRequests
Query:
{"ID":"string"}
[{"ID":"string"}]
ID
"""string"""

Flags:

  • --All
    Get all requests, optionally filtered by active requests only.
Query:
{"ActiveOnly":"string"}
[{"ActiveOnly":"string"}]
ActiveOnly
"""string"""

  • --AllExpired
    Get a list of all the expired requests of the specified report types as of the provided date time.
Query:
{"AsOfDateTime":"string", "ReportTypes":"string"}
[{"AsOfDateTime":"string","ReportTypes":"string"}]
AsOfDateTime,ReportTypes
"""string""","""string"""

  • --Queued
    Get a list of all the requests queued to be run as of the current date/time.

ReportSchedules
postput

Get a report schedule.

Usage:
tq get ReportSchedules
Query:
{"ID":"string"}
[{"ID":"string"}]
ID
"""string"""

Flags:

  • --All
    Get all report schedules, optionally filtered by active only.
Query:
{"ActiveOnly":"string"}
[{"ActiveOnly":"string"}]
ActiveOnly
"""string"""

ReportUserGroups
postput

Get the details of a report/user group mapping by id.

Usage:
tq get ReportUserGroups
Query:
{"ID":"string"}
[{"ID":"string"}]
ID
"""string"""

Flags:

  • --All
    Get all report/user group mappings.
  • --Summaries
    Get a summary representation of all report/user group mappings.

Reports
post

Get details of a report.

Usage:
tq get Reports
Query:
{"ReportID":"string"}
[{"ReportID":"string"}]
ReportID
"""string"""

Flags:

  • --All
    Get all reports, Optionally filtered by type.
Query:
{"Type":"string"}
[{"Type":"string"}]
Type
"""string"""

  • --CustomData
    Get custom data for a report parameter.
Query:
{"ParameterID":"string", "ReportID":"string"}
[{"ParameterID":"string","ReportID":"string"}]
ParameterID,ReportID
"""string""","""string"""

  • --ReportCategories
    Get all report categories.
  • --ReportDefaults
    Get report defaults for the specified user group.
Query:
{"UserGroup":"string"}
[{"UserGroup":"string"}]
UserGroup
"""string"""

  • --ReportParameters
    Get report parameters.
Query:
{"ReportID":"string"}
[{"ReportID":"string"}]
ReportID
"""string"""

Research
postput

Get details of a research entry.

Usage:
tq get Research
Query:
{"ResearchEntryID":"string"}
[{"ResearchEntryID":"string"}]
ResearchEntryID
"""string"""

Flags:

  • --All
    Get details of all the research for the specified constituent id and all its visible affiliation's researches as well. To exclude researches of the visible affiliations pass includeAffiliations=false.
Query:
{"ConstituentID":"string", "IncludeAffiliations":"string"}
[{"ConstituentID":"string","IncludeAffiliations":"string"}]
ConstituentID,IncludeAffiliations
"""string""","""string"""

ResearchTypes
postput

Get the details of research type by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get ResearchTypes
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all research types. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all research types.

ResourceCategories
postput

Get the details of a Resource Category by id. To get the resource in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get ResourceCategories
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get details of all Resource Categories. To get them in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all Resource Categories.

ResourceSchedules
postput

Get a single resource schedule.

Usage:
tq get ResourceSchedules
Query:
{"ResourceScheduleID":"string"}
[{"ResourceScheduleID":"string"}]
ResourceScheduleID
"""string"""

Flags:

  • --All
    Get a list of resource schedules for resources or workers. One of 'resourceIds' or 'constituentIds' parameters must be provided.
Query:
{"ConstituentIds":"string", "EndDate":"string", "ResourceIds":"string", "StartDate":"string", "TypeIds":"string"}
[{"ConstituentIds":"string","EndDate":"string","ResourceIds":"string","StartDate":"string","TypeIds":"string"}]
ConstituentIds,EndDate,ResourceIds,StartDate,TypeIds
"""string""","""string""","""string""","""string""","""string"""

ResourceTypes
postput

Get all resource types.

Usage:
tq get ResourceTypes
Query:
{"ID":"string"}
[{"ID":"string"}]
ID
"""string"""

Flags:

  • --All
    Get all resource types.
Query:
{"CategoryIds":"string"}
[{"CategoryIds":"string"}]
CategoryIds
"""string"""

  • --Summaries
    Get summary of all resource types.
Query:
{"CategoryIds":"string"}
[{"CategoryIds":"string"}]
CategoryIds
"""string"""

Resources
postput

Get a specific Resource.

Usage:
tq get Resources
Query:
{"ID":"string"}
[{"ID":"string"}]
ID
"""string"""

Flags:

  • --All
    Get all resources optionally filtered by Resource Type, Category, or ConstituentId (for Worker type only). IncludeAffiliations parameter only accepted when ConstituentId provided.
Query:
{"CategoryIds":"string", "ConstituentID":"string", "IncludeAffiliations":"string", "ResourceTypeIds":"string"}
[{"CategoryIds":"string","ConstituentID":"string","IncludeAffiliations":"string","ResourceTypeIds":"string"}]
CategoryIds,ConstituentID,IncludeAffiliations,ResourceTypeIds
"""string""","""string""","""string""","""string"""

  • --Details
    Get schedules and qualifications that apply to a set of resources and/or constituents during certain period of time.
Query:
{"ConstituentIds":"string", "EndDateTime":"string", "ExpandWorkerAssignments":"string", "ResourceIds":"string", "StartDateTime":"string"}
[{"ConstituentIds":"string","EndDateTime":"string","ExpandWorkerAssignments":"string","ResourceIds":"string","StartDateTime":"string"}]
ConstituentIds,EndDateTime,ExpandWorkerAssignments,ResourceIds,StartDateTime
"""string""","""string""","""string""","""string""","""string"""

  • --HasUsages
    Get the resource usage information.
Query:
{"ID":"string"}
[{"ID":"string"}]
ID
"""string"""

  • --Summaries
    Get all resources in summary optionally filtered by Resource Type, Category, or Constituent (for Worker Type only). IncludeAffiliations parameter only accepted when ConstituentId provided.
Query:
{"CategoryIds":"string", "ConstituentID":"string", "IncludeAffiliations":"string", "ResourceTypeIds":"string"}
[{"CategoryIds":"string","ConstituentID":"string","IncludeAffiliations":"string","ResourceTypeIds":"string"}]
CategoryIds,ConstituentID,IncludeAffiliations,ResourceTypeIds
"""string""","""string""","""string""","""string"""

S

SalesChannels
postput

Get the details of a sales channel by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get SalesChannels
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all sales channels. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all sales channels.

SalesLayoutButtonTypes
postput

Get the details of a sales layout button type by id.

Usage:
tq get SalesLayoutButtonTypes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all sales layout button types. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all sales layout button types.

SalesLayouts
postput

Get details of a sales layout setup.

Usage:
tq get SalesLayouts
Query:
{"SalesLayoutID":"string"}
[{"SalesLayoutID":"string"}]
SalesLayoutID
"""string"""

Flags:

  • --ForSale
    Get details of a sales layout for use in orders.
Query:
{"ModeOfSaleID":"string", "OrderDateTime":"string", "SalesLayoutID":"string"}
[{"ModeOfSaleID":"string","OrderDateTime":"string","SalesLayoutID":"string"}]
ModeOfSaleID,OrderDateTime,SalesLayoutID
"""string""","""string""","""string"""

  • --Summaries
    Get all sales layouts setup.
Query:
{"PrimaryOnly":"string"}
[{"PrimaryOnly":"string"}]
PrimaryOnly
"""string"""

SalutationTypes
postput

Get the details of a salutation type by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get SalutationTypes
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all salutation types. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all salutation types.

Salutations
postput

Get details of a salutation.

Usage:
tq get Salutations
Query:
{"SalutationID":"string"}
[{"SalutationID":"string"}]
SalutationID
"""string"""

Flags:

  • --All
    Get details of all the salutations for the specified constituent id and all its visible affiliation's salutations as well. To exclude salutations of the visible affiliations pass includeAffiliations=false.To fetch default salutations alone pass defaultOnly=true.
Query:
{"ConstituentID":"string", "DefaultOnly":"string", "IncludeAffiliations":"string", "IncludeFromAffiliations":"string"}
[{"ConstituentID":"string","DefaultOnly":"string","IncludeAffiliations":"string","IncludeFromAffiliations":"string"}]
ConstituentID,DefaultOnly,IncludeAffiliations,IncludeFromAffiliations
"""string""","""string""","""string""","""string"""

  • --Generate
    Generates values for the fields required for the salutation, last name and sort name using the values passed as query parameters. If you pass in value for 'constituentId' there is no need to pass values for any other parameters. Even if it is passed they are ignored. If value for constituentId is not passed, values for other parameters should be passed. In this case values for either 'constituentTypeId' or 'formulaId' should be passed.
Query:
{"ConstituentID":"string", "ConstituentTypeID":"string", "Fname1":"string", "Fname2":"string", "FormulaID":"string", "Gender1":"string", "Gender2":"string", "Lname1":"string", "Lname2":"string", "LnameGroup":"string", "MaxLength":"string", "Mname1":"string", "Mname2":"string", "Prefix1":"string", "Prefix2":"string", "Status1":"string", "Status2":"string", "Suffix1":"string", "Suffix2":"string"}
[{"ConstituentID":"string","ConstituentTypeID":"string","Fname1":"string","Fname2":"string","FormulaID":"string","Gender1":"string","Gender2":"string","Lname1":"string","Lname2":"string","LnameGroup":"string","MaxLength":"string","Mname1":"string","Mname2":"string","Prefix1":"string","Prefix2":"string","Status1":"string","Status2":"string","Suffix1":"string","Suffix2":"string"}]
ConstituentID,ConstituentTypeID,Fname1,Fname2,FormulaID,Gender1,Gender2,Lname1,Lname2,LnameGroup,MaxLength,Mname1,Mname2,Prefix1,Prefix2,Status1,Status2,Suffix1,Suffix2
"""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string"""

SchedulePatternTypes
postput

Get the details of a Schedule Pattern by id. To get the resource in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get SchedulePatternTypes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get details of all Schedule Patterns. To get them in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all Schedule Patterns.

ScheduleTypes
postput

Get the details of a Schedule Type by id. To get the resource in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get ScheduleTypes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get details of all Schedule Types. To get them in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all Schedule Types.

SeasonTypes
postput

Get the details of a season type by id.

Usage:
tq get SeasonTypes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all season types. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all season types.

Seasons
postput

Get the details of a season by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get Seasons
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all seasons. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all seasons.

SeatCodes
postput

Get the details of a seat code by id.

Usage:
tq get SeatCodes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all seat codes. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all seat codes.

SeatStatuses
postput

Get the details of a seat status by id.

Usage:
tq get SeatStatuses
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all seat statuses. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all seat statuses.

Sections
postput

Get the details of a section by id.

Usage:
tq get Sections
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all sections. To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).
Query:
{"MaintenanceMode":"string", "SeatMapID":"string"}
[{"MaintenanceMode":"string","SeatMapID":"string"}]
MaintenanceMode,SeatMapID
"""string""","""string"""

  • --Summaries
    Get a summary representation of all sections.

SecurityBatchTypes

Get all batch type/user group mappings valid for the context usergroup.

Usage:
tq get SecurityBatchTypes
Query:



SecurityControlGroups

Get all control group/user group mappings valid for the context usergroup.

Usage:
tq get SecurityControlGroups
Query:



SecurityHoldCodes

Get all hold code/user group mappings valid for the context usergroup.

Usage:
tq get SecurityHoldCodes
Query:



SecurityModesOfSale

Get all mode of sale/user group mappings valid for the context usergroup.

Usage:
tq get SecurityModesOfSale
Query:



SecurityObjectPermissions

Get all the object permissions valid for the context usergroup. Optionally filter by constituency id and/or object id.

Usage:
tq get SecurityObjectPermissions
Query:
{"ConstituencyID":"string", "ObjectIds":"string", "Objectid":"string"}
[{"ConstituencyID":"string","ObjectIds":"string","Objectid":"string"}]
ConstituencyID,ObjectIds,Objectid
"""string""","""string""","""string"""

SecurityPaymentMethods

Get all payment method/user group mappings valid for the context usergroup.

Usage:
tq get SecurityPaymentMethods
Query:
{"Amount":"string"}
[{"Amount":"string"}]
Amount
"""string"""

SecurityPriceTypes

Get all price type/user group mappings valid for the context usergroup.

Usage:
tq get SecurityPriceTypes
Query:



SecurityReferenceTables

Get all the reference table/user group mappings valid for the context usergroup.

Usage:
tq get SecurityReferenceTables
Query:



SecurityReports

Get all report/user group mappings valid for the context usergroup.

Usage:
tq get SecurityReports
Query:



SecurityServiceResources

Get all service resource/user group mappings valid for the context usergroup.

Usage:
tq get SecurityServiceResources
Query:



SecurityUserGroups

Get all security user groups.

Usage:
tq get SecurityUserGroups
Query:
{"Application":"string", "UserName":"string"}
[{"Application":"string","UserName":"string"}]
Application,UserName
"""string""","""string"""

Flags:

  • --DefaultUserGroup
    Get the default security user group.
Query:
{"UserName":"string"}
[{"UserName":"string"}]
UserName
"""string"""

  • --ManagedGroups
    Get all managed security user groups.
Query:
{"UserName":"string"}
[{"UserName":"string"}]
UserName
"""string"""

ServiceResourceUserGroups
postput

Get the details of a service resource/user group mapping by id.

Usage:
tq get ServiceResourceUserGroups
Query:
{"ID":"string"}
[{"ID":"string"}]
ID
"""string"""

Flags:

  • --All
    Get all service resource/user group mappings.
  • --Summaries
    Get a summary representation of all service resource/user group mappings.

ServiceResources

Get all service resources. 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.

Usage:
tq get ServiceResources
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

Flags:

  • --Summaries
    Get a summary representation of all service resources.

Session
postput

Returns details summarizing a web session's state. Includes counts of cart products, the login status, MOS and Source

Usage:
tq get Session
Query:
{"SessionKey":"string"}
[{"SessionKey":"string"}]
SessionKey
"""string"""

Flags:

  • --Default
    Returns summary information for the specified default, including value
Query:
{"FieldName":"string", "SessionKey":"string"}
[{"FieldName":"string","SessionKey":"string"}]
FieldName,SessionKey
"""string""","""string"""

  • --DeliveryMethods
    Returns the available delivery methods for the session Delivery method availability is based on the mode of sale. NOTE: The Hold at Box Office delivery method(ID -1) is always returned. Web code must be used to filter out this delivery method as needed.
Query:
{"SessionKey":"string"}
[{"SessionKey":"string"}]
SessionKey
"""string"""

  • --Expiration
    Returns the deadline after which a session's reserved seats will be released When called on a session without an established Seat Server session, one will be created for it. Once the session is created, the deadline will apply regardless of whether or not any tickets have been added to the cart.
Query:
{"SessionKey":"string"}
[{"SessionKey":"string"}]
SessionKey
"""string"""

  • --OnAccountBalances
    Returns the balance of on account money held by the constituent associated to the provided session key. Results can be filtered by specific on-account payment methods. The Amount used in current session is also indicated.
Query:
{"PaymentMethodIds":"string", "SessionKey":"string"}
[{"PaymentMethodIds":"string","SessionKey":"string"}]
PaymentMethodIds,SessionKey
"""string""","""string"""

  • --OrderSearch
    Returns summary details for all orders belonging to the session's authenticated constituent. Returned orders can be filtered by print status, performance date, season, mode of sale, delivery method, and whether or not an order was created by a rollover.
Query:
{"DeliveryMethodID":"string", "IncludeAffiliations":"string", "IncludeUnfulfilledRollovers":"string", "ModeOfSaleID":"string", "PerfEndDate":"string", "PerfStartDate":"string", "RenewalsOnly":"string", "SeasonID":"string", "SessionKey":"string", "UnprintedOnly":"string"}
[{"DeliveryMethodID":"string","IncludeAffiliations":"string","IncludeUnfulfilledRollovers":"string","ModeOfSaleID":"string","PerfEndDate":"string","PerfStartDate":"string","RenewalsOnly":"string","SeasonID":"string","SessionKey":"string","UnprintedOnly":"string"}]
DeliveryMethodID,IncludeAffiliations,IncludeUnfulfilledRollovers,ModeOfSaleID,PerfEndDate,PerfStartDate,RenewalsOnly,SeasonID,SessionKey,UnprintedOnly
"""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string"""

  • --Variable
    Returns the value of the specified session variable.
Query:
{"SessionKey":"string", "VariableName":"string"}
[{"SessionKey":"string","VariableName":"string"}]
SessionKey,VariableName
"""string""","""string"""

  • --Variables
    Returns a list of all name/value pair variables for the specified session.
Query:
{"SessionKey":"string"}
[{"SessionKey":"string"}]
SessionKey
"""string"""

SourceGroups
postput

Get the details of a source group by id.

Usage:
tq get SourceGroups
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all source groups. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all source groups.

Sources

Get details of a Source.

Usage:
tq get Sources
Query:
{"SourceID":"string"}
[{"SourceID":"string"}]
SourceID
"""string"""

Flags:

  • --Summaries
    Get summary of all Sources.
Query:
{"ActiveOnly":"string", "AppealIds":"string"}
[{"ActiveOnly":"string","AppealIds":"string"}]
ActiveOnly,AppealIds
"""string""","""string"""

  • --WebExpiring
    Gets the source codes configured as the web default that are expiring in 15 days without an overlapping source code.

SpecialActivities
postput

Get details of an activity record.

Usage:
tq get SpecialActivities
Query:
{"SpecialActivityID":"string"}
[{"SpecialActivityID":"string"}]
SpecialActivityID
"""string"""

Flags:

  • --All
    Get details of all the activity records for the specified constituent id and all its visible affiliations' activity records as well. To exclude activity records of the visible affiliations, pass includeAffiliations=false.
Query:
{"ConstituentID":"string", "IncludeAffiliations":"string"}
[{"ConstituentID":"string","IncludeAffiliations":"string"}]
ConstituentID,IncludeAffiliations
"""string""","""string"""

SpecialActivityStatuses
postput

Get the details of a Special Activity Status by id. To get the resource in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get SpecialActivityStatuses
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get details of all Special Activity Statuses. To get them in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all Special Activity Statuses.

SpecialActivityTypes
postput

Get the details of a Special Activity Type by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get SpecialActivityTypes
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all Special Activity Types. To get only the resources for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all Special Activity Types.

States
postput

Get the details of a state by id.

Usage:
tq get States
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all states. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all states.

StepTypes
postput

Get the details of a step type by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get StepTypes
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all step types. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all step types.

Steps
postput

Get details of a step.

Usage:
tq get Steps
Query:
{"StepID":"string"}
[{"StepID":"string"}]
StepID
"""string"""

Flags:

  • --All
    Get details of all the steps for the specified plan, constituent or associate.
Query:
{"AssociateID":"string", "ConstituentID":"string", "IncludeAffiliations":"string", "IncludeAssociates":"string", "PlanID":"string"}
[{"AssociateID":"string","ConstituentID":"string","IncludeAffiliations":"string","IncludeAssociates":"string","PlanID":"string"}]
AssociateID,ConstituentID,IncludeAffiliations,IncludeAssociates,PlanID
"""string""","""string""","""string""","""string""","""string"""

  • --AllDocumentSummaries
    Get summary of all the documents associated with the step. (Excluding the file contents)
Query:
{"StepID":"string"}
[{"StepID":"string"}]
StepID
"""string"""

  • --AllDocuments
    Get all the documents associated with the step (Including the file contents).
Query:
{"StepID":"string"}
[{"StepID":"string"}]
StepID
"""string"""

SubLineItemStatuses
postput

Get the details of a sub line item status by id.

Usage:
tq get SubLineItemStatuses
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all sub line item statuses. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all sub line item statuses.

SubLineItems

Returns sub line item summary data for a constituent

Usage:
tq get SubLineItems
Query:
{"ConstituentID":"string", "IncludeAffiliations":"string", "IncludePackageBaseSubLineitems":"string", "OrderEndDate":"string", "OrderID":"string", "OrderStartDate":"string", "PerformanceEndDate":"string", "PerformanceStartDate":"string", "PerformanceTypeIds":"string", "SubLineItemStatusIds":"string"}
[{"ConstituentID":"string","IncludeAffiliations":"string","IncludePackageBaseSubLineitems":"string","OrderEndDate":"string","OrderID":"string","OrderStartDate":"string","PerformanceEndDate":"string","PerformanceStartDate":"string","PerformanceTypeIds":"string","SubLineItemStatusIds":"string"}]
ConstituentID,IncludeAffiliations,IncludePackageBaseSubLineitems,OrderEndDate,OrderID,OrderStartDate,PerformanceEndDate,PerformanceStartDate,PerformanceTypeIds,SubLineItemStatusIds
"""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string"""

Suffixes
postput

Get the details of a suffix by id.

Usage:
tq get Suffixes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all suffixes. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all suffixes.

SurveyQuestions
postput

Get the details of a survey question by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get SurveyQuestions
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get details of all survey questions. To get only the resources for which the user has write/edit access, pass filter="writeonly". To get them in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). Optionally provide a mode of sale id.
Query:
{"Filter":"string", "MaintenanceMode":"string", "ModeOfSaleID":"string"}
[{"Filter":"string","MaintenanceMode":"string","ModeOfSaleID":"string"}]
Filter,MaintenanceMode,ModeOfSaleID
"""string""","""string""","""string"""

  • --DataFor
    Get answer data for a survey question if it refers to another reference table.
Query:
{"QuestionID":"string"}
[{"QuestionID":"string"}]
QuestionID
"""string"""

  • --Summaries
    Get a summary representation of all survey questions.

SurveyResponses
postput

Get details of a survey response.

Usage:
tq get SurveyResponses
Query:
{"SurveyResponseID":"string"}
[{"SurveyResponseID":"string"}]
SurveyResponseID
"""string"""

Flags:

  • --All
    Get all survey responses.
Query:
{"OrderID":"string"}
[{"OrderID":"string"}]
OrderID
"""string"""

SystemDefaults

Get all system defaults. 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.

Usage:
tq get SystemDefaults
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

Flags:

  • --Default
    Get default summaries for specified keys, delimited by comma ("?keys=COMPANY_NAME,REQUIRE_ADDRESS"). This resource resolves organizational and global defaults to ensure that only one is returned per key (field name). No default will be returned if one does not exist.
Query:
{"Keys":"string"}
[{"Keys":"string"}]
Keys
"""string"""

  • --Summaries
    Get a summary representation of all system defaults.

T

TemplateCategories
postput

Get the details of a template category by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get TemplateCategories
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all template categories. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all template categories.

TemplatePriceTypes
postput

Get details of a template price type.

Usage:
tq get TemplatePriceTypes
Query:
{"TemplatePriceTypeID":"string"}
[{"TemplatePriceTypeID":"string"}]
TemplatePriceTypeID
"""string"""

Flags:

  • --All
    Get all template price type.
Query:
{"TemplateID":"string"}
[{"TemplateID":"string"}]
TemplateID
"""string"""

TemplatePrices
postput

Get details of a template price.

Usage:
tq get TemplatePrices
Query:
{"TemplatePriceID":"string"}
[{"TemplatePriceID":"string"}]
TemplatePriceID
"""string"""

Flags:

  • --All
    Get all template prices.
Query:
{"TemplateID":"string"}
[{"TemplateID":"string"}]
TemplateID
"""string"""

TemplateTypes

Get the details of a template type by id. To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get TemplateTypes
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all template types. To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all template types

Templates
postput

Get the details of a template by id

Usage:
tq get Templates
Query:
{"TemplateID":"string"}
[{"TemplateID":"string"}]
TemplateID
"""string"""

Flags:

  • --All
    Get all templates
  • --Summaries
    Get a summary representation of all templates

Theaters
postput

Get the details of a theater by id.

Usage:
tq get Theaters
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all theaters. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all theaters.

TicketHistory

Gets history information for tickets

Usage:
tq get TicketHistory
Query:
{"ConstituentID":"string", "IncludeAffiliations":"string", "OrderEndDate":"string", "OrderStartDate":"string", "PerformanceEndDate":"string", "PerformanceID":"string", "PerformanceStartDate":"string", "ProductionSeasonID":"string", "SeasonID":"string"}
[{"ConstituentID":"string","IncludeAffiliations":"string","OrderEndDate":"string","OrderStartDate":"string","PerformanceEndDate":"string","PerformanceID":"string","PerformanceStartDate":"string","ProductionSeasonID":"string","SeasonID":"string"}]
ConstituentID,IncludeAffiliations,OrderEndDate,OrderStartDate,PerformanceEndDate,PerformanceID,PerformanceStartDate,ProductionSeasonID,SeasonID
"""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string"""

TimeSlots
postput

Get the details of a time slot by id.

Usage:
tq get TimeSlots
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all time slots. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all time slots.

Titles

Get details of a specific title.

Usage:
tq get Titles
Query:
{"ID":"string"}
[{"ID":"string"}]
ID
"""string"""

Flags:

  • --All
    Get all titles
  • --Summaries
    Get all title summaries

TransactionHistory

Get details of all transaction histories for the specified constituent id and all its visible affiliations' transaction histories as well. To exclude transaction histories of the visible affiliations pass includeAffiliations=false. This resource is paged. Pass filters such as transaction reference id, payment id, or start and end date to limit the results. Results can also be sorted.

Usage:
tq get TransactionHistory
Query:
{"ConstituentID":"string", "EndDate":"string", "IncludeAffiliations":"string", "Page":"string", "PageSize":"string", "PaymentID":"string", "ReferenceID":"string", "SortByDirection":"string", "SortByField":"string", "StartDate":"string"}
[{"ConstituentID":"string","EndDate":"string","IncludeAffiliations":"string","Page":"string","PageSize":"string","PaymentID":"string","ReferenceID":"string","SortByDirection":"string","SortByField":"string","StartDate":"string"}]
ConstituentID,EndDate,IncludeAffiliations,Page,PageSize,PaymentID,ReferenceID,SortByDirection,SortByField,StartDate
"""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string"""

TriPOSCloudConfigurations
postput

Get the details of a TriPOS Cloud configuration by id.

Usage:
tq get TriPOSCloudConfigurations
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all TriPOS Cloud configurations.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all TriPOS Cloud configurations.

U

UpgradeCategories
postput

Get the details of an Upgrade Category by id. To get the resource in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get UpgradeCategories
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get details of all Upgrade Categories. To get them in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all Upgrade Categories.

UpgradeLogs
postput

Returns an upgradeLog for the given id.

Usage:
tq get UpgradeLogs
Query:
{"UpgradeLogID":"string"}
[{"UpgradeLogID":"string"}]
UpgradeLogID
"""string"""

Flags:

  • --All
    Returns a list of UpgradeLog objects.

UserGroups

Get the details of a user group by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get UserGroups
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all User Groups. To get only the resources for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode (which ignores Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all user groups.

UserPreferences
postput

Get a specific user preference by key.

Usage:
tq get UserPreferences
Query:
{"Key":"string"}
[{"Key":"string"}]
Key
"""string"""

Flags:

  • --All
    Get all user preferences valid for the context username and user group.
Query:
{"Keys":"string"}
[{"Keys":"string"}]
Keys
"""string"""

Users
post

Get the details of a user for the specified username.

Usage:
tq get Users
Query:
{"UserName":"string"}
[{"UserName":"string"}]
UserName
"""string"""

Flags:

  • --ActiveDirectoryUser
    Get details of a user for the specified activeDirectoryUsername.
Query:
{"ActiveDirectoryUsername":"string"}
[{"ActiveDirectoryUsername":"string"}]
ActiveDirectoryUsername
"""string"""

  • --UserInformationForActiveDirectoryUser
    Gets user information for the specified activeDirectoryUsername.
Query:
{"ActiveDirectoryUsername":"string"}
[{"ActiveDirectoryUsername":"string"}]
ActiveDirectoryUsername
"""string"""

  • --UsersForUserGroup
    Get list of users in summary for the current user's group.
Query:
{"UserGroupID":"string"}
[{"UserGroupID":"string"}]
UserGroupID
"""string"""

V

W

WebContentTypes
postput

Get a specific web content type.

Usage:
tq get WebContentTypes
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all web content types. 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --DataFor
    Gets potential values for a referenced WebContentType as a collection of WebContentTypeDataItem.
Query:
{"ID":"string"}
[{"ID":"string"}]
ID
"""string"""

  • --Summaries
    Get a summary representation of all web content types.

WebContents

Returns web content for the requested production elements or packages. The result can be filtered by content types. At least one package id or production element id is required. If the content type is found, returns the content value at the lowest level at which it was found in the production hierarchy (Title, Production, Production Season, Performance) for the requested element. Optionally, all matching content anywhere above the requested element in the production hierarchy can be returned with the ShowAll parameter.

Usage:
tq get WebContents
Query:
{"ContentTypeIds":"string", "PackageIds":"string", "ProductionElementIds":"string", "ShowAll":"string"}
[{"ContentTypeIds":"string","PackageIds":"string","ProductionElementIds":"string","ShowAll":"string"}]
ContentTypeIds,PackageIds,ProductionElementIds,ShowAll
"""string""","""string""","""string""","""string"""

WebLogins
postput

Get details of a weblogin.

Usage:
tq get WebLogins
Query:
{"WebLoginID":"string"}
[{"WebLoginID":"string"}]
WebLoginID
"""string"""

Flags:

  • --All
    Get details of all the weblogins for the specified constituent id and all its visible affiliation's weblogins as well. To exclude weblogins of the visible affiliations pass includeAffiliations=false. To fetch primary web logins alone pass primaryOnly=true.
Query:
{"ConstituentID":"string", "IncludeAffiliations":"string", "PrimaryOnly":"string"}
[{"ConstituentID":"string","IncludeAffiliations":"string","PrimaryOnly":"string"}]
ConstituentID,IncludeAffiliations,PrimaryOnly
"""string""","""string""","""string"""

  • --LoginCredentials
    Returns web login credential information
Query:
{"LoginID":"string"}
[{"LoginID":"string"}]
LoginID
"""string"""

  • --Search
    Get weblogins by email address and login type
Query:
{"EmailAddress":"string", "LoginTypeID":"string"}
[{"EmailAddress":"string","LoginTypeID":"string"}]
EmailAddress,LoginTypeID
"""string""","""string"""

WorkerQualifications
postput

Get a single WorkerQualification by Id.

Usage:
tq get WorkerQualifications
Query:
{"WorkerQualificationID":"string"}
[{"WorkerQualificationID":"string"}]
WorkerQualificationID
"""string"""

Flags:

  • --All
    Get all Worker Qualifications for a comma separated list of constituents, optionally including qualifications from affiliated constituents.
Query:
{"ConstituentIds":"string", "IncludeAffiliations":"string"}
[{"ConstituentIds":"string","IncludeAffiliations":"string"}]
ConstituentIds,IncludeAffiliations
"""string""","""string"""

WorkerRoles
postput

Get the details of a worker role by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get WorkerRoles
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all worker roles. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all worker roles.

WorkerTypes
postput

Get the details of a worker type by id. To get the resource only if the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP).

Usage:
tq get WorkerTypes
Query:
{"Filter":"string", "ID":"string", "MaintenanceMode":"string"}
[{"Filter":"string","ID":"string","MaintenanceMode":"string"}]
Filter,ID,MaintenanceMode
"""string""","""string""","""string"""

Flags:

  • --All
    Get all worker types. To get only the resoures for which the user has write/edit access, pass filter="writeonly". To get the resources in maintenance mode(ignore Control Groups), pass maintenanceMode="true". Maintenance mode requires users to have access to the reference tables. (Specified in TX_REFTABLE_USERGROUP). 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.
Query:
{"Filter":"string", "MaintenanceMode":"string"}
[{"Filter":"string","MaintenanceMode":"string"}]
Filter,MaintenanceMode
"""string""","""string"""

  • --Summaries
    Get a summary representation of all worker types.

Workers
postput

Get details of a worker.

Usage:
tq get Workers
Query:
{"WorkerID":"string"}
[{"WorkerID":"string"}]
WorkerID
"""string"""

Flags:

  • --All
    Get details of all the workers for the specified constituent.
Query:
{"ConstituentID":"string", "IncludeAffiliations":"string"}
[{"ConstituentID":"string","IncludeAffiliations":"string"}]
ConstituentID,IncludeAffiliations
"""string""","""string"""

  • --Summaries
    Get summary of all the workers for the specified constituent.
Query:
{"ConstituentID":"string", "IncludeAffiliations":"string"}
[{"ConstituentID":"string","IncludeAffiliations":"string"}]
ConstituentID,IncludeAffiliations
"""string""","""string"""

Z

ZoneGroups
postput

Get the details of a zone group by id.

Usage:
tq get ZoneGroups
Query:
{"ID":"string", "MaintenanceMode":"string"}
[{"ID":"string","MaintenanceMode":"string"}]
ID,MaintenanceMode
"""string""","""string"""

Flags:

  • --All
    Get all zone groups. 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.
Query:
{"MaintenanceMode":"string"}
[{"MaintenanceMode":"string"}]
MaintenanceMode
"""string"""

  • --Summaries
    Get a summary representation of all zone groups.

ZoneMaps
postput

Get details of a specific zone map.

Usage:
tq get ZoneMaps
Query:
{"ID":"string"}
[{"ID":"string"}]
ID
"""string"""

Flags:

  • --All
    Get all zone maps, optionally filtered by facility and/or seat map.
Query:
{"FacilityID":"string", "SeatMapID":"string"}
[{"FacilityID":"string","SeatMapID":"string"}]
FacilityID,SeatMapID
"""string""","""string"""

  • --Summaries
    Get a summary of all zone maps, optionally filtered by facility and/or seat map.
Query:
{"FacilityID":"string", "SeatMapID":"string"}
[{"FacilityID":"string","SeatMapID":"string"}]
FacilityID,SeatMapID
"""string""","""string"""

Zones
postput

Get details of a specific zone.

Usage:
tq get Zones
Query:
{"ZoneID":"string", "ZoneMapID":"string"}
[{"ZoneID":"string","ZoneMapID":"string"}]
ZoneID,ZoneMapID
"""string""","""string"""

Flags:

  • --All
    Get all zones, optionally filtered by a set of zone maps.
Query:
{"ZoneMapIds":"string"}
[{"ZoneMapIds":"string"}]
ZoneMapIds
"""string"""

  • --Summaries
    Get a summary of all zones, optionally filtered by a set of zone maps.
Query:
{"ZoneMapIds":"string"}
[{"ZoneMapIds":"string"}]
ZoneMapIds
"""string"""