A
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.
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"""
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.
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"""
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.
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.
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.
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"""
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.
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"""
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.
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"""
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
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.
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:
Get details of an existing artist.
Usage:
tq get Artists
Query:
{"ArtistID":"string"}
[{"ArtistID":"string"}]
ArtistID
"""string"""
Flags:
- --All
Get details of all artists.
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.
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"""
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.
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"""
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
This is a no-op operation for windows authentication diagnostics.
Usage:
tq get Authenticate
Query:
B
BatchMaintenance
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"""
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"""
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.
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.
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.
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.
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"""
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"""
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.
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"""
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:
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"""
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"""
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.
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"""
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.
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.
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"""
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"""
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"""
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.
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.
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.
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.
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.
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"""
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.
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.
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"""
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.
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.
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.
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"""
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"""
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:
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.
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.
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.
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
Usage:
tq get CoreIdentity
Query:
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.
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"""
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
Get the metadata information of a custom table as defined by TR_DATASERVICE_TABLES and TR_DATASERVICE_COLUMNS.
Usage:
tq get Custom
Query:
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.
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
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.
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.
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.
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.
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"""
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.
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
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"""
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.
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"""
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
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.
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
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.
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.
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.
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"""
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.
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.
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.
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.
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
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
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.
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"""
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
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.
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.
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.
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.
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.
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"""
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"""
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"""
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
Get status of a processing automated billing run.
Usage:
tq get InvoiceBilling
Query:
{"ID":"string"}
[{"ID":"string"}]
ID
"""string"""
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
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.
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
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.
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.
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"""
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
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.
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.
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.
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
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:
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.
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"""
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"""
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"""
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.
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
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.
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
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
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"""
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.
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"""
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.
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.
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.
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"""
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"""
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.
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
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"""
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:
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"""
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"""
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.
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"""
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"""
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"""
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
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"""
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"""
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"""
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"""
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"""
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"""
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.
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.
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"""
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"""
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.
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.
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.
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"""
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.
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.
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.
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.
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"""
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
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"""
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"""
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.
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.
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
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"""
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.
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"""
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.
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.
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.
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"""
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"""
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.
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.
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.
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.
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"""
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
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"""
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"""
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.
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
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.
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.
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"""
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.
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
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.
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"""
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.
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.
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"""
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.
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"""
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
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"""
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"""
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.
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.
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"""
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"""
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
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.
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.
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"""
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.
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"""
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.
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.
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.
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.
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.
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.
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"""
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.
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"""
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.
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"""
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.
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.
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.
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.
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"""
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"""
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.
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.
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
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.
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"""
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
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
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"""
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"""
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
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.
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.
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
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
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"""
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"""
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"""
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.
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.
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
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.
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"""
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"""