EventTransactions
Returns data from the EventTransactions table.
Table Specific Information
SELECT
The Cvent API allows you to filter by certain fields when querying for data. The following fields can be filtered by the API:
- Id supports =,!=
- ProcessorTransactionId supports =,!=
- AttendeeId supports =,!=
- EventId supports =,!=
- Success supports =,!=
- PaymentType supports =,!=
- Created supports =,!=,>,<,>=,<=
- LastModified supports =,!=,>,<,>=,<=
All other filters are handled client-side.
The following is an example of a SELECT statement:
SELECT * FROM EventTransactions WHERE EventId = '3a366031-7541-4a44-9fde-bc0f81d3e940'
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | String | False |
The Id of the EventTransactions table. | |
| ProcessorTransactionId | String | False |
The ProcessorTransactionId of the EventTransactions table. | |
| JournalNumber | String | False |
The JournalNumber of the EventTransactions table. | |
| PaymentType | String | False |
The PaymentType of the EventTransactions table. | |
| PaymentMethod | String | False |
The PaymentMethod of the EventTransactions table. | |
| Success | Boolean | False |
The Success of the EventTransactions table. | |
| Date | Datetime | False |
The Date of the EventTransactions table. | |
| BatchNumber | String | False |
The BatchNumber of the EventTransactions table. | |
| ReferenceNumber | String | False |
The ReferenceNumber of the EventTransactions table. | |
| Amount | String | False |
The Amount of the EventTransactions table. | |
| Currency | String | False |
The Currency of the EventTransactions table. | |
| PaymentNote | String | False |
The PaymentNote of the EventTransactions table. | |
| Created | Datetime | False |
The Created of the EventTransactions table. | |
| CreatedBy | String | False |
The CreatedBy of the EventTransactions table. | |
| LastModified | Datetime | False |
The LastModified of the EventTransactions table. | |
| LastModifiedBy | String | False |
The LastModifiedBy of the EventTransactions table. | |
| EventId | String | False |
The EventId of the EventTransactions table. | |
| AttendeeId | String | False |
The AttendeeId of the EventTransactions table. |