A
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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
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"""
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"""
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"""
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
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"""
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"""
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
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"""
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"""
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
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"""
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
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:
{"PaymentID":"string"}
[{"PaymentID":"string"}]
PaymentID
"""string"""
B
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"""
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"""
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"""
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"""
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"""
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"}
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"}
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"""
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"""
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
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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
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"""
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"""
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"""
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"""
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"""
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"""
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
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"""
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"""
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"""
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
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"""
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
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
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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
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"""
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"""
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
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"""
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"""
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"""
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"""
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"""
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
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"""
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"""
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"""
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
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"""
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
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"""
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"""
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, ...]}
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
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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
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"""
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
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"""
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"""
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"}
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"""
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"""
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"""
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
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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
Update an existing payment signature.
Usage:
tq put PaymentSignatures
Query:
{"Id":123, "PaymentSignatureID":"string"}
[{"Id":123,"PaymentSignatureID":"string"}]
Id,PaymentSignatureID
123,"""string"""
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"""
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
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"""
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}, ...]}
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}, ...]}
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
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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
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"}
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"""
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"""
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"""
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
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"""
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"""
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"}
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"}
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"}
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"""
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"""
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"""
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"""
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
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"""
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"""
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"""
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"""
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
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"""
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"""
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"""
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"""
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"""
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.
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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
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"""
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"""
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"}
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"""
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"""
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"""
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"""
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"""
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
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"""
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"""
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"""
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"""
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"""
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"""
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
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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"""
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
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"""
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"}
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
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"""
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"""
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"""
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
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"""
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"""
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
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
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"""
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"""
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"""
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"""
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
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"""
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"""
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"""