A

AccountTypes
getpost

Update an existing account type.

Usage:
tq put AccountTypes
Query:
{"CardLength":"string", "CardPrefix":"string", "CardtypeIndicator":"string", "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "EditMask":"string", "Id":123, "Inactive":true, "Mod10Indicator":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CardLength":"string","CardPrefix":"string","CardtypeIndicator":"string","CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","EditMask":"string","ID":"string","Id":123,"Inactive":true,"Mod10Indicator":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CardLength,CardPrefix,CardtypeIndicator,CreateLocation,CreatedBy,CreatedDateTime,Description,EditMask,ID,Id,Inactive,Mod10Indicator,UpdatedBy,UpdatedDateTime
"""string""","""string""","""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""","""string""",123,true,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

Accounts
getpost

Update expiration date or name on a credit card account or token. Will also tokenize the credit card if tokenization is enabled. PaymentMethodGroupId is ignored if the account already has a PaymentMethodGroupId assigned. This value cannot be updated. If tokenizing a non-tokenized card, PaymentMethodGroupId is required if one has not already been assigned to the account.

Usage:
tq put Accounts
Query:
{"AccountID":"string", "CardExpiryMonth":123, "CardExpiryYear":123, "Inactive":true, "Name":"string", "PaymentMethodGroupId":123, "TransactionOrigin":"string"}
[{"AccountID":"string","CardExpiryMonth":123,"CardExpiryYear":123,"Inactive":true,"Name":"string","PaymentMethodGroupId":123,"TransactionOrigin":"string"}]
AccountID,CardExpiryMonth,CardExpiryYear,Inactive,Name,PaymentMethodGroupId,TransactionOrigin
"""string""",123,123,true,"""string""",123,"""string"""

Flags:

  • --DirectDebitAccount
    Updates expiration date or name on a direct debit account.
Query:
{"AccountID":"string", "CardExpiryMonth":123, "CardExpiryYear":123, "DirectDebitAccountType":{"Id":123}, "Inactive":true, "Name":"string"}
[{"AccountID":"string","CardExpiryMonth":123,"CardExpiryYear":123,"DirectDebitAccountType.Id":123,"Inactive":true,"Name":"string"}]
AccountID,CardExpiryMonth,CardExpiryYear,DirectDebitAccountType.Id,Inactive,Name
"""string""",123,123,123,true,"""string"""

  • --SepaAccount
    Updates information on a SEPA Direct Debit Account.
Query:
{"AccountID":"string", "BankIdentifierCode":"string", "Inactive":true, "MandateType":123, "Name":"string", "SignatureDate":"2000-01-01T00:00:00.000Z"}
[{"AccountID":"string","BankIdentifierCode":"string","Inactive":true,"MandateType":123,"Name":"string","SignatureDate":"2000-01-01T00:00:00.000Z"}]
AccountID,BankIdentifierCode,Inactive,MandateType,Name,SignatureDate
"""string""","""string""",true,123,"""string""","""2000-01-01T00:00:00.000Z"""

ActionTypes
getpost

Update an existing action type.

Usage:
tq put ActionTypes
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "LetterIndicator":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"LetterIndicator":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,LetterIndicator,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,true,"""string""","""2000-01-01T00:00:00.000Z"""

Actions
getpost

Update an issue action for a Constituent

Usage:
tq put Actions
Query:
{"ActionID":"string", "ActionDate":"2000-01-01T00:00:00.000Z", "ActionType":{"Id":123}, "Constituent":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "EditIndicator":true, "Id":123, "Issue":{"Id":123}, "LetterPrintedDate":"2000-01-01T00:00:00.000Z", "Notes":"string", "Resolved":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z"}
[{"ActionDate":"2000-01-01T00:00:00.000Z","ActionID":"string","ActionType.Id":123,"Constituent.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","EditIndicator":true,"Id":123,"Issue.Id":123,"LetterPrintedDate":"2000-01-01T00:00:00.000Z","Notes":"string","Resolved":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ActionDate,ActionID,ActionType.Id,Constituent.Id,CreateLocation,CreatedBy,CreatedDateTime,EditIndicator,Id,Issue.Id,LetterPrintedDate,Notes,Resolved,UpdatedBy,UpdatedDateTime
"""2000-01-01T00:00:00.000Z""","""string""",123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",true,123,123,"""2000-01-01T00:00:00.000Z""","""string""",true,"""string""","""2000-01-01T00:00:00.000Z"""

ActivityCategories
getpost

Update an existing activity category.

Usage:
tq put ActivityCategories
Query:
{"AutoClose":true, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"AutoClose":true,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
AutoClose,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
true,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

ActivityTypes
getpost

Update an existing activity type.

Usage:
tq put ActivityTypes
Query:
{"Category":{"Id":123}, "ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "PerfIndicator":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"Category.Id":123,"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"PerfIndicator":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
Category.Id,ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,PerfIndicator,UpdatedBy,UpdatedDateTime
123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

AddressTypes
getpost

Update an existing address type.

Usage:
tq put AddressTypes
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

Addresses
getpost

Update an address for a Constituent by sending an XML or JSON representation of an existing Address object using HTTP PUT.

Usage:
tq put Addresses
Query:
{"AddressType":{"Id":123}, "AffiliatedConstituent":{"Id":123}, "AltSalutationType":{"Id":123}, "City":"string", "Constituent":{"Id":123}, "Country":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DeliveryPoint":"string", "EditIndicator":true, "EndDate":"2000-01-01T00:00:00.000Z", "GeoArea":123, "Id":123, "Inactive":true, "IsFromAffiliation":true, "Label":true, "Months":"string", "NcoaAction":123, "NcoaSession":123, "PostalCode":"string", "PostalCodeFormatted":"string", "PrimaryIndicator":true, "StartDate":"2000-01-01T00:00:00.000Z", "State":{"Id":123}, "Street1":"string", "Street1Address":{"Number":"string", "Street":"string"}, "Street2":"string", "Street3":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "AddressID":"string"}
[{"AddressID":"string","AddressType.Id":123,"AffiliatedConstituent.Id":123,"AltSalutationType.Id":123,"City":"string","Constituent.Id":123,"Country.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DeliveryPoint":"string","EditIndicator":true,"EndDate":"2000-01-01T00:00:00.000Z","GeoArea":123,"Id":123,"Inactive":true,"IsFromAffiliation":true,"Label":true,"Months":"string","NcoaAction":123,"NcoaSession":123,"PostalCode":"string","PostalCodeFormatted":"string","PrimaryIndicator":true,"StartDate":"2000-01-01T00:00:00.000Z","State.Id":123,"Street1":"string","Street1Address.Number":"string","Street1Address.Street":"string","Street2":"string","Street3":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
AddressID,AddressType.Id,AffiliatedConstituent.Id,AltSalutationType.Id,City,Constituent.Id,Country.Id,CreateLocation,CreatedBy,CreatedDateTime,DeliveryPoint,EditIndicator,EndDate,GeoArea,Id,Inactive,IsFromAffiliation,Label,Months,NcoaAction,NcoaSession,PostalCode,PostalCodeFormatted,PrimaryIndicator,StartDate,State.Id,Street1,Street1Address.Number,Street1Address.Street,Street2,Street3,UpdatedBy,UpdatedDateTime
"""string""",123,123,123,"""string""",123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""",true,"""2000-01-01T00:00:00.000Z""",123,123,true,true,true,"""string""",123,123,"""string""","""string""",true,"""2000-01-01T00:00:00.000Z""",123,"""string""","""string""","""string""","""string""","""string""","""string""","""2000-01-01T00:00:00.000Z"""

AffiliationTypes
getpost

Update an existing affiliation type.

Usage:
tq put AffiliationTypes
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "IsAllowedToTransactDefault":true, "IsIncludedInSearchResultsDefault":true, "RelationshipCategory":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "UseSalary":true, "UseTitle":true, "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"IsAllowedToTransactDefault":true,"IsIncludedInSearchResultsDefault":true,"RelationshipCategory.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","UseSalary":true,"UseTitle":true}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,IsAllowedToTransactDefault,IsIncludedInSearchResultsDefault,RelationshipCategory.Id,UpdatedBy,UpdatedDateTime,UseSalary,UseTitle
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,true,true,123,"""string""","""2000-01-01T00:00:00.000Z""",true,true

Affiliations
getpost

Update an affiliation.

Usage:
tq put Affiliations
Query:
{"AddressId":123, "AffiliatedName":"string", "AffiliationType":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "EditIndicator":true, "ElectronicAddressId":123, "EndDate":"2000-01-01T00:00:00.000Z", "GroupConstituent":{"Id":123}, "GroupConstituentName":"string", "GroupConstituentSortName":"string", "Id":123, "Inactive":true, "IndividualConstituent":{"Id":123}, "IndividualConstituentName":"string", "IndividualConstituentSortName":"string", "IsAllowedToTransact":true, "IsIncludedInSearchResults":true, "NameIndicator":123, "Note":"string", "PrimaryIndicator":true, "Salary":123.456, "SalutationId":123, "StartDate":"2000-01-01T00:00:00.000Z", "Title":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "AffiliationID":"string"}
[{"AddressId":123,"AffiliatedName":"string","AffiliationID":"string","AffiliationType.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","EditIndicator":true,"ElectronicAddressId":123,"EndDate":"2000-01-01T00:00:00.000Z","GroupConstituent.Id":123,"GroupConstituentName":"string","GroupConstituentSortName":"string","Id":123,"Inactive":true,"IndividualConstituent.Id":123,"IndividualConstituentName":"string","IndividualConstituentSortName":"string","IsAllowedToTransact":true,"IsIncludedInSearchResults":true,"NameIndicator":123,"Note":"string","PrimaryIndicator":true,"Salary":123.456,"SalutationId":123,"StartDate":"2000-01-01T00:00:00.000Z","Title":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
AddressId,AffiliatedName,AffiliationID,AffiliationType.Id,CreateLocation,CreatedBy,CreatedDateTime,EditIndicator,ElectronicAddressId,EndDate,GroupConstituent.Id,GroupConstituentName,GroupConstituentSortName,Id,Inactive,IndividualConstituent.Id,IndividualConstituentName,IndividualConstituentSortName,IsAllowedToTransact,IsIncludedInSearchResults,NameIndicator,Note,PrimaryIndicator,Salary,SalutationId,StartDate,Title,UpdatedBy,UpdatedDateTime
123,"""string""","""string""",123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",true,123,"""2000-01-01T00:00:00.000Z""",123,"""string""","""string""",123,true,123,"""string""","""string""",true,true,123,"""string""",true,123.456,123,"""2000-01-01T00:00:00.000Z""","""string""","""string""","""2000-01-01T00:00:00.000Z"""

AliasTypes
getpost

Update an existing alias type.

Usage:
tq put AliasTypes
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

Aliases
getpost

Update an alias.

Usage:
tq put Aliases
Query:
{"AliasFirstName":"string", "AliasLastName":"string", "AliasType":{"Id":123}, "Constituent":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "EditIndicator":true, "Id":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "AliasID":"string"}
[{"AliasFirstName":"string","AliasID":"string","AliasLastName":"string","AliasType.Id":123,"Constituent.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","EditIndicator":true,"Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
AliasFirstName,AliasID,AliasLastName,AliasType.Id,Constituent.Id,CreateLocation,CreatedBy,CreatedDateTime,EditIndicator,Id,UpdatedBy,UpdatedDateTime
"""string""","""string""","""string""",123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",true,123,"""string""","""2000-01-01T00:00:00.000Z"""

AnalyticsReports
getpost

Update SSRS Reports for display in Analytics.

Usage:
tq put AnalyticsReports
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Division":{"Id":"string"}, "Id":123, "Inactive":true, "ReportPath":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "AnalyticsReportID":"string"}
[{"AnalyticsReportID":"string","CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","Division.Id":"string","Id":123,"Inactive":true,"ReportPath":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
AnalyticsReportID,CreateLocation,CreatedBy,CreatedDateTime,Description,Division.Id,Id,Inactive,ReportPath,UpdatedBy,UpdatedDateTime
"""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

AppScreenTexts
get

Create or update a new App Screen Text.

Usage:
tq put AppScreenTexts
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "Name":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "Value":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Id":123,"Name":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","Value":"string"}]
CreateLocation,CreatedBy,CreatedDateTime,Id,Name,UpdatedBy,UpdatedDateTime,Value
"""string""","""string""","""2000-01-01T00:00:00.000Z""",123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string"""

AppealCategories
getpost

Update an existing appeal category.

Usage:
tq put AppealCategories
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

Artists
getpost

Update an existing artist.

Usage:
tq put Artists
Query:
{"Bio":"string", "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "FirstName":"string", "Id":123, "LastName":"string", "MiddleName":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "VoiceId":123, "ArtistID":"string"}
[{"ArtistID":"string","Bio":"string","CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","FirstName":"string","Id":123,"LastName":"string","MiddleName":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","VoiceId":123}]
ArtistID,Bio,CreateLocation,CreatedBy,CreatedDateTime,FirstName,Id,LastName,MiddleName,UpdatedBy,UpdatedDateTime,VoiceId
"""string""","""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""",123,"""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""",123

AssetTypes
getpost

Update an existing asset type.

Usage:
tq put AssetTypes
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

Assets
getpost

Update an existing asset for a constituent.

Usage:
tq put Assets
Query:
{"AcquisitionDateTime":"2000-01-01T00:00:00.000Z", "AssetType":{"Id":123}, "Constituent":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "EditIndicator":true, "EstimatedValue":123.456, "Id":123, "Notes":"string", "SaleDateTime":"2000-01-01T00:00:00.000Z", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "AssetID":"string"}
[{"AcquisitionDateTime":"2000-01-01T00:00:00.000Z","AssetID":"string","AssetType.Id":123,"Constituent.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","EditIndicator":true,"EstimatedValue":123.456,"Id":123,"Notes":"string","SaleDateTime":"2000-01-01T00:00:00.000Z","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
AcquisitionDateTime,AssetID,AssetType.Id,Constituent.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,EditIndicator,EstimatedValue,Id,Notes,SaleDateTime,UpdatedBy,UpdatedDateTime
"""2000-01-01T00:00:00.000Z""","""string""",123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""",true,123.456,123,"""string""","""2000-01-01T00:00:00.000Z""","""string""","""2000-01-01T00:00:00.000Z"""

AssociationTypes
getpost

Update an existing association type.

Usage:
tq put AssociationTypes
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "IsIncludedInSearchResultsDefault":true, "ReciprocalType":{"Id":123}, "RelationshipCategory":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "UseBirthDate":true, "UseGender":true, "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"IsIncludedInSearchResultsDefault":true,"ReciprocalType.Id":123,"RelationshipCategory.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","UseBirthDate":true,"UseGender":true}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,IsIncludedInSearchResultsDefault,ReciprocalType.Id,RelationshipCategory.Id,UpdatedBy,UpdatedDateTime,UseBirthDate,UseGender
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,true,123,123,"""string""","""2000-01-01T00:00:00.000Z""",true,true

Associations
getpost

Update a association.

Usage:
tq put Associations
Query:
{"AssociatedConstituent":{"Id":123}, "AssociatedName":"string", "AssociationType":{"Id":123}, "BirthDate":"2000-01-01T00:00:00.000Z", "Constituent":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "EditIndicator":true, "EndDate":"2000-01-01T00:00:00.000Z", "Gender":{"Id":123}, "Id":123, "Inactive":true, "IsIncludedInSearchResults":true, "Note":"string", "ReciprocalAssociation":{"Id":123}, "StartDate":"2000-01-01T00:00:00.000Z", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "AssociationID":"string"}
[{"AssociatedConstituent.Id":123,"AssociatedName":"string","AssociationID":"string","AssociationType.Id":123,"BirthDate":"2000-01-01T00:00:00.000Z","Constituent.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","EditIndicator":true,"EndDate":"2000-01-01T00:00:00.000Z","Gender.Id":123,"Id":123,"Inactive":true,"IsIncludedInSearchResults":true,"Note":"string","ReciprocalAssociation.Id":123,"StartDate":"2000-01-01T00:00:00.000Z","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
AssociatedConstituent.Id,AssociatedName,AssociationID,AssociationType.Id,BirthDate,Constituent.Id,CreateLocation,CreatedBy,CreatedDateTime,EditIndicator,EndDate,Gender.Id,Id,Inactive,IsIncludedInSearchResults,Note,ReciprocalAssociation.Id,StartDate,UpdatedBy,UpdatedDateTime
123,"""string""","""string""",123,"""2000-01-01T00:00:00.000Z""",123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",true,"""2000-01-01T00:00:00.000Z""",123,123,true,true,"""string""",123,"""2000-01-01T00:00:00.000Z""","""string""","""2000-01-01T00:00:00.000Z"""

Attributes
getpost

Update an attribute.

Usage:
tq put Attributes
Query:
{"Constituent":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "EditIndicator":true, "Id":123, "Keyword":{"Id":123}, "KeywordConstituentType":{"Inactive":true, "Rank":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "Value":"string", "AttributeID":"string"}
[{"AttributeID":"string","Constituent.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","EditIndicator":true,"Id":123,"Keyword.Id":123,"KeywordConstituentType.Inactive":true,"KeywordConstituentType.Rank":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","Value":"string"}]
AttributeID,Constituent.Id,CreateLocation,CreatedBy,CreatedDateTime,EditIndicator,Id,Keyword.Id,KeywordConstituentType.Inactive,KeywordConstituentType.Rank,UpdatedBy,UpdatedDateTime,Value
"""string""",123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",true,123,123,true,123,"""string""","""2000-01-01T00:00:00.000Z""","""string"""

Authorization
post

NOTE: THIS IS FOR TESSITURA USE ONLY. Custom implementations of this endpoint are not supported. Expire a payment link which has yet to be authorized or already expired. For Tessitura Merchant Services only.

Usage:
tq put Authorization
Query:

B

BatchTypeGroups
getpost

Update an existing batch type group.

Usage:
tq put BatchTypeGroups
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

BatchTypes
getpost

Update an existing batch type.

Usage:
tq put BatchTypes
Query:
{"BatchTypeGroup":{"Id":123}, "BusinessUnit":{"Id":123}, "Category":123, "CntlIndicator":true, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"BatchTypeGroup.Id":123,"BusinessUnit.Id":123,"Category":123,"CntlIndicator":true,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
BatchTypeGroup.Id,BusinessUnit.Id,Category,CntlIndicator,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,123,123,true,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

BillingSchedules
getpost

Update an existing Billing Schedule.

Usage:
tq put BillingSchedules
Query:
{"BillAmounts":"string", "BillDates":"string", "ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "LongDescription":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"BillAmounts":"string","BillDates":"string","ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"LongDescription":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
BillAmounts,BillDates,ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,LongDescription,UpdatedBy,UpdatedDateTime
"""string""","""string""",123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

BillingTypes
getpost

Update an existing Billing Type.

Usage:
tq put BillingTypes
Query:
{"AutoBillingIndicator":"string", "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"AutoBillingIndicator":"string","CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
AutoBillingIndicator,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

BookingCategories
getpost

Update an existing Booking Category.

Usage:
tq put BookingCategories
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "EditIndicator":true, "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","EditIndicator":true,"ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,EditIndicator,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""",true,"""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

BookingTemplates
getpost

Update an existing Booking Template

Usage:
tq put BookingTemplates
Query:
{"Assignments":[{"Id":123}, ...], "Category":{"Id":123}, "ConfirmationText":"string", "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "EditIndicator":true, "Id":123, "Inactive":true, "Notes":"string", "OverrideTime":"2000-01-01T00:00:00.000Z", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "BookingTemplateID":"string"}


Bookings
getpost

Update an existing Booking

Usage:
tq put Bookings
Query:
{"Assignments":[{"Id":123}, ...], "BookingSource":123, "Category":{"Id":123}, "ConfirmationText":"string", "Context":{}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DefaultCount":123, "DefaultDateTime":"2000-01-01T00:00:00.000Z", "DefaultDuration":123, "Description":"string", "EditIndicator":true, "Id":123, "Notes":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "BookingID":"string"}


BulkCopySets
getpost

Updates an existing bulk copy set.

Usage:
tq put BulkCopySets
Query:
{"AvailableForSaleIndicator":true, "ControlGroup":{"Id":123}, "CopyCredits":true, "CopyNotes":true, "CopyOffers":true, "CopyPriceEvents":true, "CopyPrices":true, "CreateFriday":true, "CreateFromDateTime":"2000-01-01T00:00:00.000Z", "CreateLocation":"string", "CreateMode":"string", "CreateMonday":true, "CreateSaturday":true, "CreateSunday":true, "CreateThursday":true, "CreateToDateTime":"2000-01-01T00:00:00.000Z", "CreateTuesday":true, "CreateWednesday":true, "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DefaultRelativeDates":"string", "Id":123, "Inactive":true, "OverrideOnSale":true, "PackageCode":"string", "PackageCodeSeed":123, "PackageModeOfSaleRelativeDates":"string", "PerformanceCode":"string", "PerformanceCodeSeed":123, "PerformanceDescription":"string", "PerformanceModeOfSaleRelativeDates":"string", "PerformanceStatus":{"Id":123}, "PerformanceTime":"string", "PerformanceType":{"Id":123}, "PriceEventRelativeDates":"string", "PriceTypeRelativeDates":"string", "ProductionSeason":{"Id":123}, "PublishRelativeDates":"string", "ReferenceDay":"2000-01-01T00:00:00.000Z", "ReferencePerformanceId":123, "ReferenceSeasonString":"string", "SetDescription":"string", "SetType":123, "ShortName":"string", "TimeSlot":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "BulkCopySetID":"string"}
[{"AvailableForSaleIndicator":true,"BulkCopySetID":"string","ControlGroup.Id":123,"CopyCredits":true,"CopyNotes":true,"CopyOffers":true,"CopyPriceEvents":true,"CopyPrices":true,"CreateFriday":true,"CreateFromDateTime":"2000-01-01T00:00:00.000Z","CreateLocation":"string","CreateMode":"string","CreateMonday":true,"CreateSaturday":true,"CreateSunday":true,"CreateThursday":true,"CreateToDateTime":"2000-01-01T00:00:00.000Z","CreateTuesday":true,"CreateWednesday":true,"CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DefaultRelativeDates":"string","Id":123,"Inactive":true,"OverrideOnSale":true,"PackageCode":"string","PackageCodeSeed":123,"PackageModeOfSaleRelativeDates":"string","PerformanceCode":"string","PerformanceCodeSeed":123,"PerformanceDescription":"string","PerformanceModeOfSaleRelativeDates":"string","PerformanceStatus.Id":123,"PerformanceTime":"string","PerformanceType.Id":123,"PriceEventRelativeDates":"string","PriceTypeRelativeDates":"string","ProductionSeason.Id":123,"PublishRelativeDates":"string","ReferenceDay":"2000-01-01T00:00:00.000Z","ReferencePerformanceId":123,"ReferenceSeasonString":"string","SetDescription":"string","SetType":123,"ShortName":"string","TimeSlot.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
AvailableForSaleIndicator,BulkCopySetID,ControlGroup.Id,CopyCredits,CopyNotes,CopyOffers,CopyPriceEvents,CopyPrices,CreateFriday,CreateFromDateTime,CreateLocation,CreateMode,CreateMonday,CreateSaturday,CreateSunday,CreateThursday,CreateToDateTime,CreateTuesday,CreateWednesday,CreatedBy,CreatedDateTime,DefaultRelativeDates,Id,Inactive,OverrideOnSale,PackageCode,PackageCodeSeed,PackageModeOfSaleRelativeDates,PerformanceCode,PerformanceCodeSeed,PerformanceDescription,PerformanceModeOfSaleRelativeDates,PerformanceStatus.Id,PerformanceTime,PerformanceType.Id,PriceEventRelativeDates,PriceTypeRelativeDates,ProductionSeason.Id,PublishRelativeDates,ReferenceDay,ReferencePerformanceId,ReferenceSeasonString,SetDescription,SetType,ShortName,TimeSlot.Id,UpdatedBy,UpdatedDateTime
true,"""string""",123,true,true,true,true,true,true,"""2000-01-01T00:00:00.000Z""","""string""","""string""",true,true,true,true,"""2000-01-01T00:00:00.000Z""",true,true,"""string""","""2000-01-01T00:00:00.000Z""","""string""",123,true,true,"""string""",123,"""string""","""string""",123,"""string""","""string""",123,"""string""",123,"""string""","""string""",123,"""string""","""2000-01-01T00:00:00.000Z""",123,"""string""","""string""",123,"""string""",123,"""string""","""2000-01-01T00:00:00.000Z"""

BulkDailyCopyExclusions
getpost

Updates an existing bulk daily copy exclusion.

Usage:
tq put BulkDailyCopyExclusions
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DoNotCopy":true, "Id":123, "IncludeWithoutCopy":true, "PackageId":123, "PerformanceId":123, "SetId":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "BulkDailyCopyExclusionID":"string"}
[{"BulkDailyCopyExclusionID":"string","CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DoNotCopy":true,"Id":123,"IncludeWithoutCopy":true,"PackageId":123,"PerformanceId":123,"SetId":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
BulkDailyCopyExclusionID,CreateLocation,CreatedBy,CreatedDateTime,DoNotCopy,Id,IncludeWithoutCopy,PackageId,PerformanceId,SetId,UpdatedBy,UpdatedDateTime
"""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""",true,123,true,123,123,123,"""string""","""2000-01-01T00:00:00.000Z"""

BusinessUnits
getpost

Update an existing business unit.

Usage:
tq put BusinessUnits
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

C

CampaignDesignations
getpost

Update an association between a Designation and a Campaign.

Usage:
tq put CampaignDesignations
Query:
{"Campaign":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DefaultIndicator":true, "Designation":{"Id":123}, "EditIndicator":true, "GoalAmount":123.456, "Id":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "CampaignDesignationID":"string"}
[{"Campaign.Id":123,"CampaignDesignationID":"string","CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DefaultIndicator":true,"Designation.Id":123,"EditIndicator":true,"GoalAmount":123.456,"Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
Campaign.Id,CampaignDesignationID,CreateLocation,CreatedBy,CreatedDateTime,DefaultIndicator,Designation.Id,EditIndicator,GoalAmount,Id,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""",true,123,true,123.456,123,"""string""","""2000-01-01T00:00:00.000Z"""

CampaignFunds
getpost

Update a Fund association to a Campaign.

Usage:
tq put CampaignFunds
Query:
{"Campaign":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "EditIndicator":true, "EndDateTime":"2000-01-01T00:00:00.000Z", "Fund":{"Id":123}, "GoalAmount":123.456, "Id":123, "StartDateTime":"2000-01-01T00:00:00.000Z", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "CampaignFundID":"string"}
[{"Campaign.Id":123,"CampaignFundID":"string","CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","EditIndicator":true,"EndDateTime":"2000-01-01T00:00:00.000Z","Fund.Id":123,"GoalAmount":123.456,"Id":123,"StartDateTime":"2000-01-01T00:00:00.000Z","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
Campaign.Id,CampaignFundID,CreateLocation,CreatedBy,CreatedDateTime,EditIndicator,EndDateTime,Fund.Id,GoalAmount,Id,StartDateTime,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""",true,"""2000-01-01T00:00:00.000Z""",123,123.456,123,"""2000-01-01T00:00:00.000Z""","""string""","""2000-01-01T00:00:00.000Z"""

CardReaderTypes
getpost

Update an existing Card Reader Type.

Usage:
tq put CardReaderTypes
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

Cart
getpost

Applies a discounted price to all sub line items for a line item For packages, the discount can only be applied to package line items. The status field in the response will return as S if the discount can be used or E with a description of the error if the discount cannot be used.

Usage:
tq put Cart
Query:
{"LineItemID":"string", "DiscountTypeId":123, "SessionKey":"string"}
[{"DiscountTypeId":123,"LineItemID":"string","SessionKey":"string"}]
DiscountTypeId,LineItemID,SessionKey
123,"""string""","""string"""

Flags:

  • --ApplySubLineItemDiscount
    Applies a discounted price to a sub line item

The status field in the response will return as S if the discount can be used or E with a description of the error if the discount cannot be used.

Query:
{"DiscountTypeId":123, "SessionKey":"string", "SubLineItemID":"string"}
[{"DiscountTypeId":123,"SessionKey":"string","SubLineItemID":"string"}]
DiscountTypeId,SessionKey,SubLineItemID
123,"""string""","""string"""

  • --CartFlags
    Updates flags on the cart
Query:
{"ShouldCalculateFees":true, "ShouldCalculatePrices":true, "SessionKey":"string"}
[{"SessionKey":"string","ShouldCalculateFees":true,"ShouldCalculatePrices":true}]
SessionKey,ShouldCalculateFees,ShouldCalculatePrices
"""string""",true,true

  • --CartProperties
    Updates cart properties See the notes on the request for specific documentation on each item that can be set.
    Before making a request to PUT cart properties, you should make a GET request to obtain all current property values. Make updates to any of the properties that need changing, and pass the entire cart properties object back into your put request. This ensures that all property values that are set, but should not change, persist and are not overwritten unintentioanlly.
Query:
{"AddressId":123, "CategoryId":123, "ChannelId":123, "DeliveryMethodId":123, "ElectronicAddressId":123, "HoldUntilDateTime":"2000-01-01T00:00:00.000Z", "InitiatorId":123, "ModeOfSaleId":123, "Notes":"string", "OrderDateTime":"2000-01-01T00:00:00.000Z", "PhoneId":123, "Solicitor":"string", "SourceId":123, "SessionKey":"string"}
[{"AddressId":123,"CategoryId":123,"ChannelId":123,"DeliveryMethodId":123,"ElectronicAddressId":123,"HoldUntilDateTime":"2000-01-01T00:00:00.000Z","InitiatorId":123,"ModeOfSaleId":123,"Notes":"string","OrderDateTime":"2000-01-01T00:00:00.000Z","PhoneId":123,"SessionKey":"string","Solicitor":"string","SourceId":123}]
AddressId,CategoryId,ChannelId,DeliveryMethodId,ElectronicAddressId,HoldUntilDateTime,InitiatorId,ModeOfSaleId,Notes,OrderDateTime,PhoneId,SessionKey,Solicitor,SourceId
123,123,123,123,123,"""2000-01-01T00:00:00.000Z""",123,123,"""string""","""2000-01-01T00:00:00.000Z""",123,"""string""","""string""",123

  • --CartPropertiesCustomData
    Updates a custom data value in the cart properties Note: Only the Index and Value properties in the request should be used.
Query:
{"DataType":"string", "Description":"string", "EditIndicator":true, "Index":123, "IsDropdown":true, "KeywordId":123, "Name":"string", "Value":"string", "CustomID":"string", "SessionKey":"string"}
[{"CustomID":"string","DataType":"string","Description":"string","EditIndicator":true,"Index":123,"IsDropdown":true,"KeywordId":123,"Name":"string","SessionKey":"string","Value":"string"}]
CustomID,DataType,Description,EditIndicator,Index,IsDropdown,KeywordId,Name,SessionKey,Value
"""string""","""string""","""string""",true,123,true,123,"""string""","""string""","""string"""

  • --ContributionCustomData
    Updates a custom data value for a contribution in the cart Note: Only the Index and Value properties in the request object should be used.
Query:
{"DataType":"string", "Description":"string", "EditIndicator":true, "Index":123, "IsDropdown":true, "KeywordId":123, "Name":"string", "Value":"string", "CustomID":"string", "LineItemID":"string", "SessionKey":"string"}
[{"CustomID":"string","DataType":"string","Description":"string","EditIndicator":true,"Index":123,"IsDropdown":true,"KeywordId":123,"LineItemID":"string","Name":"string","SessionKey":"string","Value":"string"}]
CustomID,DataType,Description,EditIndicator,Index,IsDropdown,KeywordId,LineItemID,Name,SessionKey,Value
"""string""","""string""","""string""",true,123,true,123,"""string""","""string""","""string""","""string"""

  • --LineItemPrice
    Updates the price on all sub line items for the line item A price can only be edited if the price type has been marked as editable, zones on the price map have been designated as editable, and the seat is in one of the editable zones. The status field in the response will return as S if the price can be applied or E with a description of the error if the price cannot be applied.
Query:
{"LineItemID":"string", "NewPrice":123.456, "SessionKey":"string"}
[{"LineItemID":"string","NewPrice":123.456,"SessionKey":"string"}]
LineItemID,NewPrice,SessionKey
"""string""",123.456,"""string"""

  • --LineItemPriceType
    Updates the price type on all sub line items for a given lineitem Can be filtered by those have a current price type as specified by OriginalPriceType
Query:
{"LineItemID":"string", "NewPriceType":123, "NewPriceTypeReason":123, "OriginalPriceType":123, "SessionKey":"string"}
[{"LineItemID":"string","NewPriceType":123,"NewPriceTypeReason":123,"OriginalPriceType":123,"SessionKey":"string"}]
LineItemID,NewPriceType,NewPriceTypeReason,OriginalPriceType,SessionKey
"""string""",123,123,123,"""string"""

  • --LineItemSource
    Updates the source on a line item Allows the source of an individual line to be updated. When a line is created, by reserving a tickets for a performance or package, the line source is copied from the session source. This method allows the line source to be updated. Offers and Pricing Rules consider line source, not the session source.
Query:
{"LineItemID":"string", "SourceId":123, "SessionKey":"string"}
[{"LineItemID":"string","SessionKey":"string","SourceId":123}]
LineItemID,SessionKey,SourceId
"""string""","""string""",123

  • --LineItemSpecialRequest
    Updates Special Request info on a line item
Query:
{"LineItemID":"string", "AisleSeat":"string", "Category":{"Id":123}, "ContiguousSeats":123, "EndPrice":123.456, "EndingRow":"string", "EndingSeat":"string", "HoldCode":123, "LeaveSingleSeats":true, "NoStairs":true, "Notes":"string", "StartPrice":123.456, "StartingRow":"string", "StartingSeat":"string", "WheelchairSeats":123, "SessionKey":"string"}
[{"AisleSeat":"string","Category.Id":123,"ContiguousSeats":123,"EndPrice":123.456,"EndingRow":"string","EndingSeat":"string","HoldCode":123,"LeaveSingleSeats":true,"LineItemID":"string","NoStairs":true,"Notes":"string","SessionKey":"string","StartPrice":123.456,"StartingRow":"string","StartingSeat":"string","WheelchairSeats":123}]
AisleSeat,Category.Id,ContiguousSeats,EndPrice,EndingRow,EndingSeat,HoldCode,LeaveSingleSeats,LineItemID,NoStairs,Notes,SessionKey,StartPrice,StartingRow,StartingSeat,WheelchairSeats
"""string""",123,123,123.456,"""string""","""string""",123,true,"""string""",true,"""string""","""string""",123.456,"""string""","""string""",123

  • --PaymentPlan
    Allows the billing and credit card information to be updated on an existing payment plan for the cart.
Query:
{"AccountId":123, "BillingTypeId":123, "Card":{"ExpiryMonth":123, "ExpiryYear":123, "Name":"string", "Number":"string", "PaymentMethodGroupId":123}, "SessionKey":"string"}
[{"AccountId":123,"BillingTypeId":123,"Card.ExpiryMonth":123,"Card.ExpiryYear":123,"Card.Name":"string","Card.Number":"string","Card.PaymentMethodGroupId":123,"SessionKey":"string"}]
AccountId,BillingTypeId,Card.ExpiryMonth,Card.ExpiryYear,Card.Name,Card.Number,Card.PaymentMethodGroupId,SessionKey
123,123,123,123,"""string""","""string""",123,"""string"""

  • --SubLineItemPrice
    Updates the price on a sub line item. A price can only be edited if the price type has been marked as editable, zones on the price map have been designated as editable, and the seat is in one of the editable zones. The status field in the response will return as S if the price can be applied or E with a description of the error if the price cannot be applied.
Query:
{"NewPrice":123.456, "SessionKey":"string", "SubLineItemID":"string"}
[{"NewPrice":123.456,"SessionKey":"string","SubLineItemID":"string"}]
NewPrice,SessionKey,SubLineItemID
123.456,"""string""","""string"""

  • --SubLineItemPriceType
    Updates the price type on a sub line item
Query:
{"NewPriceType":123, "NewPriceTypeReason":123, "OriginalPriceType":123, "SessionKey":"string", "SubLineItemID":"string"}
[{"NewPriceType":123,"NewPriceTypeReason":123,"OriginalPriceType":123,"SessionKey":"string","SubLineItemID":"string"}]
NewPriceType,NewPriceTypeReason,OriginalPriceType,SessionKey,SubLineItemID
123,123,123,"""string""","""string"""

  • --SubLineItemRecipient
    Updates the recipient on a sub line item
Query:
{"RecipientId":123, "SessionKey":"string", "SubLineItemID":"string"}
[{"RecipientId":123,"SessionKey":"string","SubLineItemID":"string"}]
RecipientId,SessionKey,SubLineItemID
123,"""string""","""string"""

Colors
getpost

Update an existing color.

Usage:
tq put Colors
Query:
{"ColorValue":123, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ColorValue":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ColorValue,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,"""string""","""2000-01-01T00:00:00.000Z"""

Composers
getpost

Update an existing composer.

Usage:
tq put Composers
Query:
{"Bio":"string", "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "FirstName":"string", "Id":123, "Inactive":true, "LastName":"string", "MiddleName":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"Bio":"string","CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","FirstName":"string","ID":"string","Id":123,"Inactive":true,"LastName":"string","MiddleName":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
Bio,CreateLocation,CreatedBy,CreatedDateTime,FirstName,ID,Id,Inactive,LastName,MiddleName,UpdatedBy,UpdatedDateTime
"""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""string""","""string""","""2000-01-01T00:00:00.000Z"""

Constituencies
getpost

Update a constituency.

Usage:
tq put Constituencies
Query:
{"ConstituencyType":{"Id":123}, "Constituent":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "EditIndicator":true, "EndDate":"2000-01-01T00:00:00.000Z", "Id":123, "StartDate":"2000-01-01T00:00:00.000Z", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ConstituencyID":"string"}
[{"ConstituencyID":"string","ConstituencyType.Id":123,"Constituent.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","EditIndicator":true,"EndDate":"2000-01-01T00:00:00.000Z","Id":123,"StartDate":"2000-01-01T00:00:00.000Z","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ConstituencyID,ConstituencyType.Id,Constituent.Id,CreateLocation,CreatedBy,CreatedDateTime,EditIndicator,EndDate,Id,StartDate,UpdatedBy,UpdatedDateTime
"""string""",123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",true,"""2000-01-01T00:00:00.000Z""",123,"""2000-01-01T00:00:00.000Z""","""string""","""2000-01-01T00:00:00.000Z"""

ConstituencyTypes
getpost

Update an existing constituency type.

Usage:
tq put ConstituencyTypes
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "Rank":123, "ShortDescription":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"Rank":123,"ShortDescription":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,Rank,ShortDescription,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,123,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

ConstituentDocuments
getpost

Update an existing document for a constituent.

Usage:
tq put ConstituentDocuments
Query:
{"Category":{"Id":123}, "ConstituentId":123, "Contents":"AA==", "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "FileName":"string", "Id":123, "Notes":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "DocumentID":"string"}
[{"Category.Id":123,"ConstituentId":123,"Contents":"AA==","CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","DocumentID":"string","FileName":"string","Id":123,"Notes":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
Category.Id,ConstituentId,Contents,CreateLocation,CreatedBy,CreatedDateTime,Description,DocumentID,FileName,Id,Notes,UpdatedBy,UpdatedDateTime
123,123,"""AA==""","""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""","""string""",123,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

ConstituentGroups
getpost

Update an existing constituent group.

Usage:
tq put ConstituentGroups
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

ConstituentInactives
getpost

Update an existing constituent inactive.

Usage:
tq put ConstituentInactives
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

ConstituentProtectionTypes
getpost

Update an existing constituent protection type.

Usage:
tq put ConstituentProtectionTypes
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

ConstituentTypeAffiliates
getpost

Update an existing constituent type affiliate.

Usage:
tq put ConstituentTypeAffiliates
Query:
{"AffiliationType":{"Id":123}, "ConstituentType":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "HouseholdPrimary":true, "Id":123, "Rank":123, "ShowWithGroup":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"AffiliationType.Id":123,"ConstituentType.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","HouseholdPrimary":true,"ID":"string","Id":123,"Rank":123,"ShowWithGroup":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
AffiliationType.Id,ConstituentType.Id,CreateLocation,CreatedBy,CreatedDateTime,HouseholdPrimary,ID,Id,Rank,ShowWithGroup,UpdatedBy,UpdatedDateTime
123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",true,"""string""",123,123,true,"""string""","""2000-01-01T00:00:00.000Z"""

ConstituentTypes
getpost

Update an existing constituent type.

Usage:
tq put ConstituentTypes
Query:
{"AddressTypeId":123, "ConstituentGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DefaultAffiliatedConstituentTypeId":123, "DefaultAffiliationTypeId":123, "DefaultIndicator":true, "DefaultSalutationId":123, "Description":"string", "ElectronicAddressTypeId":123, "GiftAidIndicator":true, "Id":123, "Inactive":true, "LoginTypeId":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"AddressTypeId":123,"ConstituentGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DefaultAffiliatedConstituentTypeId":123,"DefaultAffiliationTypeId":123,"DefaultIndicator":true,"DefaultSalutationId":123,"Description":"string","ElectronicAddressTypeId":123,"GiftAidIndicator":true,"ID":"string","Id":123,"Inactive":true,"LoginTypeId":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
AddressTypeId,ConstituentGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,DefaultAffiliatedConstituentTypeId,DefaultAffiliationTypeId,DefaultIndicator,DefaultSalutationId,Description,ElectronicAddressTypeId,GiftAidIndicator,ID,Id,Inactive,LoginTypeId,UpdatedBy,UpdatedDateTime
123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",123,123,true,123,"""string""",123,true,"""string""",123,true,123,"""string""","""2000-01-01T00:00:00.000Z"""

Constituents
getpost

Update a constituent. Only the information about constituent can be updated. If addresses, electronicAddresses, salutations or phones data are passed, they will be ignored.

Usage:
tq put Constituents
Query:
{"ConstituentType":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DisplayName":"string", "EmarketIndicator":{"Id":123}, "FirstName":"string", "Gender":{"Id":123}, "Id":123, "Inactive":{"Id":123}, "InactiveReason":{"Id":123}, "LastActivityDate":"2000-01-01T00:00:00.000Z", "LastGiftDate":"2000-01-01T00:00:00.000Z", "LastName":"string", "LastTicketDate":"2000-01-01T00:00:00.000Z", "MailIndicator":{"Id":123}, "MiddleName":"string", "NameStatus":{"Id":123}, "OriginalSource":{"Id":123}, "PhoneIndicator":{"Id":123}, "Prefix":{"Id":123}, "ProtectionType":{"Id":123}, "SortName":"string", "Suffix":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ConstituentID":"string"}
[{"ConstituentID":"string","ConstituentType.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DisplayName":"string","EmarketIndicator.Id":123,"FirstName":"string","Gender.Id":123,"Id":123,"Inactive.Id":123,"InactiveReason.Id":123,"LastActivityDate":"2000-01-01T00:00:00.000Z","LastGiftDate":"2000-01-01T00:00:00.000Z","LastName":"string","LastTicketDate":"2000-01-01T00:00:00.000Z","MailIndicator.Id":123,"MiddleName":"string","NameStatus.Id":123,"OriginalSource.Id":123,"PhoneIndicator.Id":123,"Prefix.Id":123,"ProtectionType.Id":123,"SortName":"string","Suffix.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ConstituentID,ConstituentType.Id,CreateLocation,CreatedBy,CreatedDateTime,DisplayName,EmarketIndicator.Id,FirstName,Gender.Id,Id,Inactive.Id,InactiveReason.Id,LastActivityDate,LastGiftDate,LastName,LastTicketDate,MailIndicator.Id,MiddleName,NameStatus.Id,OriginalSource.Id,PhoneIndicator.Id,Prefix.Id,ProtectionType.Id,SortName,Suffix.Id,UpdatedBy,UpdatedDateTime
"""string""",123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""",123,"""string""",123,123,123,123,"""2000-01-01T00:00:00.000Z""","""2000-01-01T00:00:00.000Z""","""string""","""2000-01-01T00:00:00.000Z""",123,"""string""",123,123,123,123,123,"""string""",123,"""string""","""2000-01-01T00:00:00.000Z"""

ContactPermissionCategories
getpost

Update an existing contact permission category.

Usage:
tq put ContactPermissionCategories
Query:
{"AskFrequencyMonths":123, "ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"AskFrequencyMonths":123,"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
AskFrequencyMonths,ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

ContactPermissionTypes
getpost

Update an existing contact permission type.

Usage:
tq put ContactPermissionTypes
Query:
{"Category":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DefaultValueForAdd":"string", "Description":"string", "EditIndicator":true, "Id":123, "Inactive":true, "Presenter":true, "Rank":123, "ShortDescription":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"Category.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DefaultValueForAdd":"string","Description":"string","EditIndicator":true,"ID":"string","Id":123,"Inactive":true,"Presenter":true,"Rank":123,"ShortDescription":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
Category.Id,CreateLocation,CreatedBy,CreatedDateTime,DefaultValueForAdd,Description,EditIndicator,ID,Id,Inactive,Presenter,Rank,ShortDescription,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",true,"""string""",123,true,true,123,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

ContactPermissions
getpost

Update a contact permission

Usage:
tq put ContactPermissions
Query:
{"Answer":"string", "Constituent":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "EditIndicator":true, "Id":123, "LastAskedDateTime":"2000-01-01T00:00:00.000Z", "ShouldAsk":true, "Type":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ContactPermissionID":"string"}
[{"Answer":"string","Constituent.Id":123,"ContactPermissionID":"string","CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","EditIndicator":true,"Id":123,"LastAskedDateTime":"2000-01-01T00:00:00.000Z","ShouldAsk":true,"Type.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
Answer,Constituent.Id,ContactPermissionID,CreateLocation,CreatedBy,CreatedDateTime,EditIndicator,Id,LastAskedDateTime,ShouldAsk,Type.Id,UpdatedBy,UpdatedDateTime
"""string""",123,"""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""",true,123,"""2000-01-01T00:00:00.000Z""",true,123,"""string""","""2000-01-01T00:00:00.000Z"""

ContactPointCategories
getpost

Update an existing contact point category.

Usage:
tq put ContactPointCategories
Query:
{"ContactPointKey":"string", "ContactPointTable":"string", "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ContactPointKey":"string","ContactPointTable":"string","CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ContactPointKey,ContactPointTable,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,UpdatedBy,UpdatedDateTime
"""string""","""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,"""string""","""2000-01-01T00:00:00.000Z"""

ContactPointCategoryPurposes
getpost

Update an existing contact point category purpose.

Usage:
tq put ContactPointCategoryPurposes
Query:
{"ContactPointCategory":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "Purpose":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ContactPointCategory.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","ID":"string","Id":123,"Purpose.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ContactPointCategory.Id,CreateLocation,CreatedBy,CreatedDateTime,ID,Id,Purpose.Id,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""",123,123,"""string""","""2000-01-01T00:00:00.000Z"""

ContactPointPurposeCategories
getpost

Update an existing contact point purpose category.

Usage:
tq put ContactPointPurposeCategories
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

ContactPointPurposeMaps
getpost

Update a contact point purpose.

Usage:
tq put ContactPointPurposeMaps
Query:
{"ContactPoint":{"Id":123}, "ContactPointCategory":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "EditIndicator":true, "Id":123, "Purpose":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ContactPointPurposeMapID":"string"}
[{"ContactPoint.Id":123,"ContactPointCategory.Id":123,"ContactPointPurposeMapID":"string","CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","EditIndicator":true,"Id":123,"Purpose.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ContactPoint.Id,ContactPointCategory.Id,ContactPointPurposeMapID,CreateLocation,CreatedBy,CreatedDateTime,EditIndicator,Id,Purpose.Id,UpdatedBy,UpdatedDateTime
123,123,"""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""",true,123,123,"""string""","""2000-01-01T00:00:00.000Z"""

ContactPointPurposes
getpost

Update an existing contact point purpose.

Usage:
tq put ContactPointPurposes
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "PurposeCategory":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"PurposeCategory.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,PurposeCategory.Id,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,123,"""string""","""2000-01-01T00:00:00.000Z"""

ContactTypes
getpost

Update an existing contact type.

Usage:
tq put ContactTypes
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

ContributionDesignations
getpost

Update an existing contribution designation.

Usage:
tq put ContributionDesignations
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "LetterText":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"LetterText":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,LetterText,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

ContributionImportSets
getpost

Update an existing contributionImportSet.

Usage:
tq put ContributionImportSets
Query:
{"AccountMatchKeyword":{"Id":123}, "AcknowledgmentLetterMode":123, "BatchType":{"Id":123}, "BillingSchedule":{"Id":123}, "BillingType":{"Id":123}, "Campaign":{"Id":123}, "ContributionDateTime":"2000-01-01T00:00:00.000Z", "ContributionPayMode":123, "CreateLocation":"string", "CreatePotentialDuplicate":true, "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "CrediteeMode":123, "CrediteeType":{"Id":123}, "DefaultConstituentType":{"Id":123}, "DefaultCountryCode":"string", "DefaultHouseholdConstituentType":{"Id":123}, "DefaultOriginalSource":{"Id":123}, "Description":"string", "Designation":{"Id":123}, "FilePath":"string", "FormatFile":"string", "Fund":{"Id":123}, "Id":123, "ImportRefNoLocation":123, "Inactive":true, "PaymentMethod":{"Id":123}, "SalesChannel":{"Id":123}, "Source":{"Id":123}, "StripPhoneFormatting":true, "TransactAsHousehold":true, "TransactAsHouseholdCreditee":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "Worker":{"Id":123}, "ID":"string"}
[{"AccountMatchKeyword.Id":123,"AcknowledgmentLetterMode":123,"BatchType.Id":123,"BillingSchedule.Id":123,"BillingType.Id":123,"Campaign.Id":123,"ContributionDateTime":"2000-01-01T00:00:00.000Z","ContributionPayMode":123,"CreateLocation":"string","CreatePotentialDuplicate":true,"CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","CrediteeMode":123,"CrediteeType.Id":123,"DefaultConstituentType.Id":123,"DefaultCountryCode":"string","DefaultHouseholdConstituentType.Id":123,"DefaultOriginalSource.Id":123,"Description":"string","Designation.Id":123,"FilePath":"string","FormatFile":"string","Fund.Id":123,"ID":"string","Id":123,"ImportRefNoLocation":123,"Inactive":true,"PaymentMethod.Id":123,"SalesChannel.Id":123,"Source.Id":123,"StripPhoneFormatting":true,"TransactAsHousehold":true,"TransactAsHouseholdCreditee":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","Worker.Id":123}]
AccountMatchKeyword.Id,AcknowledgmentLetterMode,BatchType.Id,BillingSchedule.Id,BillingType.Id,Campaign.Id,ContributionDateTime,ContributionPayMode,CreateLocation,CreatePotentialDuplicate,CreatedBy,CreatedDateTime,CrediteeMode,CrediteeType.Id,DefaultConstituentType.Id,DefaultCountryCode,DefaultHouseholdConstituentType.Id,DefaultOriginalSource.Id,Description,Designation.Id,FilePath,FormatFile,Fund.Id,ID,Id,ImportRefNoLocation,Inactive,PaymentMethod.Id,SalesChannel.Id,Source.Id,StripPhoneFormatting,TransactAsHousehold,TransactAsHouseholdCreditee,UpdatedBy,UpdatedDateTime,Worker.Id
123,123,123,123,123,123,"""2000-01-01T00:00:00.000Z""",123,"""string""",true,"""string""","""2000-01-01T00:00:00.000Z""",123,123,123,"""string""",123,123,"""string""",123,"""string""","""string""",123,"""string""",123,123,true,123,123,123,true,true,true,"""string""","""2000-01-01T00:00:00.000Z""",123

Contributions
post

This resource is currently strictly for interceptor plugin use. This is called any time an existing contribution is updated from contribution editor in the client application. Only Id (ref_no) is provided in the request content.

Usage:
tq put Contributions
Query:
{"AccountId":123, "AppealId":123, "BatchId":123, "BillingAccount":"string", "BillingTypeId":123, "BusinessUnitId":123, "Campaign":{"Id":123}, "Cancel":"string", "Channel":{"Id":123}, "Constituent":{"Id":123}, "ContributionAmount":123.456, "ContributionDateTime":"2000-01-01T00:00:00.000Z", "ContributionDesignation":123, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Custom0":"string", "Custom1":"string", "Custom2":"string", "Custom3":"string", "Custom4":"string", "Custom5":"string", "Custom6":"string", "Custom7":"string", "Custom8":"string", "Custom9":"string", "EditIndicator":true, "Fund":{"Id":123}, "Id":123, "Initiator":{"Id":123}, "KindGiftDescription":"string", "KindGiftTransferDateTime":"2000-01-01T00:00:00.000Z", "MatchIndicator":"string", "MatchingContributionId":123, "MediaType":{"Id":123}, "MirrorLock":123, "Notes":"string", "PaymentEndDateTime":"2000-01-01T00:00:00.000Z", "PaymentStartDateTime":"2000-01-01T00:00:00.000Z", "Plan":{"Id":123}, "PledgeStatusId":123, "ReceivedAmount":123.456, "Solicitor":"string", "SourceId":123, "Type":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ContributionID":"string"}
[{"AccountId":123,"AppealId":123,"BatchId":123,"BillingAccount":"string","BillingTypeId":123,"BusinessUnitId":123,"Campaign.Id":123,"Cancel":"string","Channel.Id":123,"Constituent.Id":123,"ContributionAmount":123.456,"ContributionDateTime":"2000-01-01T00:00:00.000Z","ContributionDesignation":123,"ContributionID":"string","CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Custom0":"string","Custom1":"string","Custom2":"string","Custom3":"string","Custom4":"string","Custom5":"string","Custom6":"string","Custom7":"string","Custom8":"string","Custom9":"string","EditIndicator":true,"Fund.Id":123,"Id":123,"Initiator.Id":123,"KindGiftDescription":"string","KindGiftTransferDateTime":"2000-01-01T00:00:00.000Z","MatchIndicator":"string","MatchingContributionId":123,"MediaType.Id":123,"MirrorLock":123,"Notes":"string","PaymentEndDateTime":"2000-01-01T00:00:00.000Z","PaymentStartDateTime":"2000-01-01T00:00:00.000Z","Plan.Id":123,"PledgeStatusId":123,"ReceivedAmount":123.456,"Solicitor":"string","SourceId":123,"Type":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
AccountId,AppealId,BatchId,BillingAccount,BillingTypeId,BusinessUnitId,Campaign.Id,Cancel,Channel.Id,Constituent.Id,ContributionAmount,ContributionDateTime,ContributionDesignation,ContributionID,CreateLocation,CreatedBy,CreatedDateTime,Custom0,Custom1,Custom2,Custom3,Custom4,Custom5,Custom6,Custom7,Custom8,Custom9,EditIndicator,Fund.Id,Id,Initiator.Id,KindGiftDescription,KindGiftTransferDateTime,MatchIndicator,MatchingContributionId,MediaType.Id,MirrorLock,Notes,PaymentEndDateTime,PaymentStartDateTime,Plan.Id,PledgeStatusId,ReceivedAmount,Solicitor,SourceId,Type,UpdatedBy,UpdatedDateTime
123,123,123,"""string""",123,123,123,"""string""",123,123,123.456,"""2000-01-01T00:00:00.000Z""",123,"""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""",true,123,123,123,"""string""","""2000-01-01T00:00:00.000Z""","""string""",123,123,123,"""string""","""2000-01-01T00:00:00.000Z""","""2000-01-01T00:00:00.000Z""",123,123,123.456,"""string""",123,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

ControlGroupUserGroups
getpost

Update an existing control group/user group mapping.

Usage:
tq put ControlGroupUserGroups
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DefaultIndicator":true, "EditIndicator":true, "Id":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "UserGroupId":"string", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DefaultIndicator":true,"EditIndicator":true,"ID":"string","Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","UserGroupId":"string"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,DefaultIndicator,EditIndicator,ID,Id,UpdatedBy,UpdatedDateTime,UserGroupId
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",true,true,"""string""",123,"""string""","""2000-01-01T00:00:00.000Z""","""string"""

ControlGroups
getpost

Update an existing control group.

Usage:
tq put ControlGroups
Query:
{"CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "Permission":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"Permission":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,Permission,UpdatedBy,UpdatedDateTime
"""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,123,"""string""","""2000-01-01T00:00:00.000Z"""

Countries
getpost

Update an existing country.

Usage:
tq put Countries
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DecimalSeparator":"string", "Description":"string", "Id":123, "Inactive":true, "IsoAlpha2Code":"string", "IsoAlpha3Code":"string", "PhoneCode":"string", "PhoneEditstring":"string", "PhoneMask":"string", "PhoneValidLengths":"string", "ReqCity":true, "ReqPcode":true, "ShortDesc":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "UseAvs":"string", "UseStateField":"string", "ZipEditstring":"string", "ZipMask":"string", "ZipValidLengths":"string", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DecimalSeparator":"string","Description":"string","ID":"string","Id":123,"Inactive":true,"IsoAlpha2Code":"string","IsoAlpha3Code":"string","PhoneCode":"string","PhoneEditstring":"string","PhoneMask":"string","PhoneValidLengths":"string","ReqCity":true,"ReqPcode":true,"ShortDesc":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","UseAvs":"string","UseStateField":"string","ZipEditstring":"string","ZipMask":"string","ZipValidLengths":"string"}]
CreateLocation,CreatedBy,CreatedDateTime,DecimalSeparator,Description,ID,Id,Inactive,IsoAlpha2Code,IsoAlpha3Code,PhoneCode,PhoneEditstring,PhoneMask,PhoneValidLengths,ReqCity,ReqPcode,ShortDesc,UpdatedBy,UpdatedDateTime,UseAvs,UseStateField,ZipEditstring,ZipMask,ZipValidLengths
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""","""string""",123,true,"""string""","""string""","""string""","""string""","""string""","""string""",true,true,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""","""string""","""string""","""string"""

CrediteeTypes
getpost

Update an existing crediteeType.

Usage:
tq put CrediteeTypes
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "CreditMembershipIndicator":true, "Description":"string", "GiftAidIndicator":true, "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","CreditMembershipIndicator":true,"Description":"string","GiftAidIndicator":true,"ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,CreditMembershipIndicator,Description,GiftAidIndicator,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""",true,"""string""",true,"""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

CurrencyTypes
getpost

Update an existing currency type.

Usage:
tq put CurrencyTypes
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "Rate":123.456, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"Rate":123.456,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,Rate,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,123.456,"""string""","""2000-01-01T00:00:00.000Z"""

CustomDefaultCategories
getpost

Update an existing custom default category.

Usage:
tq put CustomDefaultCategories
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

CustomDefaults
getpost

Update an existing custom default.

Usage:
tq put CustomDefaults
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "CustomDefaultCategory":{"Id":123}, "DefaultValue":"string", "Description":"string", "FieldName":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","CustomDefaultCategory.Id":123,"DefaultValue":"string","Description":"string","FieldName":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,CustomDefaultCategory.Id,DefaultValue,Description,FieldName,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""",123,"""string""","""string""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

D

DeliveryMethods
getpost

Update an existing delivery method.

Usage:
tq put DeliveryMethods
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "PrintAtHome":true, "RequireAddress":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"PrintAtHome":true,"RequireAddress":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,PrintAtHome,RequireAddress,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,true,true,"""string""","""2000-01-01T00:00:00.000Z"""

DesignationCodes
getpost

Update an existing designation code.

Usage:
tq put DesignationCodes
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

Diagnostics
getpost

Dummy end point to check availability of HTTP PUT.

Usage:
tq put Diagnostics
Query:
{"CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "DiagnosticID":"string"}
[{"CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","DiagnosticID":"string","Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreatedBy,CreatedDateTime,Description,DiagnosticID,Id,UpdatedBy,UpdatedDateTime
"""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,"""string""","""2000-01-01T00:00:00.000Z"""

DirectDebitAccountTypes
getpost

Update an existing direct debit account type.

Usage:
tq put DirectDebitAccountTypes
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

DiscountTypes
getpost

Update an existing discount type.

Usage:
tq put DiscountTypes
Query:
{"Amount":123.456, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "PercentIndicator":true, "RespectMinimumPrice":true, "ShortDescription":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"Amount":123.456,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"PercentIndicator":true,"RespectMinimumPrice":true,"ShortDescription":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
Amount,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,PercentIndicator,RespectMinimumPrice,ShortDescription,UpdatedBy,UpdatedDateTime
123.456,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,true,true,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

DocumentCategories
getpost

Update an existing documentCategory.

Usage:
tq put DocumentCategories
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "ParentTableName":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"ParentTableName":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,ParentTableName,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

DonationLevels
getpost

Update an existing donation level.

Usage:
tq put DonationLevels
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "ProgramType":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"ProgramType.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,ProgramType.Id,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,123,"""string""","""2000-01-01T00:00:00.000Z"""

E

EMV
getpost

Set idle message for a specific lane

Usage:
tq put EMV
Query:
{"Cert":"string", "LaneID":"string", "Merchant":"string", "IdleMessage":"string"}
[{"Cert":"string","IdleMessage":"string","LaneID":"string","Merchant":"string"}]
Cert,IdleMessage,LaneID,Merchant
"""string""","""string""","""string""","""string"""

ElectronicAddressTypes
getpost

Update an existing electronic address type.

Usage:
tq put ElectronicAddressTypes
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "IsEmail":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"IsEmail":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,IsEmail,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,true,"""string""","""2000-01-01T00:00:00.000Z"""

ElectronicAddresses
getpost

Update an electronic address.

Usage:
tq put ElectronicAddresses
Query:
{"Address":"string", "AffiliatedConstituent":{"Id":123}, "AllowHtmlFormat":true, "AllowMarketing":true, "AltSalutationType":{"Id":123}, "Constituent":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "EditIndicator":true, "ElectronicAddressType":{"Id":123}, "EndDate":"2000-01-01T00:00:00.000Z", "Id":123, "Inactive":true, "IsEmail":true, "IsFromAffiliation":true, "Months":"string", "PrimaryIndicator":true, "StartDate":"2000-01-01T00:00:00.000Z", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ElectronicAddressID":"string"}
[{"Address":"string","AffiliatedConstituent.Id":123,"AllowHtmlFormat":true,"AllowMarketing":true,"AltSalutationType.Id":123,"Constituent.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","EditIndicator":true,"ElectronicAddressID":"string","ElectronicAddressType.Id":123,"EndDate":"2000-01-01T00:00:00.000Z","Id":123,"Inactive":true,"IsEmail":true,"IsFromAffiliation":true,"Months":"string","PrimaryIndicator":true,"StartDate":"2000-01-01T00:00:00.000Z","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
Address,AffiliatedConstituent.Id,AllowHtmlFormat,AllowMarketing,AltSalutationType.Id,Constituent.Id,CreateLocation,CreatedBy,CreatedDateTime,EditIndicator,ElectronicAddressID,ElectronicAddressType.Id,EndDate,Id,Inactive,IsEmail,IsFromAffiliation,Months,PrimaryIndicator,StartDate,UpdatedBy,UpdatedDateTime
"""string""",123,true,true,123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",true,"""string""",123,"""2000-01-01T00:00:00.000Z""",123,true,true,true,"""string""",true,"""2000-01-01T00:00:00.000Z""","""string""","""2000-01-01T00:00:00.000Z"""

EmailProfiles
getpost

Update an existing email profile

Usage:
tq put EmailProfiles
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "EmailBcc":"string", "EmailCc":"string", "EmailDefaultSubject":"string", "EmailFrom":"string", "Id":123, "Inactive":true, "SMTPPassword":"string", "SMTPPort":123, "SMTPServer":"string", "SMTPUserName":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "UseSsl":true, "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","EmailBcc":"string","EmailCc":"string","EmailDefaultSubject":"string","EmailFrom":"string","ID":"string","Id":123,"Inactive":true,"SMTPPassword":"string","SMTPPort":123,"SMTPServer":"string","SMTPUserName":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","UseSsl":true}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,EmailBcc,EmailCc,EmailDefaultSubject,EmailFrom,ID,Id,Inactive,SMTPPassword,SMTPPort,SMTPServer,SMTPUserName,UpdatedBy,UpdatedDateTime,UseSsl
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""","""string""","""string""","""string""","""string""",123,true,"""string""",123,"""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""",true

EmarketIndicators
getpost

Update an existing emarket indicator.

Usage:
tq put EmarketIndicators
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

Eras
getpost

Update an existing era.

Usage:
tq put Eras
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

F

Facilities
getpost

Update a Facility.

Usage:
tq put Facilities
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DefaultBestSeatMapId":123, "DefaultZoneMapId":123, "Description":"string", "Id":123, "SeatMap":{"Id":123}, "Theater":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DefaultBestSeatMapId":123,"DefaultZoneMapId":123,"Description":"string","ID":"string","Id":123,"SeatMap.Id":123,"Theater.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,DefaultBestSeatMapId,DefaultZoneMapId,Description,ID,Id,SeatMap.Id,Theater.Id,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",123,123,"""string""","""string""",123,123,123,"""string""","""2000-01-01T00:00:00.000Z"""

G

Genders
getpost

Update an existing gender.

Usage:
tq put Genders
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DefaultPrefix":{"Id":123}, "Description":"string", "Id":123, "Inactive":true, "ShortDescription":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DefaultPrefix.Id":123,"Description":"string","ID":"string","Id":123,"Inactive":true,"ShortDescription":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,DefaultPrefix.Id,Description,ID,Id,Inactive,ShortDescription,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""",123,"""string""","""string""",123,true,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

GiftAidContactMethods
getpost

Update an existing gift aid contact method.

Usage:
tq put GiftAidContactMethods
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

GiftAidDeclarations
getpost

Update a Gift Aid Declaration.

Usage:
tq put GiftAidDeclarations
Query:
{"ConfirmDateTime":"2000-01-01T00:00:00.000Z", "Constituent":{"Id":123}, "ContactMethod":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DocumentStatus":{"Id":123}, "EligibleIndicator":true, "EndDateTime":"2000-01-01T00:00:00.000Z", "GiftAidType":{"Id":123}, "Id":123, "IneligibleReason":{"Id":123}, "Notes":"string", "ReceivedDateTime":"2000-01-01T00:00:00.000Z", "StartDateTime":"2000-01-01T00:00:00.000Z", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "GiftAidDeclarationID":"string"}
[{"ConfirmDateTime":"2000-01-01T00:00:00.000Z","Constituent.Id":123,"ContactMethod.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DocumentStatus.Id":123,"EligibleIndicator":true,"EndDateTime":"2000-01-01T00:00:00.000Z","GiftAidDeclarationID":"string","GiftAidType.Id":123,"Id":123,"IneligibleReason.Id":123,"Notes":"string","ReceivedDateTime":"2000-01-01T00:00:00.000Z","StartDateTime":"2000-01-01T00:00:00.000Z","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ConfirmDateTime,Constituent.Id,ContactMethod.Id,CreateLocation,CreatedBy,CreatedDateTime,DocumentStatus.Id,EligibleIndicator,EndDateTime,GiftAidDeclarationID,GiftAidType.Id,Id,IneligibleReason.Id,Notes,ReceivedDateTime,StartDateTime,UpdatedBy,UpdatedDateTime
"""2000-01-01T00:00:00.000Z""",123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",123,true,"""2000-01-01T00:00:00.000Z""","""string""",123,123,123,"""string""","""2000-01-01T00:00:00.000Z""","""2000-01-01T00:00:00.000Z""","""string""","""2000-01-01T00:00:00.000Z"""

GiftAidDocumentStatuses
getpost

Update an existing gift aid document status.

Usage:
tq put GiftAidDocumentStatuses
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

GiftAidIneligibleReasons
getpost

Update an existing gift aid ineligible reason.

Usage:
tq put GiftAidIneligibleReasons
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

GiftAidRates
getpost

Update an existing gift aid rate.

Usage:
tq put GiftAidRates
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "EndDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "Rate":123.456, "StartDateTime":"2000-01-01T00:00:00.000Z", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","EndDateTime":"2000-01-01T00:00:00.000Z","ID":"string","Id":123,"Rate":123.456,"StartDateTime":"2000-01-01T00:00:00.000Z","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,EndDateTime,ID,Id,Rate,StartDateTime,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""2000-01-01T00:00:00.000Z""","""string""",123,123.456,"""2000-01-01T00:00:00.000Z""","""string""","""2000-01-01T00:00:00.000Z"""

GiftAidStatuses
getpost

Update an existing gift aid status.

Usage:
tq put GiftAidStatuses
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

GiftAidTypes
getpost

Update an existing gift aid type.

Usage:
tq put GiftAidTypes
Query:
{"CharityClaimsRef":"string", "ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CharityClaimsRef":"string","ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CharityClaimsRef,ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""",123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

H

HoldCodeCategories
getpost

Update an existing Hold Code Category.

Usage:
tq put HoldCodeCategories
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

HoldCodeUserGroups
getpost

Update an existing hold code/user group mapping.

Usage:
tq put HoldCodeUserGroups
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "HoldCode":{"Id":123}, "Id":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "UserGroupId":"string", "HoldCodeUserGroupID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","HoldCode.Id":123,"HoldCodeUserGroupID":"string","Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","UserGroupId":"string"}]
CreateLocation,CreatedBy,CreatedDateTime,HoldCode.Id,HoldCodeUserGroupID,Id,UpdatedBy,UpdatedDateTime,UserGroupId
"""string""","""string""","""2000-01-01T00:00:00.000Z""",123,"""string""",123,"""string""","""2000-01-01T00:00:00.000Z""","""string"""

HoldCodes
getpost

Update an existing Hold Code.

Usage:
tq put HoldCodes
Query:
{"BlackoutIndicator":true, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "EditIndicator":true, "Id":123, "Legend":"string", "Type":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "HoldCodeID":"string"}
[{"BlackoutIndicator":true,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","EditIndicator":true,"HoldCodeID":"string","Id":123,"Legend":"string","Type.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
BlackoutIndicator,CreateLocation,CreatedBy,CreatedDateTime,Description,EditIndicator,HoldCodeID,Id,Legend,Type.Id,UpdatedBy,UpdatedDateTime
true,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""",true,"""string""",123,"""string""",123,"""string""","""2000-01-01T00:00:00.000Z"""

I

InactiveReasons
getpost

Update an existing inactive reason.

Usage:
tq put InactiveReasons
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

IntegrationDefaults
getpost

Update an existing Integration Default.

Usage:
tq put IntegrationDefaults
Query:
{"AccessId":"string", "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DefaultValue":"string", "Description":"string", "FieldName":"string", "Id":123, "Integration":{"Id":123}, "Organization":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"AccessId":"string","CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DefaultValue":"string","Description":"string","FieldName":"string","ID":"string","Id":123,"Integration.Id":123,"Organization.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
AccessId,CreateLocation,CreatedBy,CreatedDateTime,DefaultValue,Description,FieldName,ID,Id,Integration.Id,Organization.Id,UpdatedBy,UpdatedDateTime
"""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""","""string""","""string""",123,123,123,"""string""","""2000-01-01T00:00:00.000Z"""

Integrations
getpost

Update an existing action type.

Usage:
tq put Integrations
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,"""string""","""2000-01-01T00:00:00.000Z"""

InterestCategories
getpost

Update an existing interest category.

Usage:
tq put InterestCategories
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,"""string""","""2000-01-01T00:00:00.000Z"""

InterestTypes
getpost

Update an existing interest type.

Usage:
tq put InterestTypes
Query:
{"Category":{"Id":123}, "ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "SearchIndicator":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "UsedIn":"string", "ID":"string"}
[{"Category.Id":123,"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"SearchIndicator":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","UsedIn":"string"}]
Category.Id,ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,SearchIndicator,UpdatedBy,UpdatedDateTime,UsedIn
123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z""","""string"""

Interests
getpost

Update an interest. If the interest is not selected and the weight is 0 or null, it will be deleted. For bulk interest edits, consider the CRM/Interests/CreateOrUpdate batching resource which allows multiple interests to be created, updated, or removed in a single request.

Usage:
tq put Interests
Query:
{"Constituent":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "EditIndicator":true, "Id":123, "InterestType":{"Id":123}, "Selected":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "Weight":123, "InterestID":"string"}
[{"Constituent.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","EditIndicator":true,"Id":123,"InterestID":"string","InterestType.Id":123,"Selected":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","Weight":123}]
Constituent.Id,CreateLocation,CreatedBy,CreatedDateTime,EditIndicator,Id,InterestID,InterestType.Id,Selected,UpdatedBy,UpdatedDateTime,Weight
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",true,123,"""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z""",123

Internal
getpost

Update an address and phones. If the entire information about a phone is added newly then create a new phone. If the phone number of a phone is not given then delete that phone.

Usage:
tq put Internal
Query:
{"AddressType":{"Id":123}, "AffiliatedConstituent":{"Id":123}, "AllowTelemarketing1":true, "AllowTelemarketing2":true, "AllowTelemarketing3":true, "AltSalutationType":{"Id":123}, "City":"string", "Constituent":{"Id":123}, "Country":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DayEveningIndicator1":"string", "DayEveningIndicator2":"string", "DayEveningIndicator3":"string", "DeliveryPoint":"string", "EditIndicator":true, "EditIndicator1":true, "EditIndicator2":true, "EditIndicator3":true, "EndDate":"2000-01-01T00:00:00.000Z", "GeoArea":123, "Id":123, "Inactive":true, "Label":true, "Months":"string", "NcoaAction":123, "NcoaSession":123, "PhoneId1":123, "PhoneId2":123, "PhoneId3":123, "PhoneNumber1":"string", "PhoneNumber1Formatted":"string", "PhoneNumber2":"string", "PhoneNumber2Formatted":"string", "PhoneNumber3":"string", "PhoneNumber3Formatted":"string", "PhoneSearch1":"string", "PhoneSearch2":"string", "PhoneSearch3":"string", "PostalCode":"string", "PostalCodeFormatted":"string", "PrimaryIndicator":true, "StartDate":"2000-01-01T00:00:00.000Z", "State":{"Id":123}, "Street1":"string", "Street2":"string", "Street3":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "UpdatedDateTime1":"2000-01-01T00:00:00.000Z", "UpdatedDateTime2":"2000-01-01T00:00:00.000Z", "UpdatedDateTime3":"2000-01-01T00:00:00.000Z", "AddressID":"string"}
[{"AddressID":"string","AddressType.Id":123,"AffiliatedConstituent.Id":123,"AllowTelemarketing1":true,"AllowTelemarketing2":true,"AllowTelemarketing3":true,"AltSalutationType.Id":123,"City":"string","Constituent.Id":123,"Country.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DayEveningIndicator1":"string","DayEveningIndicator2":"string","DayEveningIndicator3":"string","DeliveryPoint":"string","EditIndicator":true,"EditIndicator1":true,"EditIndicator2":true,"EditIndicator3":true,"EndDate":"2000-01-01T00:00:00.000Z","GeoArea":123,"Id":123,"Inactive":true,"Label":true,"Months":"string","NcoaAction":123,"NcoaSession":123,"PhoneId1":123,"PhoneId2":123,"PhoneId3":123,"PhoneNumber1":"string","PhoneNumber1Formatted":"string","PhoneNumber2":"string","PhoneNumber2Formatted":"string","PhoneNumber3":"string","PhoneNumber3Formatted":"string","PhoneSearch1":"string","PhoneSearch2":"string","PhoneSearch3":"string","PostalCode":"string","PostalCodeFormatted":"string","PrimaryIndicator":true,"StartDate":"2000-01-01T00:00:00.000Z","State.Id":123,"Street1":"string","Street2":"string","Street3":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","UpdatedDateTime1":"2000-01-01T00:00:00.000Z","UpdatedDateTime2":"2000-01-01T00:00:00.000Z","UpdatedDateTime3":"2000-01-01T00:00:00.000Z"}]
AddressID,AddressType.Id,AffiliatedConstituent.Id,AllowTelemarketing1,AllowTelemarketing2,AllowTelemarketing3,AltSalutationType.Id,City,Constituent.Id,Country.Id,CreateLocation,CreatedBy,CreatedDateTime,DayEveningIndicator1,DayEveningIndicator2,DayEveningIndicator3,DeliveryPoint,EditIndicator,EditIndicator1,EditIndicator2,EditIndicator3,EndDate,GeoArea,Id,Inactive,Label,Months,NcoaAction,NcoaSession,PhoneId1,PhoneId2,PhoneId3,PhoneNumber1,PhoneNumber1Formatted,PhoneNumber2,PhoneNumber2Formatted,PhoneNumber3,PhoneNumber3Formatted,PhoneSearch1,PhoneSearch2,PhoneSearch3,PostalCode,PostalCodeFormatted,PrimaryIndicator,StartDate,State.Id,Street1,Street2,Street3,UpdatedBy,UpdatedDateTime,UpdatedDateTime1,UpdatedDateTime2,UpdatedDateTime3
"""string""",123,123,true,true,true,123,"""string""",123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""","""string""","""string""",true,true,true,true,"""2000-01-01T00:00:00.000Z""",123,123,true,true,"""string""",123,123,123,123,123,"""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""",true,"""2000-01-01T00:00:00.000Z""",123,"""string""","""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""","""2000-01-01T00:00:00.000Z""","""2000-01-01T00:00:00.000Z""","""2000-01-01T00:00:00.000Z"""

InventoryContactPermissionTypes
getpost

Updated an existing inventoryContactPermissionType.

Usage:
tq put InventoryContactPermissionTypes
Query:
{"ContactPermissionType":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "ProductionElementId":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "InventoryContactPermissionTypeID":"string"}
[{"ContactPermissionType.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Id":123,"InventoryContactPermissionTypeID":"string","ProductionElementId":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ContactPermissionType.Id,CreateLocation,CreatedBy,CreatedDateTime,Id,InventoryContactPermissionTypeID,ProductionElementId,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",123,"""string""",123,"""string""","""2000-01-01T00:00:00.000Z"""

InventoryWebContents
getpost

Update an existing inventoryWebContent.

Usage:
tq put InventoryWebContents
Query:
{"ContentType":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "ProductionElementId":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "Value":"string", "InventoryWebContentID":"string"}
[{"ContentType.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Id":123,"InventoryWebContentID":"string","ProductionElementId":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","Value":"string"}]
ContentType.Id,CreateLocation,CreatedBy,CreatedDateTime,Id,InventoryWebContentID,ProductionElementId,UpdatedBy,UpdatedDateTime,Value
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",123,"""string""",123,"""string""","""2000-01-01T00:00:00.000Z""","""string"""

Issues
getpost

Update an issue for a Constituent

Usage:
tq put Issues
Query:
{"ActivityType":{"Id":123}, "Constituent":{"Id":123}, "ContactType":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "EditIndicator":true, "HasReminder":true, "Id":123, "IssueDate":"2000-01-01T00:00:00.000Z", "Notes":"string", "Origin":{"Id":123}, "PackageId":123, "PerformanceId":123, "ResolvedIndicator":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "UrgentIndicator":true, "IssueID":"string"}
[{"ActivityType.Id":123,"Constituent.Id":123,"ContactType.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","EditIndicator":true,"HasReminder":true,"Id":123,"IssueDate":"2000-01-01T00:00:00.000Z","IssueID":"string","Notes":"string","Origin.Id":123,"PackageId":123,"PerformanceId":123,"ResolvedIndicator":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","UrgentIndicator":true}]
ActivityType.Id,Constituent.Id,ContactType.Id,CreateLocation,CreatedBy,CreatedDateTime,EditIndicator,HasReminder,Id,IssueDate,IssueID,Notes,Origin.Id,PackageId,PerformanceId,ResolvedIndicator,UpdatedBy,UpdatedDateTime,UrgentIndicator
123,123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",true,true,123,"""2000-01-01T00:00:00.000Z""","""string""","""string""",123,123,123,true,"""string""","""2000-01-01T00:00:00.000Z""",true

K

KeywordCategories
getpost

Update an existing keyword category.

Usage:
tq put KeywordCategories
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

Keywords
getpost

Update an existing keyword.

Usage:
tq put Keywords
Query:
{"Category":{"Id":123}, "ConstituentType":123, "ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "CustomDefaultValue":"string", "CustomId":123, "CustomLimit":123, "CustomRequired":true, "DataType":"string", "Description":"string", "DetailColumn":"string", "DetailTable":"string", "EditIndicator":true, "EditMask":"string", "ExtendedDescription":"string", "FrequentUpdateDate":"2000-01-01T00:00:00.000Z", "HelpText":"string", "Id":123, "KeyColumn":"string", "KeywordUse":"string", "MultipleValue":true, "ParentKeyColumn":"string", "ParentTable":"string", "PrimaryGroupDefault":"string", "ReferenceDescriptionColumn":"string", "ReferenceIdColumn":"string", "ReferenceSort":"string", "ReferenceTable":"string", "ReferenceWhere":"string", "SortOrder":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "UseForSearch":true, "ValuesCodedIndicator":true, "ID":"string"}
[{"Category.Id":123,"ConstituentType":123,"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","CustomDefaultValue":"string","CustomId":123,"CustomLimit":123,"CustomRequired":true,"DataType":"string","Description":"string","DetailColumn":"string","DetailTable":"string","EditIndicator":true,"EditMask":"string","ExtendedDescription":"string","FrequentUpdateDate":"2000-01-01T00:00:00.000Z","HelpText":"string","ID":"string","Id":123,"KeyColumn":"string","KeywordUse":"string","MultipleValue":true,"ParentKeyColumn":"string","ParentTable":"string","PrimaryGroupDefault":"string","ReferenceDescriptionColumn":"string","ReferenceIdColumn":"string","ReferenceSort":"string","ReferenceTable":"string","ReferenceWhere":"string","SortOrder":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","UseForSearch":true,"ValuesCodedIndicator":true}]
Category.Id,ConstituentType,ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,CustomDefaultValue,CustomId,CustomLimit,CustomRequired,DataType,Description,DetailColumn,DetailTable,EditIndicator,EditMask,ExtendedDescription,FrequentUpdateDate,HelpText,ID,Id,KeyColumn,KeywordUse,MultipleValue,ParentKeyColumn,ParentTable,PrimaryGroupDefault,ReferenceDescriptionColumn,ReferenceIdColumn,ReferenceSort,ReferenceTable,ReferenceWhere,SortOrder,UpdatedBy,UpdatedDateTime,UseForSearch,ValuesCodedIndicator
123,123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""",123,123,true,"""string""","""string""","""string""","""string""",true,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,"""string""","""string""",true,"""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""",123,"""string""","""2000-01-01T00:00:00.000Z""",true,true

L

Languages
getpost

Update an existing language.

Usage:
tq put Languages
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

ListCategories
getpost

Update an existing list category.

Usage:
tq put ListCategories
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

Lists
getpost

Update an existing List.

Usage:
tq put Lists
Query:
{"AffiliatedIndividuals":123, "AnalyticsIndicator":true, "Category":{"Id":123}, "ConstituentCount":123, "ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Criteria":[{"Id":123}, ...], "Description":"string", "EditIndicator":true, "EditMode":"string", "Generate":true, "Households":123, "Id":123, "Inactive":true, "Individuals":123, "IsDynamic":true, "LastUsedDateTime":"2000-01-01T00:00:00.000Z", "ListSql":"string", "Organizations":123, "OutputSet":{"Id":123}, "RelationshipOptions":{"AffiliatedGroupInactive":true, "AffiliatedGroupTypes":"string", "AffiliatedGroupUseDates":true, "AffiliatedIndividualInactive":true, "AffiliatedIndividualTypes":"string", "AffiliatedIndividualUseDates":true, "AssociatedInactive":true, "AssociatedTypes":"string", "AssociatedUseDates":true, "CreateLocation":"string", "CreatedBy":"string", "KeepOrReplaceOriginal":"string", "ReplaceIndividuals":"string", "UpdatedBy":"string"}, "TMSIndicator":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ListID":"string"}


Flags:

  • --Contents
    Import constituent ids into an existing list.
Query:
{"ListID":"string", "ConstituentIds":[0, ...]}


LoginTypes
getpost

Update an existing login type.

Usage:
tq put LoginTypes
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

M

MachineSettings
getpost

Update an existing Machine Setting.

Usage:
tq put MachineSettings
Query:
{"CardReaderHost":"string", "CardReaderPort":123, "CardReaderType":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "Inactive":true, "MerchantId":"string", "PXStation":"string", "PXUserKey":"string", "PXUserName":"string", "TessituraPaymentsPosDevice":"string", "TessituraPaymentsPosDeviceModel":"string", "TnspaySoftwareTerminal":true, "TriPOSCloudConfiguration":{"Id":123}, "TriposLane":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "WorkstationName":"string", "ID":"string"}
[{"CardReaderHost":"string","CardReaderPort":123,"CardReaderType.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","ID":"string","Id":123,"Inactive":true,"MerchantId":"string","PXStation":"string","PXUserKey":"string","PXUserName":"string","TessituraPaymentsPosDevice":"string","TessituraPaymentsPosDeviceModel":"string","TnspaySoftwareTerminal":true,"TriPOSCloudConfiguration.Id":123,"TriposLane":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","WorkstationName":"string"}]
CardReaderHost,CardReaderPort,CardReaderType.Id,CreateLocation,CreatedBy,CreatedDateTime,ID,Id,Inactive,MerchantId,PXStation,PXUserKey,PXUserName,TessituraPaymentsPosDevice,TessituraPaymentsPosDeviceModel,TnspaySoftwareTerminal,TriPOSCloudConfiguration.Id,TriposLane,UpdatedBy,UpdatedDateTime,WorkstationName
"""string""",123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""",123,true,"""string""","""string""","""string""","""string""","""string""","""string""",true,123,123,"""string""","""2000-01-01T00:00:00.000Z""","""string"""

MailIndicators
getpost

Update an existing mail indicator.

Usage:
tq put MailIndicators
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

MediaTypes
getpost

Update an existing media type.

Usage:
tq put MediaTypes
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "GenerateCost":123.456, "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","GenerateCost":123.456,"ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,GenerateCost,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""",123.456,"""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

MembershipLevelCategories
getpost

Update an existing membership level category.

Usage:
tq put MembershipLevelCategories
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

ModeOfSaleCategories
getpost

Update an existing mode of sale category.

Usage:
tq put ModeOfSaleCategories
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "Sequence":123, "ShortDescription":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ModeOfSaleCategoryID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","Id":123,"Inactive":true,"ModeOfSaleCategoryID":"string","Sequence":123,"ShortDescription":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,Id,Inactive,ModeOfSaleCategoryID,Sequence,ShortDescription,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""",123,true,"""string""",123,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

ModeOfSaleOffers
getpost

Update an existing mode of sale offer.

Usage:
tq put ModeOfSaleOffers
Query:
{"AppealId":123, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "EndDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "MaxSeats":123, "ModeOfSaleId":123, "OverrideDefaultPriceTypeIndicator":true, "PackageId":123, "PerformanceId":123, "PriceTypeId":123, "Rank":123, "SourceId":123, "StartDateTime":"2000-01-01T00:00:00.000Z", "Terms":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ModeOfSaleOfferID":"string"}
[{"AppealId":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","EndDateTime":"2000-01-01T00:00:00.000Z","Id":123,"MaxSeats":123,"ModeOfSaleId":123,"ModeOfSaleOfferID":"string","OverrideDefaultPriceTypeIndicator":true,"PackageId":123,"PerformanceId":123,"PriceTypeId":123,"Rank":123,"SourceId":123,"StartDateTime":"2000-01-01T00:00:00.000Z","Terms":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
AppealId,CreateLocation,CreatedBy,CreatedDateTime,EndDateTime,Id,MaxSeats,ModeOfSaleId,ModeOfSaleOfferID,OverrideDefaultPriceTypeIndicator,PackageId,PerformanceId,PriceTypeId,Rank,SourceId,StartDateTime,Terms,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""2000-01-01T00:00:00.000Z""",123,123,123,"""string""",true,123,123,123,123,123,"""2000-01-01T00:00:00.000Z""","""string""","""string""","""2000-01-01T00:00:00.000Z"""

ModeOfSalePriceTypes
getpost

Update an existing mode of sale price type.

Usage:
tq put ModeOfSalePriceTypes
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DefaultIndicator":true, "Id":123, "ModeOfSale":{"Id":123}, "PriceType":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ModeOfSalePriceTypeID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DefaultIndicator":true,"Id":123,"ModeOfSale.Id":123,"ModeOfSalePriceTypeID":"string","PriceType.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,DefaultIndicator,Id,ModeOfSale.Id,ModeOfSalePriceTypeID,PriceType.Id,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""",true,123,123,"""string""",123,"""string""","""2000-01-01T00:00:00.000Z"""

ModeOfSaleSurveyQuestions
getpost

Update an existing mode of sale survey question.

Usage:
tq put ModeOfSaleSurveyQuestions
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "ModeOfSale":{"Id":123}, "Question":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ModeOfSaleSurveyQuestionID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Id":123,"ModeOfSale.Id":123,"ModeOfSaleSurveyQuestionID":"string","Question.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Id,ModeOfSale.Id,ModeOfSaleSurveyQuestionID,Question.Id,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""",123,123,"""string""",123,"""string""","""2000-01-01T00:00:00.000Z"""

ModeOfSaleUserGroups
getpost

Update an existing mode of sale/user group mapping.

Usage:
tq put ModeOfSaleUserGroups
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DefaultIndicator":true, "Id":123, "ModeOfSale":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "UserGroupId":"string", "ModeOfSaleUserGroupID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DefaultIndicator":true,"Id":123,"ModeOfSale.Id":123,"ModeOfSaleUserGroupID":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","UserGroupId":"string"}]
CreateLocation,CreatedBy,CreatedDateTime,DefaultIndicator,Id,ModeOfSale.Id,ModeOfSaleUserGroupID,UpdatedBy,UpdatedDateTime,UserGroupId
"""string""","""string""","""2000-01-01T00:00:00.000Z""",true,123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string"""

ModesOfSale
getpost

Update an existing mode of sale.

Usage:
tq put ModesOfSale
Query:
{"AllowUnseatedPaidInd":true, "Category":{"Id":123}, "CategoryRequired":true, "ClearSourceNoInd":true, "ClearSourceOnReload":true, "ConfirmationMode":true, "ConstLinkRequired":true, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DefaultAckFormatId":123, "DefaultChannelId":123, "DefaultDeliveryMethodId":123, "DefaultHeaderFormatId":123, "DefaultSalesLayoutId":123, "Description":"string", "EditDate":true, "EditSourceOnReload":true, "GeneralPublicInd":true, "HaboDays":123, "HaboForeign":true, "HoldUntilDate":"2000-01-01T00:00:00.000Z", "HoldUntilDays":123, "HoldUntilMethod":"string", "Id":123, "Inactive":true, "MustBePaidInd":true, "MustBeSeatedInd":true, "MustBeTicketedInd":true, "PricingRuleSetId":123, "SampleForGeneralPublic":123, "SampleForKnownConstituent":123, "SliAutoDeleteInd":true, "StartPkgOrPerf":"string", "SubsSummaryRequired":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ModeOfSaleID":"string"}
[{"AllowUnseatedPaidInd":true,"Category.Id":123,"CategoryRequired":true,"ClearSourceNoInd":true,"ClearSourceOnReload":true,"ConfirmationMode":true,"ConstLinkRequired":true,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DefaultAckFormatId":123,"DefaultChannelId":123,"DefaultDeliveryMethodId":123,"DefaultHeaderFormatId":123,"DefaultSalesLayoutId":123,"Description":"string","EditDate":true,"EditSourceOnReload":true,"GeneralPublicInd":true,"HaboDays":123,"HaboForeign":true,"HoldUntilDate":"2000-01-01T00:00:00.000Z","HoldUntilDays":123,"HoldUntilMethod":"string","Id":123,"Inactive":true,"ModeOfSaleID":"string","MustBePaidInd":true,"MustBeSeatedInd":true,"MustBeTicketedInd":true,"PricingRuleSetId":123,"SampleForGeneralPublic":123,"SampleForKnownConstituent":123,"SliAutoDeleteInd":true,"StartPkgOrPerf":"string","SubsSummaryRequired":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
AllowUnseatedPaidInd,Category.Id,CategoryRequired,ClearSourceNoInd,ClearSourceOnReload,ConfirmationMode,ConstLinkRequired,CreateLocation,CreatedBy,CreatedDateTime,DefaultAckFormatId,DefaultChannelId,DefaultDeliveryMethodId,DefaultHeaderFormatId,DefaultSalesLayoutId,Description,EditDate,EditSourceOnReload,GeneralPublicInd,HaboDays,HaboForeign,HoldUntilDate,HoldUntilDays,HoldUntilMethod,Id,Inactive,ModeOfSaleID,MustBePaidInd,MustBeSeatedInd,MustBeTicketedInd,PricingRuleSetId,SampleForGeneralPublic,SampleForKnownConstituent,SliAutoDeleteInd,StartPkgOrPerf,SubsSummaryRequired,UpdatedBy,UpdatedDateTime
true,123,true,true,true,true,true,"""string""","""string""","""2000-01-01T00:00:00.000Z""",123,123,123,123,123,"""string""",true,true,true,123,true,"""2000-01-01T00:00:00.000Z""",123,"""string""",123,true,"""string""",true,true,true,123,123,123,true,"""string""",true,"""string""","""2000-01-01T00:00:00.000Z"""

N

NScanAccessAreas
getpost

Update an existing NScan Access Area.

Usage:
tq put NScanAccessAreas
Query:
{"AreaCode":"string", "ConstituencyIds":"string", "ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "EndDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "Inactive":true, "KeywordId":123, "KeywordValue":"string", "ListId":123, "MaxEntries":123, "MembershipLevelIds":"string", "PerformanceIds":"string", "PriceTypeIds":"string", "PriceZoneIds":"string", "PromptQuantity":true, "StartDateTime":"2000-01-01T00:00:00.000Z", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"AreaCode":"string","ConstituencyIds":"string","ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","EndDateTime":"2000-01-01T00:00:00.000Z","ID":"string","Id":123,"Inactive":true,"KeywordId":123,"KeywordValue":"string","ListId":123,"MaxEntries":123,"MembershipLevelIds":"string","PerformanceIds":"string","PriceTypeIds":"string","PriceZoneIds":"string","PromptQuantity":true,"StartDateTime":"2000-01-01T00:00:00.000Z","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
AreaCode,ConstituencyIds,ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,EndDateTime,ID,Id,Inactive,KeywordId,KeywordValue,ListId,MaxEntries,MembershipLevelIds,PerformanceIds,PriceTypeIds,PriceZoneIds,PromptQuantity,StartDateTime,UpdatedBy,UpdatedDateTime
"""string""","""string""",123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""2000-01-01T00:00:00.000Z""","""string""",123,true,123,"""string""",123,123,"""string""","""string""","""string""","""string""",true,"""2000-01-01T00:00:00.000Z""","""string""","""2000-01-01T00:00:00.000Z"""

NameStatuses
getpost

Update an existing name status.

Usage:
tq put NameStatuses
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

O

ObjectPermissions
getpost

Update an existing object permission.

Usage:
tq put ObjectPermissions
Query:
{"ApplicationObject":{"Id":123}, "CanCreate":"string", "CanDelete":"string", "CanEdit":"string", "CanView":"string", "Constituency":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "UserGroup":{"Id":"string"}, "ID":"string"}
[{"ApplicationObject.Id":123,"CanCreate":"string","CanDelete":"string","CanEdit":"string","CanView":"string","Constituency.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","ID":"string","Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","UserGroup.Id":"string"}]
ApplicationObject.Id,CanCreate,CanDelete,CanEdit,CanView,Constituency.Id,CreateLocation,CreatedBy,CreatedDateTime,ID,Id,UpdatedBy,UpdatedDateTime,UserGroup.Id
123,"""string""","""string""","""string""","""string""",123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""",123,"""string""","""2000-01-01T00:00:00.000Z""","""string"""

OrderCategories
getpost

Update an existing order category.

Usage:
tq put OrderCategories
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

Orders
getpost

This resource is currently strictly for interceptor plugin use. This is called any time an order is saved via the API or from the client application. Only OrderId is provided in the request content.

This resource will be invoked from a cart checkout.

Usage:
tq put Orders
Query:
{"AcceptingRollovers":true, "AccountId":123, "AltAddressId":123, "AltElectronicAddressId":123, "AppealId":123, "AppliedMessageRules":"string", "BatchId":123, "BusinessUnitId":123, "CategoryId":123, "ChannelId":123, "ConstituentId":123, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Custom0":"string", "Custom1":"string", "Custom2":"string", "Custom3":"string", "Custom4":"string", "Custom5":"string", "Custom6":"string", "Custom7":"string", "Custom8":"string", "Custom9":"string", "DeliveryDate":"2000-01-01T00:00:00.000Z", "DeliveryMethodId":123, "HoldUntilDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "InitiatorId":123, "LineItems":[{"Id":123}, ...], "Messages":[{"Id":123}, ...], "MirrorLock":123, "ModeOfSaleId":123, "Notes":"string", "OrderDateTime":"2000-01-01T00:00:00.000Z", "ReloadPricingRules":true, "Solicitor":"string", "SourceId":123, "TotalDue":123.456, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "VirtualConstituencies":"string", "OrderID":"string"}


Organizations
getpost

Update an existing organization.

Usage:
tq put Organizations
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "LicenseeAccountCode":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"LicenseeAccountCode":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,LicenseeAccountCode,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

OriginalSources
getpost

Update an existing original source.

Usage:
tq put OriginalSources
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

Origins
getpost

Update an existing origin.

Usage:
tq put Origins
Query:
{"ActivityType":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ActivityType.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ActivityType.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

OutputSets
getpost

Update an existing Output Set.

Usage:
tq put OutputSets
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "EditIndicator":true, "ElementGroups":[{"IncludePrimaryAffiliation":true, "IsSingleRow":true, "KeywordId":123}, ...], "Id":123, "LastUsedDateTime":"2000-01-01T00:00:00.000Z", "TMSIndicator":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "OutputSetID":"string"}


P

PackagePriceTypes
getpost

Update an existing package price type.

Usage:
tq put PackagePriceTypes
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "PackageId":123, "PriceTypeId":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "PackagePriceTypeID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Id":123,"PackageId":123,"PackagePriceTypeID":"string","PriceTypeId":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Id,PackageId,PackagePriceTypeID,PriceTypeId,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""",123,123,"""string""",123,"""string""","""2000-01-01T00:00:00.000Z"""

PackageTypes
getpost

Update an existing package type.

Usage:
tq put PackageTypes
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

PackageWebContents
getpost

Update an existing packageWebContent.

Usage:
tq put PackageWebContents
Query:
{"ContentType":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "PackageId":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "Value":"string", "PackageWebContentID":"string"}
[{"ContentType.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Id":123,"PackageId":123,"PackageWebContentID":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","Value":"string"}]
ContentType.Id,CreateLocation,CreatedBy,CreatedDateTime,Id,PackageId,PackageWebContentID,UpdatedBy,UpdatedDateTime,Value
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string"""

PaymentGatewayActivities
getpost

Update an existing Payment Gateway Activity

Usage:
tq put PaymentGatewayActivities
Query:
{"AccountId":123, "AccountNumber":"string", "ActivityData":"string", "Amount":123.456, "AuthCode":"string", "AvsAddress":"string", "AvsPostalcode":"string", "AvsResultCode":"string", "BalanceAmount":123.456, "BalanceCurrencyCode":"string", "ConstituentId":123, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "CvvResultCode":"string", "EcommerceIndicator":"string", "EmvApplicationIdentifier":"string", "EmvApplicationName":"string", "EmvCryptogram":"string", "EmvHostResponseCode":"string", "EmvHostResponseMessage":"string", "EmvPinVerified":"string", "EntryMethod":"string", "ExpirationDate":"string", "Id":123, "MerchantId":"string", "Name":"string", "NetworkTransactionId":"string", "Origin":"string", "PaymentGatewayTransactionType":{"Id":123}, "PaymentId":123, "PaymentMethodGroupId":123, "PaymentMethodId":123, "ProviderCommunicationDurationMs":123, "ProviderTransactionDateTime":"2000-01-01T00:00:00.000Z", "ReferenceNumber":"string", "ResponseCode":"string", "ResponseMessage":"string", "Success":"string", "TerminalIdentifier":"string", "TotalDurationMs":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "UserData":"string", "PaymentGatewayActivityID":"string"}
[{"AccountId":123,"AccountNumber":"string","ActivityData":"string","Amount":123.456,"AuthCode":"string","AvsAddress":"string","AvsPostalcode":"string","AvsResultCode":"string","BalanceAmount":123.456,"BalanceCurrencyCode":"string","ConstituentId":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","CvvResultCode":"string","EcommerceIndicator":"string","EmvApplicationIdentifier":"string","EmvApplicationName":"string","EmvCryptogram":"string","EmvHostResponseCode":"string","EmvHostResponseMessage":"string","EmvPinVerified":"string","EntryMethod":"string","ExpirationDate":"string","Id":123,"MerchantId":"string","Name":"string","NetworkTransactionId":"string","Origin":"string","PaymentGatewayActivityID":"string","PaymentGatewayTransactionType.Id":123,"PaymentId":123,"PaymentMethodGroupId":123,"PaymentMethodId":123,"ProviderCommunicationDurationMs":123,"ProviderTransactionDateTime":"2000-01-01T00:00:00.000Z","ReferenceNumber":"string","ResponseCode":"string","ResponseMessage":"string","Success":"string","TerminalIdentifier":"string","TotalDurationMs":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","UserData":"string"}]
AccountId,AccountNumber,ActivityData,Amount,AuthCode,AvsAddress,AvsPostalcode,AvsResultCode,BalanceAmount,BalanceCurrencyCode,ConstituentId,CreateLocation,CreatedBy,CreatedDateTime,CvvResultCode,EcommerceIndicator,EmvApplicationIdentifier,EmvApplicationName,EmvCryptogram,EmvHostResponseCode,EmvHostResponseMessage,EmvPinVerified,EntryMethod,ExpirationDate,Id,MerchantId,Name,NetworkTransactionId,Origin,PaymentGatewayActivityID,PaymentGatewayTransactionType.Id,PaymentId,PaymentMethodGroupId,PaymentMethodId,ProviderCommunicationDurationMs,ProviderTransactionDateTime,ReferenceNumber,ResponseCode,ResponseMessage,Success,TerminalIdentifier,TotalDurationMs,UpdatedBy,UpdatedDateTime,UserData
123,"""string""","""string""",123.456,"""string""","""string""","""string""","""string""",123.456,"""string""",123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""","""string""",123,"""string""","""string""","""string""","""string""","""string""",123,123,123,123,123,"""2000-01-01T00:00:00.000Z""","""string""","""string""","""string""","""string""","""string""",123,"""string""","""2000-01-01T00:00:00.000Z""","""string"""

PaymentGatewayNotifications
getpost

Update a notification event.

Usage:
tq put PaymentGatewayNotifications
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "EventType":"string", "Id":123, "Payload":"string", "ProcessedDate":"2000-01-01T00:00:00.000Z", "ReceivedDate":"2000-01-01T00:00:00.000Z", "Reference":"string", "Topic":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "NotificationEventID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","EventType":"string","Id":123,"NotificationEventID":"string","Payload":"string","ProcessedDate":"2000-01-01T00:00:00.000Z","ReceivedDate":"2000-01-01T00:00:00.000Z","Reference":"string","Topic":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,EventType,Id,NotificationEventID,Payload,ProcessedDate,ReceivedDate,Reference,Topic,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""",123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""2000-01-01T00:00:00.000Z""","""string""","""string""","""string""","""2000-01-01T00:00:00.000Z"""

PaymentGatewayTransactionTypes
getpost

Update an existing Payment Gateway Transaction Type.

Usage:
tq put PaymentGatewayTransactionTypes
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

PaymentMethodGroups
getpost

Update an existing payment method group.

Usage:
tq put PaymentMethodGroups
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "MerchantId":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"MerchantId":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,MerchantId,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

PaymentMethodUserGroups
getpost

Update an existing payment method/user group mapping.

Usage:
tq put PaymentMethodUserGroups
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "IncomeIndicator":true, "MaxRefund":123.456, "PaymentMethod":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "UserGroupId":"string", "PaymentMethodUserGroupID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Id":123,"IncomeIndicator":true,"MaxRefund":123.456,"PaymentMethod.Id":123,"PaymentMethodUserGroupID":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","UserGroupId":"string"}]
CreateLocation,CreatedBy,CreatedDateTime,Id,IncomeIndicator,MaxRefund,PaymentMethod.Id,PaymentMethodUserGroupID,UpdatedBy,UpdatedDateTime,UserGroupId
"""string""","""string""","""2000-01-01T00:00:00.000Z""",123,true,123.456,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string"""

PaymentMethods
getpost

Update an existing payment method.

Usage:
tq put PaymentMethods
Query:
{"AccountType":{"Id":123}, "AuthIndicator":true, "BusinessUnitId":123, "CanRefund":true, "ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "CurrencyTypeId":123, "DefaultIndicator":true, "Description":"string", "GiftAidIndicator":true, "GlAccountId":"string", "Id":123, "Inactive":true, "Income":true, "MerchantId":"string", "MerchantIdForSwipe":"string", "NoCopiesOnAuth":123, "NoCopiesOnSave":123, "OpenCashDrawer":true, "PaymentMethodGroup":{"Id":123}, "PaymentType":{"Id":123}, "ReceiptFormatId":123, "RequireCheckIndicator":true, "RequireCvv":true, "RequirePostalCode":"string", "ShortDesc":"string", "StoreTenderedAmount":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "UseWithCardReader":true, "PaymentMethodID":"string"}
[{"AccountType.Id":123,"AuthIndicator":true,"BusinessUnitId":123,"CanRefund":true,"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","CurrencyTypeId":123,"DefaultIndicator":true,"Description":"string","GiftAidIndicator":true,"GlAccountId":"string","Id":123,"Inactive":true,"Income":true,"MerchantId":"string","MerchantIdForSwipe":"string","NoCopiesOnAuth":123,"NoCopiesOnSave":123,"OpenCashDrawer":true,"PaymentMethodGroup.Id":123,"PaymentMethodID":"string","PaymentType.Id":123,"ReceiptFormatId":123,"RequireCheckIndicator":true,"RequireCvv":true,"RequirePostalCode":"string","ShortDesc":"string","StoreTenderedAmount":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","UseWithCardReader":true}]
AccountType.Id,AuthIndicator,BusinessUnitId,CanRefund,ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,CurrencyTypeId,DefaultIndicator,Description,GiftAidIndicator,GlAccountId,Id,Inactive,Income,MerchantId,MerchantIdForSwipe,NoCopiesOnAuth,NoCopiesOnSave,OpenCashDrawer,PaymentMethodGroup.Id,PaymentMethodID,PaymentType.Id,ReceiptFormatId,RequireCheckIndicator,RequireCvv,RequirePostalCode,ShortDesc,StoreTenderedAmount,UpdatedBy,UpdatedDateTime,UseWithCardReader
123,true,123,true,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",123,true,"""string""",true,"""string""",123,true,true,"""string""","""string""",123,123,true,123,"""string""",123,123,true,true,"""string""","""string""",true,"""string""","""2000-01-01T00:00:00.000Z""",true

PaymentSignatures
getpost

Update an existing payment signature.

Usage:
tq put PaymentSignatures
Query:
{"Id":123, "PaymentSignatureID":"string"}
[{"Id":123,"PaymentSignatureID":"string"}]
Id,PaymentSignatureID
123,"""string"""

PaymentTypes
getpost

Update an existing payment type.

Usage:
tq put PaymentTypes
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

PerformanceGroups
getpost

Update a Performance Group.

Usage:
tq put PerformanceGroups
Query:
{"ID":"string", "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "DisplayByZone":true, "Facility":{"Id":123}, "FixedSeatIndicator":true, "Id":123, "Season":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ZoneMap":{"Id":123}}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","DisplayByZone":true,"Facility.Id":123,"FixedSeatIndicator":true,"ID":"string","Id":123,"Season.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","ZoneMap.Id":123}]
CreateLocation,CreatedBy,CreatedDateTime,Description,DisplayByZone,Facility.Id,FixedSeatIndicator,ID,Id,Season.Id,UpdatedBy,UpdatedDateTime,ZoneMap.Id
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""",true,123,true,"""string""",123,123,"""string""","""2000-01-01T00:00:00.000Z""",123

PerformancePackageModeOfSales
getpost

Update an existing performance package mode of sale.

Usage:
tq put PerformancePackageModeOfSales
Query:
{"AutoAttend":"string", "ETicketReleaseDateTime":"2000-01-01T00:00:00.000Z", "EndDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "ModeOfSaleId":123, "PackageId":123, "PerformanceId":123, "PrintIndicator":true, "PrintOnAutoAttend":true, "SeatIndicator":true, "StartDateTime":"2000-01-01T00:00:00.000Z", "PerformancePackageModeOfSaleID":"string"}
[{"AutoAttend":"string","ETicketReleaseDateTime":"2000-01-01T00:00:00.000Z","EndDateTime":"2000-01-01T00:00:00.000Z","Id":123,"ModeOfSaleId":123,"PackageId":123,"PerformanceId":123,"PerformancePackageModeOfSaleID":"string","PrintIndicator":true,"PrintOnAutoAttend":true,"SeatIndicator":true,"StartDateTime":"2000-01-01T00:00:00.000Z"}]
AutoAttend,ETicketReleaseDateTime,EndDateTime,Id,ModeOfSaleId,PackageId,PerformanceId,PerformancePackageModeOfSaleID,PrintIndicator,PrintOnAutoAttend,SeatIndicator,StartDateTime
"""string""","""2000-01-01T00:00:00.000Z""","""2000-01-01T00:00:00.000Z""",123,123,123,123,"""string""",true,true,true,"""2000-01-01T00:00:00.000Z"""

PerformancePriceLayers
getpost

Update an existing performance price layer.

Usage:
tq put PerformancePriceLayers
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DefaultDesignationCodeId":123, "DefaultGlAccountId":123, "DefaultResaleAccountId":123, "Description":"string", "EffectiveDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "PerformanceId":123, "PerformancePriceTypes":[{"Id":123}, ...], "PriceLayerType":{"Id":123}, "TemplateId":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "PerformancePriceLayerID":"string"}


Flags:

  • --Prices
    Update a set of prices across one or more performances.
Query:
{"PriceUpdateRequests":[{"Editable":true, "EffectiveDateTime":"2000-01-01T00:00:00.000Z", "Enabled":true, "MinPrice":123.456, "PerformanceIds":"string", "Price":123.456, "PriceLayerTypeId":123, "PriceTypeId":123, "ZoneId":123}, ...]}


PerformancePriceTypes
getpost

Update an existing performance price type.

Usage:
tq put PerformancePriceTypes
Query:
{"BaseIndicator":true, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DesignationCodeId":123, "EffectiveDateTime":"2000-01-01T00:00:00.000Z", "EndDateTime":"2000-01-01T00:00:00.000Z", "GlAccountId":123, "Id":123, "IsWithinDateRange":true, "PerformanceId":123, "PerformancePriceLayerId":123, "PerformancePrices":[{"Id":123}, ...], "PriceTypeId":123, "ResaleAccountId":123, "StartDateTime":"2000-01-01T00:00:00.000Z", "TicketDesignId":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "PerformancePriceTypeID":"string"}


Flags:

  • --Base
    Update base indicator on performance price types for a set of performances and price type.
Query:
{"PerformanceIds":"string", "PriceLayerTypeIds":"string", "PriceTypeID":"string"}
[{"PerformanceIds":"string","PriceLayerTypeIds":"string","PriceTypeID":"string"}]
PerformanceIds,PriceLayerTypeIds,PriceTypeID
"""string""","""string""","""string"""

  • --Bulk
    Update the performance price types for a set of performances.
Query:
{"PerformancePriceType":[{"BaseIndicator":true, "DesignationCodeId":123, "EndDateTime":"2000-01-01T00:00:00.000Z", "GlAccountId":123, "PerformanceIds":"string", "PriceLayerTypeIds":"string", "PriceTypeIds":"string", "ResaleAccountId":123, "StartDateTime":"2000-01-01T00:00:00.000Z", "TicketDesignId":123}, ...]}


PerformancePrices
getpost

Update an existing performance price.

Usage:
tq put PerformancePrices
Query:
{"EditIndicator":true, "EffectiveDateTime":"2000-01-01T00:00:00.000Z", "Enabled":true, "HasEvents":true, "Id":123, "IsPriceBasedOnCurrentEvent":true, "MinPrice":123.456, "PerformanceId":123, "PerformancePriceTypeId":123, "Price":123.456, "ZoneId":123, "PerformancePriceID":"string"}
[{"EditIndicator":true,"EffectiveDateTime":"2000-01-01T00:00:00.000Z","Enabled":true,"HasEvents":true,"Id":123,"IsPriceBasedOnCurrentEvent":true,"MinPrice":123.456,"PerformanceId":123,"PerformancePriceID":"string","PerformancePriceTypeId":123,"Price":123.456,"ZoneId":123}]
EditIndicator,EffectiveDateTime,Enabled,HasEvents,Id,IsPriceBasedOnCurrentEvent,MinPrice,PerformanceId,PerformancePriceID,PerformancePriceTypeId,Price,ZoneId
true,"""2000-01-01T00:00:00.000Z""",true,true,123,true,123.456,123,"""string""",123,123.456,123

PerformanceStatuses
getpost

Update an existing performance status.

Usage:
tq put PerformanceStatuses
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

PerformanceTypes
getpost

Update an existing performance type.

Usage:
tq put PerformanceTypes
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ValidCountryList":"string", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","ValidCountryList":"string"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime,ValidCountryList
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z""","""string"""

Performances
getpost

Expires seat holds for a performance and hold code

Usage:
tq put Performances
Query:
{"ExpireAsOfDate":"2000-01-01T00:00:00.000Z", "SeatIds":"string", "HoldCodeID":"string", "PerformanceID":"string"}
[{"ExpireAsOfDate":"2000-01-01T00:00:00.000Z","HoldCodeID":"string","PerformanceID":"string","SeatIds":"string"}]
ExpireAsOfDate,HoldCodeID,PerformanceID,SeatIds
"""2000-01-01T00:00:00.000Z""","""string""","""string""","""string"""

Philanthropy
getpost

Updated an existing philanthropyEntry for a constituent.

Usage:
tq put Philanthropy
Query:
{"Activity":"string", "Amount":123.456, "Constituent":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DonatedTo":"string", "DonatedToConstituent":{"Id":123}, "DonationDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "PhilanthropyType":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "PhilanthropyEntryID":"string"}
[{"Activity":"string","Amount":123.456,"Constituent.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DonatedTo":"string","DonatedToConstituent.Id":123,"DonationDateTime":"2000-01-01T00:00:00.000Z","Id":123,"PhilanthropyEntryID":"string","PhilanthropyType.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
Activity,Amount,Constituent.Id,CreateLocation,CreatedBy,CreatedDateTime,DonatedTo,DonatedToConstituent.Id,DonationDateTime,Id,PhilanthropyEntryID,PhilanthropyType.Id,UpdatedBy,UpdatedDateTime
"""string""",123.456,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""",123,"""2000-01-01T00:00:00.000Z""",123,"""string""",123,"""string""","""2000-01-01T00:00:00.000Z"""

PhilanthropyTypes
getpost

Update an existing philosophy type.

Usage:
tq put PhilanthropyTypes
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

PhoneIndicators
getpost

Update an existing phone indicator.

Usage:
tq put PhoneIndicators
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

PhoneTypes
getpost

Update an existing phone type.

Usage:
tq put PhoneTypes
Query:
{"AllowMarketing":true, "ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DayEveningIndicator":"string", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"AllowMarketing":true,"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DayEveningIndicator":"string","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
AllowMarketing,ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,DayEveningIndicator,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
true,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

Phones
getpost

Update a phone.

Usage:
tq put Phones
Query:
{"Address":{"Id":123}, "AllowTelemarketing":true, "Constituent":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DayEveningIndicator":"string", "EditIndicator":true, "Id":123, "Inactive":true, "PhoneFormatted":"string", "PhoneNumber":"string", "PhoneSearch":"string", "PhoneType":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "PhoneID":"string"}
[{"Address.Id":123,"AllowTelemarketing":true,"Constituent.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DayEveningIndicator":"string","EditIndicator":true,"Id":123,"Inactive":true,"PhoneFormatted":"string","PhoneID":"string","PhoneNumber":"string","PhoneSearch":"string","PhoneType.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
Address.Id,AllowTelemarketing,Constituent.Id,CreateLocation,CreatedBy,CreatedDateTime,DayEveningIndicator,EditIndicator,Id,Inactive,PhoneFormatted,PhoneID,PhoneNumber,PhoneSearch,PhoneType.Id,UpdatedBy,UpdatedDateTime
123,true,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""",true,123,true,"""string""","""string""","""string""","""string""",123,"""string""","""2000-01-01T00:00:00.000Z"""

PlanPriorities
getpost

Update an existing plan priority.

Usage:
tq put PlanPriorities
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "Ranking":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"Ranking":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,Ranking,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,123,"""string""","""2000-01-01T00:00:00.000Z"""

PlanSources
getpost

Update an existing plan source.

Usage:
tq put PlanSources
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

PlanStatuses
getpost

Update an existing plan status.

Usage:
tq put PlanStatuses
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "Rank":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"Rank":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,Rank,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,123,"""string""","""2000-01-01T00:00:00.000Z"""

PlanTypes
getpost

Update an existing plan type.

Usage:
tq put PlanTypes
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

PlanWorkers
getpost

Update an existing plan worker.

Usage:
tq put PlanWorkers
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "EditIndicator":true, "Id":123, "Plan":{"Id":123}, "PrimaryIndicator":true, "Role":{"Id":123}, "ShowInPortfolio":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "Worker":{"Id":123}, "PlanWorkerID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","EditIndicator":true,"Id":123,"Plan.Id":123,"PlanWorkerID":"string","PrimaryIndicator":true,"Role.Id":123,"ShowInPortfolio":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","Worker.Id":123}]
CreateLocation,CreatedBy,CreatedDateTime,EditIndicator,Id,Plan.Id,PlanWorkerID,PrimaryIndicator,Role.Id,ShowInPortfolio,UpdatedBy,UpdatedDateTime,Worker.Id
"""string""","""string""","""2000-01-01T00:00:00.000Z""",true,123,123,"""string""",true,123,true,"""string""","""2000-01-01T00:00:00.000Z""",123

Plans
getpost

Update an existing plan.

Usage:
tq put Plans
Query:
{"AskAmount":123.456, "Campaign":{"Id":123}, "CompleteByDateTime":"2000-01-01T00:00:00.000Z", "Constituent":{"Id":123}, "ContributionAmount":123.456, "ContributionDesignation":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "CustomDataItems":[{"DataType":"string", "Description":"string", "EditIndicator":true, "Index":123, "IsDropdown":true, "KeywordId":123, "Name":"string", "Value":"string"}, ...], "EditIndicator":true, "Fund":{"Id":123}, "GoalAmount":123.456, "HasOpenSteps":true, "HasSteps":true, "Id":123, "LastStepDate":"2000-01-01T00:00:00.000Z", "LastStepType":{"Id":123}, "LastWorkerDisplayName":"string", "NextStepDate":"2000-01-01T00:00:00.000Z", "NextStepType":{"Id":123}, "Notes":"string", "OriginalSource":{"Id":123}, "PlanAssociates":"string", "PrimaryWorker":{"Id":123}, "Priority":{"Id":123}, "Probability":123.456, "RecordedAmount":123.456, "StartDateTime":"2000-01-01T00:00:00.000Z", "Status":{"Id":123}, "Type":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "PlanID":"string"}


PortfolioCustomElements
getpost

Update an existing portfolio custom element.

Usage:
tq put PortfolioCustomElements
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DataType":123, "Description":"string", "Id":123, "Inactive":true, "SqlQuery":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DataType":123,"Description":"string","ID":"string","Id":123,"Inactive":true,"SqlQuery":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,DataType,Description,ID,Id,Inactive,SqlQuery,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",123,"""string""","""string""",123,true,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

Prefixes
getpost

Update an existing prefix.

Usage:
tq put Prefixes
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

Premieres
getpost

Update an existing premiere.

Usage:
tq put Premieres
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

PriceCategories
getpost

Update an existing price category.

Usage:
tq put PriceCategories
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "Rank":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"Rank":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,Rank,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,123,"""string""","""2000-01-01T00:00:00.000Z"""

PriceEvents
get

Move a set of price events to a new date.

Usage:
tq put PriceEvents
Query:
{"EventDateTime":"2000-01-01T00:00:00.000Z", "EventIds":"string"}
[{"EventDateTime":"2000-01-01T00:00:00.000Z","EventIds":"string"}]
EventDateTime,EventIds
"""2000-01-01T00:00:00.000Z""","""string"""

PriceLayerTypes
getpost

Update an existing price layer type.

Usage:
tq put PriceLayerTypes
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "ExcludeFromRules":true, "Id":123, "Inactive":true, "PriceCategory":{"Id":123}, "Rank":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ExcludeFromRules":true,"ID":"string","Id":123,"Inactive":true,"PriceCategory.Id":123,"Rank":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ExcludeFromRules,ID,Id,Inactive,PriceCategory.Id,Rank,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""",true,"""string""",123,true,123,123,"""string""","""2000-01-01T00:00:00.000Z"""

PriceTemplates
getpost

Update an existing price template.

Usage:
tq put PriceTemplates
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DefaultDesignationCode":{"Id":123}, "DefaultGlAccount":{"Id":123}, "DefaultPriceLayerType":{"Id":123}, "DefaultResaleAccount":{"Id":123}, "Description":"string", "EditIndicator":true, "Id":123, "Inactive":true, "Name":"string", "PriceCategory":{"Id":123}, "TemplatePriceTypes":[{"Id":123}, ...], "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ZoneMap":{"Id":123}, "PriceTemplateID":"string"}


PriceTypeCategories
getpost

Update an existing price type category.

Usage:
tq put PriceTypeCategories
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "ShortDescription":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"ShortDescription":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,ShortDescription,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

PriceTypeGroups
getpost

Update an existing price type group.

Usage:
tq put PriceTypeGroups
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

PriceTypeReasons
getpost

Update an existing price type reason.

Usage:
tq put PriceTypeReasons
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "ShortDescription":"string", "TicketText":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"ShortDescription":"string","TicketText":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,ShortDescription,TicketText,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""string""","""string""","""2000-01-01T00:00:00.000Z"""

PriceTypeUserGroups
getpost

Update an existing price type/user group mapping.

Usage:
tq put PriceTypeUserGroups
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "PriceType":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "UserGroupId":"string", "PriceTypeUserGroupID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Id":123,"PriceType.Id":123,"PriceTypeUserGroupID":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","UserGroupId":"string"}]
CreateLocation,CreatedBy,CreatedDateTime,Id,PriceType.Id,PriceTypeUserGroupID,UpdatedBy,UpdatedDateTime,UserGroupId
"""string""","""string""","""2000-01-01T00:00:00.000Z""",123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string"""

PriceTypes
getpost

Update an existing price type.

Usage:
tq put PriceTypes
Query:
{"AliasDescription":"string", "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DefaultTicketDesign":{"Id":123}, "Description":"string", "EditIndicator":true, "EditableIndicator":true, "Id":123, "Inactive":true, "PriceTypeCategory":{"Id":123}, "PriceTypeGroup":{"Id":123}, "ReasonIndicator":true, "ShortDescription":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "PriceTypeID":"string"}
[{"AliasDescription":"string","CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DefaultTicketDesign.Id":123,"Description":"string","EditIndicator":true,"EditableIndicator":true,"Id":123,"Inactive":true,"PriceTypeCategory.Id":123,"PriceTypeGroup.Id":123,"PriceTypeID":"string","ReasonIndicator":true,"ShortDescription":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
AliasDescription,CreateLocation,CreatedBy,CreatedDateTime,DefaultTicketDesign.Id,Description,EditIndicator,EditableIndicator,Id,Inactive,PriceTypeCategory.Id,PriceTypeGroup.Id,PriceTypeID,ReasonIndicator,ShortDescription,UpdatedBy,UpdatedDateTime
"""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""",123,"""string""",true,true,123,true,123,123,"""string""",true,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

PricingRuleCategories
getpost

Update an existing pricing rule category.

Usage:
tq put PricingRuleCategories
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

PricingRuleMessageTypes
getpost

Update an existing pricing rule message type.

Usage:
tq put PricingRuleMessageTypes
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

PricingRuleSets
getpost

Update an existing pricing rule set.

Usage:
tq put PricingRuleSets
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "EditIndicator":true, "Id":123, "Inactive":true, "Rules":[{"Id":123}, ...], "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "PricingRuleSetID":"string"}


PricingRules
getpost

Update an existing pricing rule.

Usage:
tq put PricingRules
Query:
{"Appeals":"string", "ApplyOncePerOrder":true, "ApplyToLowestCommonNumberOfSeats":true, "Constituencies":"string", "ConstituentAttribute":123, "ConstituentAttributeOperator":{"Id":123}, "ConstituentAttributeValue1":"string", "ConstituentAttributeValue2":"string", "ConstituentExclusionListId":123, "ConstituentListId":123, "ConstituentRankType":123, "ConstituentRankingOperator":{"Id":123}, "ConstituentRankingValue1":123, "ConstituentRankingValue2":123, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "DiscountAmount":123.456, "DiscountIsPercent":true, "DiscountPercentRound":123, "DiscountPriceTypeId":123, "EditIndicator":true, "EndDateTime":"2000-01-01T00:00:00.000Z", "ExcludeGeneralPublic":true, "Id":123, "Inactive":true, "MaxSeats":123, "Messages":[{"Id":123}, ...], "OverTheLimitDateTime":"2000-01-01T00:00:00.000Z", "PromotedAppeals":"string", "PromotedSources":"string", "QualifyingPackage":"string", "QualifyingPerformance":"string", "QualifyingPriceType1":"string", "QualifyingPriceType2":"string", "QualifyingProductionSeason":"string", "QualifyingSeasonPackageType":"string", "QualifyingSeatCount1Value1":123, "QualifyingSeatCount1Value2":123, "QualifyingSeatCount2Value1":123, "QualifyingSeatCount2Value2":123, "QualifyingZone":"string", "RespectMinimumPrice":true, "ResultMaximumSeats":123, "ResultMaximumSeats2":123, "ResultPackage":"string", "ResultPerformance":"string", "ResultPriceType":"string", "ResultProductionSeason":"string", "ResultSeasonPackageType":"string", "ResultSeatCount":123, "ResultZone":"string", "RuleAction":123, "RuleCategory":{"Id":123}, "RuleType":{"Id":123}, "Sources":"string", "StartDateTime":"2000-01-01T00:00:00.000Z", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "PricingRuleID":"string"}


Printers
getpost

Update an existing printer.

Usage:
tq put Printers
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "MaxCol":123, "MaxRow":123, "MaxX2val":123, "MaxY2val":123, "Type":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"MaxCol":123,"MaxRow":123,"MaxX2val":123,"MaxY2val":123,"Type":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,MaxCol,MaxRow,MaxX2val,MaxY2val,Type,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,123,123,123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

ProductionSeasonMembershipOrganizations
getpost

Update an existing production season membership organization.

Usage:
tq put ProductionSeasonMembershipOrganizations
Query:
{"ID":"string", "AllowMultipleEntry":true, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "MembershipOrganization":{"Id":123}, "ProductionSeason":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z"}
[{"AllowMultipleEntry":true,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","ID":"string","Id":123,"MembershipOrganization.Id":123,"ProductionSeason.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
AllowMultipleEntry,CreateLocation,CreatedBy,CreatedDateTime,ID,Id,MembershipOrganization.Id,ProductionSeason.Id,UpdatedBy,UpdatedDateTime
true,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""",123,123,123,"""string""","""2000-01-01T00:00:00.000Z"""

ProgramListings
getpost

Update a program listing.

Usage:
tq put ProgramListings
Query:
{"Constituent":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DonationLevel":{"Id":123}, "EditIndicator":true, "Id":123, "ProgramName":"string", "ProgramType":{"Id":123}, "SortName":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ProgramListingID":"string"}
[{"Constituent.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DonationLevel.Id":123,"EditIndicator":true,"Id":123,"ProgramListingID":"string","ProgramName":"string","ProgramType.Id":123,"SortName":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
Constituent.Id,CreateLocation,CreatedBy,CreatedDateTime,DonationLevel.Id,EditIndicator,Id,ProgramListingID,ProgramName,ProgramType.Id,SortName,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",123,true,123,"""string""","""string""",123,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

Programs
getpost

Update an existing program.

Usage:
tq put Programs
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,"""string""","""2000-01-01T00:00:00.000Z"""

Pronouns
getpost

Usage:
tq put Pronouns
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

Q

QualificationCategories
getpost

Update an existing Qualification Category.

Usage:
tq put QualificationCategories
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

Qualifications
getpost

Update an existing Qualification.

Usage:
tq put Qualifications
Query:
{"Category":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"Category.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
Category.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

QueryElementFilters
getpost

Update an existing query element filter.

Usage:
tq put QueryElementFilters
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DataType":123, "Description":"string", "EndOfDay":true, "FilterElement":"string", "Group":{"Id":123}, "Id":123, "ReferenceDescriptionColumn":"string", "ReferenceIdColumn":"string", "ReferenceSort":"string", "ReferenceTable":"string", "ReferenceWhere":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "QueryElementFilterID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DataType":123,"Description":"string","EndOfDay":true,"FilterElement":"string","Group.Id":123,"Id":123,"QueryElementFilterID":"string","ReferenceDescriptionColumn":"string","ReferenceIdColumn":"string","ReferenceSort":"string","ReferenceTable":"string","ReferenceWhere":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,DataType,Description,EndOfDay,FilterElement,Group.Id,Id,QueryElementFilterID,ReferenceDescriptionColumn,ReferenceIdColumn,ReferenceSort,ReferenceTable,ReferenceWhere,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""",123,"""string""",true,"""string""",123,123,"""string""","""string""","""string""","""string""","""string""","""string""","""string""","""2000-01-01T00:00:00.000Z"""

QueryElementGroups
getpost

Update an existing query element group.

Usage:
tq put QueryElementGroups
Query:
{"Category":123, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DataFrom":"string", "DataWhere":"string", "Description":"string", "Id":123, "IsVirtual":true, "NumberOfParameters":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "QueryElementGroupID":"string"}
[{"Category":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DataFrom":"string","DataWhere":"string","Description":"string","Id":123,"IsVirtual":true,"NumberOfParameters":123,"QueryElementGroupID":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
Category,CreateLocation,CreatedBy,CreatedDateTime,DataFrom,DataWhere,Description,Id,IsVirtual,NumberOfParameters,QueryElementGroupID,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""","""string""",123,true,123,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

QueryElements
getpost

Update an existing query element.

Usage:
tq put QueryElements
Query:
{"ID":"string", "ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DataSelect":"string", "Description":"string", "Group":{"Id":123}, "Id":123, "Inactive":true, "IsSingleRow":true, "KeywordId":123, "PrimaryGroupDefault":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DataSelect":"string","Description":"string","Group.Id":123,"ID":"string","Id":123,"Inactive":true,"IsSingleRow":true,"KeywordId":123,"PrimaryGroupDefault":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,DataSelect,Description,Group.Id,ID,Id,Inactive,IsSingleRow,KeywordId,PrimaryGroupDefault,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,"""string""",123,true,true,123,true,"""string""","""2000-01-01T00:00:00.000Z"""

R

RankTypes
getpost

Update an existing rank type.

Usage:
tq put RankTypes
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

Rankings
getpost

Update a ranking.

Usage:
tq put Rankings
Query:
{"Constituent":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "EditIndicator":true, "Id":123, "Rank":123, "RankType":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "RankingID":"string"}
[{"Constituent.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","EditIndicator":true,"Id":123,"Rank":123,"RankType.Id":123,"RankingID":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
Constituent.Id,CreateLocation,CreatedBy,CreatedDateTime,EditIndicator,Id,Rank,RankType.Id,RankingID,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",true,123,123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

ReceiptSettings
getpost

Update an existing Receipt Setting.

Usage:
tq put ReceiptSettings
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "EmailFooter":"string", "EmailHeader":"string", "EmailSubject":"string", "Id":123, "Inactive":true, "PrintFooter":"string", "PrintHeader":"string", "ReceiptEmailProfile":{"Id":123}, "TicketEmailProfile":{"Id":123}, "TicketEmailSubject":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","EmailFooter":"string","EmailHeader":"string","EmailSubject":"string","ID":"string","Id":123,"Inactive":true,"PrintFooter":"string","PrintHeader":"string","ReceiptEmailProfile.Id":123,"TicketEmailProfile.Id":123,"TicketEmailSubject":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,EmailFooter,EmailHeader,EmailSubject,ID,Id,Inactive,PrintFooter,PrintHeader,ReceiptEmailProfile.Id,TicketEmailProfile.Id,TicketEmailSubject,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""","""string""","""string""","""string""",123,true,"""string""","""string""",123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

ReferenceTableUserGroups
getpost

Update an existing reference table/user group mapping.

Usage:
tq put ReferenceTableUserGroups
Query:
{"CanEdit":true, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "ReferenceTable":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "UserGroupId":"string", "ID":"string"}
[{"CanEdit":true,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","ID":"string","Id":123,"ReferenceTable.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","UserGroupId":"string"}]
CanEdit,CreateLocation,CreatedBy,CreatedDateTime,ID,Id,ReferenceTable.Id,UpdatedBy,UpdatedDateTime,UserGroupId
true,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""",123,123,"""string""","""2000-01-01T00:00:00.000Z""","""string"""

RelationshipCategories
getpost

Update an existing relationship category.

Usage:
tq put RelationshipCategories
Query:
{"CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

ReportRequests
getpost

Update the details of a report request.

Usage:
tq put ReportRequests
Query:
{"ID":"string", "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DeletedIndicator":true, "EmailBody":"string", "EmailRecipients":"string", "EmailSubject":"string", "EndDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "OutputOption":"string", "Parameters":[{"ParameterId":123, "ReportId":"string", "RequestId":123, "Value":"string"}, ...], "PublicIndicator":true, "QueueStatus":"string", "ReportId":"string", "ReportType":123, "RequestDateTime":"2000-01-01T00:00:00.000Z", "ResultCode":"string", "ResultText":"string", "ScheduleId":123, "Type":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "UserGroupId":"string", "UserId":"string"}


Flags:

  • --FlushIncomplete
    Update the status of all the running requests to error.

ReportSchedules
getpost

Update the details of a report schedule.

Usage:
tq put ReportSchedules
Query:
{"ID":"string", "AsOfDateTime":"2000-01-01T00:00:00.000Z", "ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DayOfWeek":123, "DayWeekNumber":123, "EndDate":"2000-01-01T00:00:00.000Z", "EndTime":"2000-01-01T00:00:00.000Z", "HeaderRequest":{"Id":123}, "Id":123, "Inactive":true, "Interval":123, "Name":"string", "StartDate":"2000-01-01T00:00:00.000Z", "StartTime":"2000-01-01T00:00:00.000Z", "Type":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z"}
[{"AsOfDateTime":"2000-01-01T00:00:00.000Z","ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DayOfWeek":123,"DayWeekNumber":123,"EndDate":"2000-01-01T00:00:00.000Z","EndTime":"2000-01-01T00:00:00.000Z","HeaderRequest.Id":123,"ID":"string","Id":123,"Inactive":true,"Interval":123,"Name":"string","StartDate":"2000-01-01T00:00:00.000Z","StartTime":"2000-01-01T00:00:00.000Z","Type":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
AsOfDateTime,ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,DayOfWeek,DayWeekNumber,EndDate,EndTime,HeaderRequest.Id,ID,Id,Inactive,Interval,Name,StartDate,StartTime,Type,UpdatedBy,UpdatedDateTime
"""2000-01-01T00:00:00.000Z""",123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",123,123,"""2000-01-01T00:00:00.000Z""","""2000-01-01T00:00:00.000Z""",123,"""string""",123,true,123,"""string""","""2000-01-01T00:00:00.000Z""","""2000-01-01T00:00:00.000Z""","""string""","""string""","""2000-01-01T00:00:00.000Z"""

ReportUserGroups
getpost

Update an existing report/user group mapping.

Usage:
tq put ReportUserGroups
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "ReportId":"string", "RunRight":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "UserGroupId":"string", "ViewRight":"string", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","ID":"string","Id":123,"ReportId":"string","RunRight":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","UserGroupId":"string","ViewRight":"string"}]
CreateLocation,CreatedBy,CreatedDateTime,ID,Id,ReportId,RunRight,UpdatedBy,UpdatedDateTime,UserGroupId,ViewRight
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""",123,"""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string"""

Research
getpost

Updated an existing research entry for a constituent.

Usage:
tq put Research
Query:
{"Constituent":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "EditIndicator":true, "Id":123, "ResearchDate":"2000-01-01T00:00:00.000Z", "ResearchSource":"string", "ResearchType":{"Id":123}, "Researcher":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ResearchEntryID":"string"}
[{"Constituent.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","EditIndicator":true,"Id":123,"ResearchDate":"2000-01-01T00:00:00.000Z","ResearchEntryID":"string","ResearchSource":"string","ResearchType.Id":123,"Researcher.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
Constituent.Id,CreateLocation,CreatedBy,CreatedDateTime,EditIndicator,Id,ResearchDate,ResearchEntryID,ResearchSource,ResearchType.Id,Researcher.Id,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",true,123,"""2000-01-01T00:00:00.000Z""","""string""","""string""",123,123,"""string""","""2000-01-01T00:00:00.000Z"""

ResearchTypes
getpost

Update an existing research type.

Usage:
tq put ResearchTypes
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

ResourceCategories
getpost

Update an existing Resource Category.

Usage:
tq put ResourceCategories
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

ResourceSchedules
getpost

Update a specific resource schedule. Only Busy or Available types can be updated.

Usage:
tq put ResourceSchedules
Query:
{"BookingAssignmentId":123, "ConstituentId":123, "Count":123, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "EndDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "OverrideConflicts":true, "RecurrenceDayOfWeek":"string", "RecurrenceEndDate":"2000-01-01T00:00:00.000Z", "RecurrenceInterval":123, "RecurrenceOrdinal":123, "RecurrencePattern":123, "ResourceId":123, "StartDateTime":"2000-01-01T00:00:00.000Z", "Type":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ResourceScheduleID":"string"}
[{"BookingAssignmentId":123,"ConstituentId":123,"Count":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","EndDateTime":"2000-01-01T00:00:00.000Z","Id":123,"OverrideConflicts":true,"RecurrenceDayOfWeek":"string","RecurrenceEndDate":"2000-01-01T00:00:00.000Z","RecurrenceInterval":123,"RecurrenceOrdinal":123,"RecurrencePattern":123,"ResourceId":123,"ResourceScheduleID":"string","StartDateTime":"2000-01-01T00:00:00.000Z","Type.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
BookingAssignmentId,ConstituentId,Count,CreateLocation,CreatedBy,CreatedDateTime,Description,EndDateTime,Id,OverrideConflicts,RecurrenceDayOfWeek,RecurrenceEndDate,RecurrenceInterval,RecurrenceOrdinal,RecurrencePattern,ResourceId,ResourceScheduleID,StartDateTime,Type.Id,UpdatedBy,UpdatedDateTime
123,123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""2000-01-01T00:00:00.000Z""",123,true,"""string""","""2000-01-01T00:00:00.000Z""",123,123,123,123,"""string""","""2000-01-01T00:00:00.000Z""",123,"""string""","""2000-01-01T00:00:00.000Z"""

ResourceTypes
getpost

Update an existing resource type.

Usage:
tq put ResourceTypes
Query:
{"ID":"string", "CanBeShared":true, "Category":{"Id":123}, "ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "EditIndicator":true, "HasCapacity":true, "Id":123, "Inactive":true, "RequireAvailability":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z"}
[{"CanBeShared":true,"Category.Id":123,"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","EditIndicator":true,"HasCapacity":true,"ID":"string","Id":123,"Inactive":true,"RequireAvailability":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CanBeShared,Category.Id,ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,EditIndicator,HasCapacity,ID,Id,Inactive,RequireAvailability,UpdatedBy,UpdatedDateTime
true,123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""",true,true,"""string""",123,true,true,"""string""","""2000-01-01T00:00:00.000Z"""

Resources
getpost

Update an existing Resource.

Usage:
tq put Resources
Query:
{"ID":"string", "Capacity":123, "Constituent":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DefaultConfirmationText":"string", "Description":"string", "EditIndicator":true, "Id":123, "Inactive":true, "Notes":"string", "ResourceType":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z"}
[{"Capacity":123,"Constituent.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DefaultConfirmationText":"string","Description":"string","EditIndicator":true,"ID":"string","Id":123,"Inactive":true,"Notes":"string","ResourceType.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
Capacity,Constituent.Id,CreateLocation,CreatedBy,CreatedDateTime,DefaultConfirmationText,Description,EditIndicator,ID,Id,Inactive,Notes,ResourceType.Id,UpdatedBy,UpdatedDateTime
123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",true,"""string""",123,true,"""string""",123,"""string""","""2000-01-01T00:00:00.000Z"""

S

SalesChannels
getpost

Update an existing sales channel.

Usage:
tq put SalesChannels
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

SalesLayoutButtonTypes
getpost

Update an existing sales layout button type.

Usage:
tq put SalesLayoutButtonTypes
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,"""string""","""2000-01-01T00:00:00.000Z"""

SalesLayouts
getpost

Update an existing sales layout setup.

Usage:
tq put SalesLayouts
Query:
{"Columns":123, "ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "PaymentMethods":[{"Id":123}, ...], "PriceTypes":[{"Id":123}, ...], "PrimaryIndicator":true, "Rows":123, "SalesLayoutButtons":[{"Id":123}, ...], "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "SalesLayoutID":"string"}


SalutationTypes
getpost

Update an existing salutation type.

Usage:
tq put SalutationTypes
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

Salutations
getpost

Update a salutation.

Usage:
tq put Salutations
Query:
{"BusinessTitle":"string", "Constituent":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DefaultIndicator":true, "EditIndicator":true, "EnvelopeSalutation1":"string", "EnvelopeSalutation2":"string", "Id":123, "IsFromAffiliation":true, "Label":true, "LetterSalutation":"string", "SalutationType":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "SalutationID":"string"}
[{"BusinessTitle":"string","Constituent.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DefaultIndicator":true,"EditIndicator":true,"EnvelopeSalutation1":"string","EnvelopeSalutation2":"string","Id":123,"IsFromAffiliation":true,"Label":true,"LetterSalutation":"string","SalutationID":"string","SalutationType.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
BusinessTitle,Constituent.Id,CreateLocation,CreatedBy,CreatedDateTime,DefaultIndicator,EditIndicator,EnvelopeSalutation1,EnvelopeSalutation2,Id,IsFromAffiliation,Label,LetterSalutation,SalutationID,SalutationType.Id,UpdatedBy,UpdatedDateTime
"""string""",123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",true,true,"""string""","""string""",123,true,true,"""string""","""string""",123,"""string""","""2000-01-01T00:00:00.000Z"""

SchedulePatternTypes
getpost

Update an existing Schedule Pattern.

Usage:
tq put SchedulePatternTypes
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

ScheduleTypes
getpost

Update an existing Schedule Type.

Usage:
tq put ScheduleTypes
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

SeasonTypes
getpost

Update an existing season type.

Usage:
tq put SeasonTypes
Query:
{"BusinessUnit":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"BusinessUnit.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
BusinessUnit.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

Seasons
getpost

Update an existing season.

Usage:
tq put Seasons
Query:
{"ConfirmationNoticeFormat":123, "ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DefaultIndicator":true, "Description":"string", "DisplayInSeasonOverview":true, "EndDateTime":"2000-01-01T00:00:00.000Z", "FYear":123, "Id":123, "Inactive":true, "RenewalNoticeFormat":123, "StartDateTime":"2000-01-01T00:00:00.000Z", "SubscriptionFund1":123, "SubscriptionFund2":123, "Type":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "YearlySeason":123, "ID":"string"}
[{"ConfirmationNoticeFormat":123,"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DefaultIndicator":true,"Description":"string","DisplayInSeasonOverview":true,"EndDateTime":"2000-01-01T00:00:00.000Z","FYear":123,"ID":"string","Id":123,"Inactive":true,"RenewalNoticeFormat":123,"StartDateTime":"2000-01-01T00:00:00.000Z","SubscriptionFund1":123,"SubscriptionFund2":123,"Type.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","YearlySeason":123}]
ConfirmationNoticeFormat,ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,DefaultIndicator,Description,DisplayInSeasonOverview,EndDateTime,FYear,ID,Id,Inactive,RenewalNoticeFormat,StartDateTime,SubscriptionFund1,SubscriptionFund2,Type.Id,UpdatedBy,UpdatedDateTime,YearlySeason
123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",true,"""string""",true,"""2000-01-01T00:00:00.000Z""",123,"""string""",123,true,123,"""2000-01-01T00:00:00.000Z""",123,123,123,"""string""","""2000-01-01T00:00:00.000Z""",123

SeatCodes
getpost

Update an existing seat code.

Usage:
tq put SeatCodes
Query:
{"BackColor":123, "Context":"string", "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "DisplayLetter":"string", "ForeColor":123, "Id":123, "Inactive":true, "IsSeat":123, "TicketText":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"BackColor":123,"Context":"string","CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","DisplayLetter":"string","ForeColor":123,"ID":"string","Id":123,"Inactive":true,"IsSeat":123,"TicketText":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
BackColor,Context,CreateLocation,CreatedBy,CreatedDateTime,Description,DisplayLetter,ForeColor,ID,Id,Inactive,IsSeat,TicketText,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,"""string""",123,true,123,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

SeatStatuses
getpost

Update an existing seat status.

Usage:
tq put SeatStatuses
Query:
{"BackColor":123, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "ForeColor":123, "Id":123, "Inactive":true, "StatusCode":"string", "StatusLegend":"string", "StatusPriority":123, "Tck":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"BackColor":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ForeColor":123,"ID":"string","Id":123,"Inactive":true,"StatusCode":"string","StatusLegend":"string","StatusPriority":123,"Tck":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
BackColor,CreateLocation,CreatedBy,CreatedDateTime,Description,ForeColor,ID,Id,Inactive,StatusCode,StatusLegend,StatusPriority,Tck,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""",123,"""string""",123,true,"""string""","""string""",123,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

Sections
getpost

Update an existing section.

Usage:
tq put Sections
Query:
{"AdditionalText":"string", "AdditionalText2":"string", "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "PrintDesc":"string", "PrintSequence":123, "SectionLegend":"string", "ShortDesc":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"AdditionalText":"string","AdditionalText2":"string","CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"PrintDesc":"string","PrintSequence":123,"SectionLegend":"string","ShortDesc":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
AdditionalText,AdditionalText2,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,PrintDesc,PrintSequence,SectionLegend,ShortDesc,UpdatedBy,UpdatedDateTime
"""string""","""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,"""string""",123,"""string""","""string""","""string""","""2000-01-01T00:00:00.000Z"""

ServiceResourceUserGroups
getpost

Update an existing service resource/user group mapping.

Usage:
tq put ServiceResourceUserGroups
Query:
{"CanCreate":true, "CanDelete":true, "CanRead":true, "CanUpdate":true, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "ServiceResource":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "UserGroupId":"string", "ID":"string"}
[{"CanCreate":true,"CanDelete":true,"CanRead":true,"CanUpdate":true,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","ID":"string","Id":123,"ServiceResource.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","UserGroupId":"string"}]
CanCreate,CanDelete,CanRead,CanUpdate,CreateLocation,CreatedBy,CreatedDateTime,ID,Id,ServiceResource.Id,UpdatedBy,UpdatedDateTime,UserGroupId
true,true,true,true,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""",123,123,"""string""","""2000-01-01T00:00:00.000Z""","""string"""

Session
getpost

Sets the current constituent on the cart for a business facing session If the Constituent is a primary affiliate of a household, the method obeys the "TRANSACT_AS_HOUSEHOLD_ORDER" entry in T_DEFAULTS to determine if the household constituent should be set. If the default is set to "Prompt", both the household and individual are returned, to allow the user to be queried. To set the constituent to the users choice pass in the selected constituent id and set OverridePrompt to true.

Usage:
tq put Session
Query:
{"ConstituentId":123, "OverridePrompt":true, "SessionKey":"string"}
[{"ConstituentId":123,"OverridePrompt":true,"SessionKey":"string"}]
ConstituentId,OverridePrompt,SessionKey
123,true,"""string"""

Flags:

  • --SetExpiration
    Changes the deadline after which a session's reserved seats are released All times are relative to the machine on which the Tessitura Seat Server runs, including the time zone. The method either takes an absolute deadline time or an offset in seconds which is used to shorten or lengthen the time until expiration. The deadline is not the exact moment at which the seats are released, but rather when they are marked as expired. The Tessitura Seat Server will terminate the session when the next cleanup cycle is run (every 60 seconds or so). The method will return the new expiration date/time of the session. The expiration date/time takes precendence over the offset if both are provided in the request.
Query:
{"Expiration":"2000-01-01T00:00:00.000Z", "TimeOffset":123, "SessionKey":"string"}
[{"Expiration":"2000-01-01T00:00:00.000Z","SessionKey":"string","TimeOffset":123}]
Expiration,SessionKey,TimeOffset
"""2000-01-01T00:00:00.000Z""","""string""",123

  • --Variable
    Update the value of an existing session variable.
Query:
{"SessionKey":"string", "Name":"string", "Value":"string"}
[{"Name":"string","SessionKey":"string","Value":"string"}]
Name,SessionKey,Value
"""string""","""string""","""string"""

  • --WebLogin
    Updates the login information for a user and logs back into the session using new credentials.

Current and new values must be submitted for login username, password, and email. To retain any of the current values pass the same value for both the current and the new parameter. After successfully updating the user account, the user is automatically logged in with the new login information.

When updating a login where the password has been forgotten, submit the request with a null password.

Query:
{"EmailAddress":"string", "LoginName":"string", "LoginTypeId":123, "NewEmailAddress":"string", "NewLoginName":"string", "NewPassword":"string", "Password":"string", "PromotionCode":123, "SessionKey":"string"}
[{"EmailAddress":"string","LoginName":"string","LoginTypeId":123,"NewEmailAddress":"string","NewLoginName":"string","NewPassword":"string","Password":"string","PromotionCode":123,"SessionKey":"string"}]
EmailAddress,LoginName,LoginTypeId,NewEmailAddress,NewLoginName,NewPassword,Password,PromotionCode,SessionKey
"""string""","""string""",123,"""string""","""string""","""string""","""string""",123,"""string"""

SourceGroups
getpost

Update an existing source group.

Usage:
tq put SourceGroups
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

SpecialActivities
getpost

Update an activity record.

Usage:
tq put SpecialActivities
Query:
{"ConstituentId":123, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "Notes":"string", "NumberOfAttendees":123, "Performance":"string", "SpecialActivityDateTime":"2000-01-01T00:00:00.000Z", "Status":{"Id":123}, "Type":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "WorkerConstituentId":123, "SpecialActivityID":"string"}
[{"ConstituentId":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Id":123,"Notes":"string","NumberOfAttendees":123,"Performance":"string","SpecialActivityDateTime":"2000-01-01T00:00:00.000Z","SpecialActivityID":"string","Status.Id":123,"Type.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","WorkerConstituentId":123}]
ConstituentId,CreateLocation,CreatedBy,CreatedDateTime,Id,Notes,NumberOfAttendees,Performance,SpecialActivityDateTime,SpecialActivityID,Status.Id,Type.Id,UpdatedBy,UpdatedDateTime,WorkerConstituentId
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",123,"""string""",123,"""string""","""2000-01-01T00:00:00.000Z""","""string""",123,123,"""string""","""2000-01-01T00:00:00.000Z""",123

SpecialActivityStatuses
getpost

Update an Special Activity Status.

Usage:
tq put SpecialActivityStatuses
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

SpecialActivityTypes
getpost

Update an existing Special Activity Type.

Usage:
tq put SpecialActivityTypes
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

States
getpost

Update an existing state.

Usage:
tq put States
Query:
{"Country":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "StateCode":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"Country.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"StateCode":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
Country.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,StateCode,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

StepTypes
getpost

Update an existing step type.

Usage:
tq put StepTypes
Query:
{"AllowAttachments":"string", "ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "UseAssociate":"string", "UseCompletedOnDateTime":"string", "UseDueDateTime":"string", "UseNote":"string", "UseWarningDays":"string", "UseWorker":"string", "ID":"string"}
[{"AllowAttachments":"string","ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","UseAssociate":"string","UseCompletedOnDateTime":"string","UseDueDateTime":"string","UseNote":"string","UseWarningDays":"string","UseWorker":"string"}]
AllowAttachments,ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime,UseAssociate,UseCompletedOnDateTime,UseDueDateTime,UseNote,UseWarningDays,UseWorker
"""string""",123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""","""string""","""string""","""string""","""string"""

Steps
getpost

Update an existing step.

Usage:
tq put Steps
Query:
{"Associate":{"Id":123}, "CompletedOnDateTime":"2000-01-01T00:00:00.000Z", "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "DueDateTime":"2000-01-01T00:00:00.000Z", "EditIndicator":true, "Id":123, "NewValue":"string", "Notes":"string", "OldValue":"string", "Plan":{"Id":123}, "Priority":123, "StepDateTime":"2000-01-01T00:00:00.000Z", "Type":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "WarningDays":123, "Worker":{"Id":123}, "StepID":"string"}
[{"Associate.Id":123,"CompletedOnDateTime":"2000-01-01T00:00:00.000Z","CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","DueDateTime":"2000-01-01T00:00:00.000Z","EditIndicator":true,"Id":123,"NewValue":"string","Notes":"string","OldValue":"string","Plan.Id":123,"Priority":123,"StepDateTime":"2000-01-01T00:00:00.000Z","StepID":"string","Type.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","WarningDays":123,"Worker.Id":123}]
Associate.Id,CompletedOnDateTime,CreateLocation,CreatedBy,CreatedDateTime,Description,DueDateTime,EditIndicator,Id,NewValue,Notes,OldValue,Plan.Id,Priority,StepDateTime,StepID,Type.Id,UpdatedBy,UpdatedDateTime,WarningDays,Worker.Id
123,"""2000-01-01T00:00:00.000Z""","""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""2000-01-01T00:00:00.000Z""",true,123,"""string""","""string""","""string""",123,123,"""2000-01-01T00:00:00.000Z""","""string""",123,"""string""","""2000-01-01T00:00:00.000Z""",123,123

Flags:

  • --Document
    Update a document attached to a step.
Query:
{"Category":{"Id":123}, "ConstituentId":123, "Contents":"AA==", "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "FileName":"string", "Id":123, "Notes":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "DocumentID":"string", "StepID":"string"}
[{"Category.Id":123,"ConstituentId":123,"Contents":"AA==","CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","DocumentID":"string","FileName":"string","Id":123,"Notes":"string","StepID":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
Category.Id,ConstituentId,Contents,CreateLocation,CreatedBy,CreatedDateTime,Description,DocumentID,FileName,Id,Notes,StepID,UpdatedBy,UpdatedDateTime
123,123,"""AA==""","""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""","""string""",123,"""string""","""string""","""string""","""2000-01-01T00:00:00.000Z"""

SubLineItemStatuses
getpost

Update an existing sub line item status.

Usage:
tq put SubLineItemStatuses
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "Priority":123, "StatusCode":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"Priority":123,"StatusCode":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,Priority,StatusCode,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,123,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

Suffixes
getpost

Update an existing suffix.

Usage:
tq put Suffixes
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

SurveyQuestions
getpost

Update an existing survey question.

Usage:
tq put SurveyQuestions
Query:
{"AskType":123, "ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DataType":123, "DefaultValue":"string", "Id":123, "Inactive":true, "Question":"string", "ReferenceTable":"string", "ReferenceTableDescriptionColumn":"string", "ReferenceTableIdColumn":"string", "ReferenceTableSort":"string", "ReferenceTableWhereClause":"string", "Required":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"AskType":123,"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DataType":123,"DefaultValue":"string","ID":"string","Id":123,"Inactive":true,"Question":"string","ReferenceTable":"string","ReferenceTableDescriptionColumn":"string","ReferenceTableIdColumn":"string","ReferenceTableSort":"string","ReferenceTableWhereClause":"string","Required":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
AskType,ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,DataType,DefaultValue,ID,Id,Inactive,Question,ReferenceTable,ReferenceTableDescriptionColumn,ReferenceTableIdColumn,ReferenceTableSort,ReferenceTableWhereClause,Required,UpdatedBy,UpdatedDateTime
123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",123,"""string""","""string""",123,true,"""string""","""string""","""string""","""string""","""string""","""string""",true,"""string""","""2000-01-01T00:00:00.000Z"""

SurveyResponses
getpost

Update an existing survey response.

Usage:
tq put SurveyResponses
Query:
{"Answer":"string", "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "OrderId":123, "QuestionId":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "SurveyResponseID":"string"}
[{"Answer":"string","CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Id":123,"OrderId":123,"QuestionId":123,"SurveyResponseID":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
Answer,CreateLocation,CreatedBy,CreatedDateTime,Id,OrderId,QuestionId,SurveyResponseID,UpdatedBy,UpdatedDateTime
"""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""",123,123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z"""

T

TemplateCategories
getpost

Update an existing template category

Usage:
tq put TemplateCategories
Query:
{"ID":"string", "ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "EditIndicator":true, "Id":123, "Inactive":true, "Type":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","EditIndicator":true,"ID":"string","Id":123,"Inactive":true,"Type.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,EditIndicator,ID,Id,Inactive,Type.Id,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""",true,"""string""",123,true,123,"""string""","""2000-01-01T00:00:00.000Z"""

TemplatePriceTypes
getpost

Update an existing template price type.

Usage:
tq put TemplatePriceTypes
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DesignationCode":{"Id":123}, "GlAccount":{"Id":123}, "Id":123, "PriceTemplate":{"Id":123}, "PriceType":{"Id":123}, "ResaleAccount":{"Id":123}, "TemplatePrices":[{"Id":123}, ...], "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "TemplatePriceTypeID":"string"}


TemplatePrices
getpost

Update an existing template price.

Usage:
tq put TemplatePrices
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "EditIndicator":true, "Enabled":true, "Id":123, "MinPrice":123.456, "Price":123.456, "TemplatePriceType":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "Zone":{"Id":123}, "TemplatePriceID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","EditIndicator":true,"Enabled":true,"Id":123,"MinPrice":123.456,"Price":123.456,"TemplatePriceID":"string","TemplatePriceType.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","Zone.Id":123}]
CreateLocation,CreatedBy,CreatedDateTime,EditIndicator,Enabled,Id,MinPrice,Price,TemplatePriceID,TemplatePriceType.Id,UpdatedBy,UpdatedDateTime,Zone.Id
"""string""","""string""","""2000-01-01T00:00:00.000Z""",true,true,123,123.456,123.456,"""string""",123,"""string""","""2000-01-01T00:00:00.000Z""",123

Templates
getpost

Update an existing template

Usage:
tq put Templates
Query:
{"Category":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "EditIndicator":true, "Id":123, "Inactive":true, "IsHtmlBody":true, "TemplateBody":"string", "TemplateSubject":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "TemplateID":"string"}
[{"Category.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","EditIndicator":true,"Id":123,"Inactive":true,"IsHtmlBody":true,"TemplateBody":"string","TemplateID":"string","TemplateSubject":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
Category.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,EditIndicator,Id,Inactive,IsHtmlBody,TemplateBody,TemplateID,TemplateSubject,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""",true,123,true,true,"""string""","""string""","""string""","""string""","""2000-01-01T00:00:00.000Z"""

Theaters
getpost

Update an existing theater.

Usage:
tq put Theaters
Query:
{"City":"string", "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "DataWindowDefinition":"string", "Description":"string", "DrivingDirections":"string", "Id":123, "Inactive":true, "MaximumNumberOfSeats":123, "Phone":"string", "PostalCode":"string", "State":"string", "Street":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"City":"string","CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","DataWindowDefinition":"string","Description":"string","DrivingDirections":"string","ID":"string","Id":123,"Inactive":true,"MaximumNumberOfSeats":123,"Phone":"string","PostalCode":"string","State":"string","Street":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
City,CreateLocation,CreatedBy,CreatedDateTime,DataWindowDefinition,Description,DrivingDirections,ID,Id,Inactive,MaximumNumberOfSeats,Phone,PostalCode,State,Street,UpdatedBy,UpdatedDateTime
"""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""","""string""","""string""",123,true,123,"""string""","""string""","""string""","""string""","""string""","""2000-01-01T00:00:00.000Z"""

TimeSlots
getpost

Update an existing time slot.

Usage:
tq put TimeSlots
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "EndTime":"2000-01-01T00:00:00.000Z", "Id":123, "Inactive":true, "StartTime":"2000-01-01T00:00:00.000Z", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","EndTime":"2000-01-01T00:00:00.000Z","ID":"string","Id":123,"Inactive":true,"StartTime":"2000-01-01T00:00:00.000Z","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,EndTime,ID,Id,Inactive,StartTime,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""2000-01-01T00:00:00.000Z""","""string""",123,true,"""2000-01-01T00:00:00.000Z""","""string""","""2000-01-01T00:00:00.000Z"""

TriPOSCloudConfigurations
getpost

Update an existing TriPOS Cloud configuration.

Usage:
tq put TriPOSCloudConfigurations
Query:
{"ConfigSetting":"string", "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ConfigSetting":"string","CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ConfigSetting,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

U

UpgradeCategories
getpost

Update an existing Upgrade Category.

Usage:
tq put UpgradeCategories
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

UpgradeLogs
getpost

Updates the given upgradeLog.

Usage:
tq put UpgradeLogs
Query:
{"CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "HotFixNumber":123, "Id":123, "ReleaseDescription":"string", "ScriptId":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "UpgradeCategorySummary":{"Id":123}, "Version":"string", "UpgradeLogID":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","HotFixNumber":123,"Id":123,"ReleaseDescription":"string","ScriptId":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","UpgradeCategorySummary.Id":123,"UpgradeLogID":"string","Version":"string"}]
CreateLocation,CreatedBy,CreatedDateTime,HotFixNumber,Id,ReleaseDescription,ScriptId,UpdatedBy,UpdatedDateTime,UpgradeCategorySummary.Id,UpgradeLogID,Version
"""string""","""string""","""2000-01-01T00:00:00.000Z""",123,123,"""string""",123,"""string""","""2000-01-01T00:00:00.000Z""",123,"""string""","""string"""

UserPreferences
getpost

Update a user preference by id.

Usage:
tq put UserPreferences
Query:
{"ID":"string", "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "Key":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "Value":"string"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","ID":"string","Id":123,"Key":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","Value":"string"}]
CreateLocation,CreatedBy,CreatedDateTime,ID,Id,Key,UpdatedBy,UpdatedDateTime,Value
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""",123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string"""

V

W

WebContentTypes
getpost

Update an existing Web Content Type.

Usage:
tq put WebContentTypes
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "EditMask":"string", "FullTextSearchIndicator":true, "Id":123, "Inactive":true, "LastContentUseUpdateDateTime":"2000-01-01T00:00:00.000Z", "Limit":123, "ReferenceDescriptionColumn":"string", "ReferenceIdColumn":"string", "ReferenceSort":"string", "ReferenceTable":"string", "ReferenceWhere":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "UseWebApi":true, "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","EditMask":"string","FullTextSearchIndicator":true,"ID":"string","Id":123,"Inactive":true,"LastContentUseUpdateDateTime":"2000-01-01T00:00:00.000Z","Limit":123,"ReferenceDescriptionColumn":"string","ReferenceIdColumn":"string","ReferenceSort":"string","ReferenceTable":"string","ReferenceWhere":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","UseWebApi":true}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,EditMask,FullTextSearchIndicator,ID,Id,Inactive,LastContentUseUpdateDateTime,Limit,ReferenceDescriptionColumn,ReferenceIdColumn,ReferenceSort,ReferenceTable,ReferenceWhere,UpdatedBy,UpdatedDateTime,UseWebApi
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",true,"""string""",123,true,"""2000-01-01T00:00:00.000Z""",123,"""string""","""string""","""string""","""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""",true

WebLogins
getpost

Update a weblogin.

Usage:
tq put WebLogins
Query:
{"Constituent":{"Id":123}, "ConstituentUpdateDate":"2000-01-01T00:00:00.000Z", "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "EditIndicator":true, "Email":{"Id":123}, "FailedAttempts":123, "Id":123, "Inactive":true, "LastLoginDate":"2000-01-01T00:00:00.000Z", "LockedDate":"2000-01-01T00:00:00.000Z", "Login":"string", "LoginType":{"Id":123}, "PrimaryIndicator":true, "TemporaryIndicator":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "LoginID":"string"}
[{"Constituent.Id":123,"ConstituentUpdateDate":"2000-01-01T00:00:00.000Z","CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","EditIndicator":true,"Email.Id":123,"FailedAttempts":123,"Id":123,"Inactive":true,"LastLoginDate":"2000-01-01T00:00:00.000Z","LockedDate":"2000-01-01T00:00:00.000Z","Login":"string","LoginID":"string","LoginType.Id":123,"PrimaryIndicator":true,"TemporaryIndicator":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
Constituent.Id,ConstituentUpdateDate,CreateLocation,CreatedBy,CreatedDateTime,EditIndicator,Email.Id,FailedAttempts,Id,Inactive,LastLoginDate,LockedDate,Login,LoginID,LoginType.Id,PrimaryIndicator,TemporaryIndicator,UpdatedBy,UpdatedDateTime
123,"""2000-01-01T00:00:00.000Z""","""string""","""string""","""2000-01-01T00:00:00.000Z""",true,123,123,123,true,"""2000-01-01T00:00:00.000Z""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,true,"""string""","""2000-01-01T00:00:00.000Z"""

WorkerQualifications
getpost

Update an existing WorkerQualification.

Usage:
tq put WorkerQualifications
Query:
{"Constituent":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "EndDateTime":"2000-01-01T00:00:00.000Z", "Id":123, "Qualification":{"Id":123}, "StartDateTime":"2000-01-01T00:00:00.000Z", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "WorkerQualificationID":"string"}
[{"Constituent.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","EndDateTime":"2000-01-01T00:00:00.000Z","Id":123,"Qualification.Id":123,"StartDateTime":"2000-01-01T00:00:00.000Z","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","WorkerQualificationID":"string"}]
Constituent.Id,CreateLocation,CreatedBy,CreatedDateTime,EndDateTime,Id,Qualification.Id,StartDateTime,UpdatedBy,UpdatedDateTime,WorkerQualificationID
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""2000-01-01T00:00:00.000Z""",123,123,"""2000-01-01T00:00:00.000Z""","""string""","""2000-01-01T00:00:00.000Z""","""string"""

WorkerRoles
getpost

Update an existing worker role.

Usage:
tq put WorkerRoles
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "ShowInPortfolioDefault":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"ShowInPortfolioDefault":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,ShowInPortfolioDefault,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,true,"""string""","""2000-01-01T00:00:00.000Z"""

WorkerTypes
getpost

Update an existing worker type.

Usage:
tq put WorkerTypes
Query:
{"ControlGroup":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"ControlGroup.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
ControlGroup.Id,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,UpdatedBy,UpdatedDateTime
123,"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,"""string""","""2000-01-01T00:00:00.000Z"""

Workers
getpost

Update an existing worker.

Usage:
tq put Workers
Query:
{"ConstituentId":123, "ConstituentInactive":{"Id":123}, "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "EditIndicator":true, "FirstName":"string", "Id":123, "Inactive":true, "LastName":"string", "Prefix":{"Id":123}, "ShortDisplayName":"string", "SortName":"string", "Suffix":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "WorkerType":{"Id":123}, "WorkerID":"string"}
[{"ConstituentId":123,"ConstituentInactive.Id":123,"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","EditIndicator":true,"FirstName":"string","Id":123,"Inactive":true,"LastName":"string","Prefix.Id":123,"ShortDisplayName":"string","SortName":"string","Suffix.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","WorkerID":"string","WorkerType.Id":123}]
ConstituentId,ConstituentInactive.Id,CreateLocation,CreatedBy,CreatedDateTime,EditIndicator,FirstName,Id,Inactive,LastName,Prefix.Id,ShortDisplayName,SortName,Suffix.Id,UpdatedBy,UpdatedDateTime,WorkerID,WorkerType.Id
123,123,"""string""","""string""","""2000-01-01T00:00:00.000Z""",true,"""string""",123,true,"""string""",123,"""string""","""string""",123,"""string""","""2000-01-01T00:00:00.000Z""","""string""",123

Z

ZoneGroups
getpost

Update an existing zone group.

Usage:
tq put ZoneGroups
Query:
{"AliasDescription":"string", "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "Rank":123, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ID":"string"}
[{"AliasDescription":"string","CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"Rank":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
AliasDescription,CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,Rank,UpdatedBy,UpdatedDateTime
"""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,123,"""string""","""2000-01-01T00:00:00.000Z"""

ZoneMaps
getpost

Update an existing zone map.

Usage:
tq put ZoneMaps
Query:
{"ID":"string", "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "Id":123, "Inactive":true, "SeatMap":{"Id":123}, "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z"}
[{"CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","ID":"string","Id":123,"Inactive":true,"SeatMap.Id":123,"UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z"}]
CreateLocation,CreatedBy,CreatedDateTime,Description,ID,Id,Inactive,SeatMap.Id,UpdatedBy,UpdatedDateTime
"""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,true,123,"""string""","""2000-01-01T00:00:00.000Z"""

Zones
getpost

Update an existing zone.

Usage:
tq put Zones
Query:
{"Abbreviation":"string", "CreateLocation":"string", "CreatedBy":"string", "CreatedDateTime":"2000-01-01T00:00:00.000Z", "Description":"string", "EndTime":"string", "Id":123, "Rank":123, "ShortDescription":"string", "StartTime":"string", "UpdatedBy":"string", "UpdatedDateTime":"2000-01-01T00:00:00.000Z", "ZoneGroup":{"Id":123}, "ZoneLegend":"string", "ZoneMapId":123, "ZoneTime":"string", "ZoneID":"string", "ZoneMapID":"string"}
[{"Abbreviation":"string","CreateLocation":"string","CreatedBy":"string","CreatedDateTime":"2000-01-01T00:00:00.000Z","Description":"string","EndTime":"string","Id":123,"Rank":123,"ShortDescription":"string","StartTime":"string","UpdatedBy":"string","UpdatedDateTime":"2000-01-01T00:00:00.000Z","ZoneGroup.Id":123,"ZoneID":"string","ZoneLegend":"string","ZoneMapID":"string","ZoneMapId":123,"ZoneTime":"string"}]
Abbreviation,CreateLocation,CreatedBy,CreatedDateTime,Description,EndTime,Id,Rank,ShortDescription,StartTime,UpdatedBy,UpdatedDateTime,ZoneGroup.Id,ZoneID,ZoneLegend,ZoneMapID,ZoneMapId,ZoneTime
"""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""","""string""","""string""",123,123,"""string""","""string""","""string""","""2000-01-01T00:00:00.000Z""",123,"""string""","""string""","""string""",123,"""string"""