RecurringApplicationCharges
Create, update, delete, and query Recurring Application Charges.
Table-Specific Information
Select
The driver processes all filters client-side within the driver. The following queries are the only ones processed server side:
SELECT * FROM RecurringApplicationCharges
SELECT * FROM RecurringApplicationCharges WHERE Id = '123'
You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria will be ignored and an unfiltered response will be returned.
Update
UPDATE RecurringApplicationCharges SET Test = 'true', Name = 'cd' WHERE Id ='2'
Delete
You must specify the Id of the recurring application charge to delete it.
DELETE From RecurringApplicationCharges WHERE Id ='2'
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Long | False |
The ID of the recurring application charge. | |
Name | String | False |
The name of the recurring application charge. | |
ApiClientId | String | False |
The API Client Id | |
Price | Decimal | False |
The price of the recurring application charge. The maximum price is 10,000. | |
Status | String | False |
The status of the recurring charge | |
ReturnUrl | String | False |
The URL where the merchant is redirected after accepting the charge. | |
BillingOn | Date | False |
The date and time (ISO 8601 format) when the customer was billed. | |
Test | String | False |
Whether the application charge is a test transaction. | |
CreatedAt | Datetime | False |
The date and time (ISO 8601 format) when the recurring application charge was created. | |
UpdatedAt | Datetime | False |
The date and time (ISO 8601 format) when the recurring application charge was last updated. | |
ActivatedOn | Datetime | False |
The date and time (ISO 8601 format) when the customer activated the recurring application charge. | |
CancelledOn | Datetime | False |
The date and time (ISO 8601 format) when the merchant canceled their recurring application charge. | |
TrialDays | Integer | False |
The number of days that the customer is eligible for a free trial. | |
TrialEndsOn | Datetime | False |
The date and time (ISO 8601 format) when the free trial ends. | |
DecoratedReturnUrl | String | False |
The decorated return url. | |
CappedAmount | String | False |
The limit a customer can be charged for usage based billing. If this property is provided, then you must also provide the terms property. | |
ConfirmationUrl | String | False |
The URL where the merchant accepts or declines the recurring application charge. | |
Terms | String | False |
The terms and conditions of usage based billing charges. Must be present in order to create usage charges, |